tracker issue : CF-3516357

select a category, or use search below
(searches all categories and all time range)
Title:

Connection verification failed for data source: csvfiles

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): / ext-user (Swaraj Kumar Mitra)

Created: 03/08/2013

Components: Database, JDBC

Versions: 10.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 283649 /

Priority/Frequency: Trivial / All users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 0

Problem:
Customer has been using a iNet Fositex CSV JDBC driver.  It allows to read CSV files like database tables, defining the file layouts in a schema.ini.   It is easy to add the folder the JAR file is in to the CF classpath, and setup the Other type JDBC driver.  It works well in ColdFusion 9 but not in CF10, getting below error:

Connection verification failed for data source: csvfiles
java.lang.AbstractMethodError: com.inet.csv.o.getJDBCMajorVersion()I
The root cause was that: java.lang.AbstractMethodError: com.inet.csv.o.getJDBCMajorVersion()I

Method:
a)	Unzip the 2 files into folders on disk.  For us, they go under c:\e$\  as csvfiles and csvjdbc.
b)	Add the csvjdbc folder to the ColdFusion Class Path.  See screen shot #1 below.
c)	Restart CF for the Java setting to take effect.
d)	Setup the JDBC Other data source.  See screen shot #2 below.


Result:
Getting below error:
Connection verification failed for data source: csvfiles
java.lang.AbstractMethodError: com.inet.csv.o.getJDBCMajorVersion()I
The root cause was that: java.lang.AbstractMethodError: com.inet.csv.o.getJDBCMajorVersion()I

Expected:
Should be able to add data source successfully. 

Workaround:
NA

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3516357

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

  1. March 09, 2013 00:00:00: 1_csvjdbc.zip
  2. March 09, 2013 00:00:00: 2_csvfiles.zip
  3. March 09, 2013 00:00:00: 3_184116366_-_CF10..msg

Comments:

Why should this be a bug in ColdFusion? We are on JDBC 4.0 and we expect the driver to be on this.This clearly looks like the driver here is not on JDBC 4.0 compliant.
Comment by Rupesh K.
16078 | December 03, 2013 07:16:13 AM GMT