I am installing the driver into WebSphere 6.0. I get the 'Class not found error" and the system cannot find com.hxtt.sql.dbf.DBFDriver. DBFDriver is NOT in Access_JDBC30.jar. How is the system supposed to find it?
Am I Missing some files?
Thanks!
|
>com.hxtt.sql.dbf.DBFDriver. DBFDriver is NOT in Access_JDBC30.jar.
Yeah. You should use com.hxtt.sql.access.AccessDriver since you're using HXTT Access driver.
|
When using the driver I get this error:
DataSource class cannot be used as one-phase: ClassCastException: com.hxtt.sql.access.AccessDriver, error code: NOT_A_1_PHASE_DS.
|
if I use com.hxtt.sql.access.AccessDriver as the Implementation class name I get the "DataSource class cannot be used as one-phase: ClassCastException: com.hxtt.sql.access.AccessDriver, error code: NOT_A_1_PHASE_DS." error. It also says that url is not a property of the driver. This does not appear to be the correct driver.
If I use com.hxtt.sql.HxttConnectionPoolDataSource as the implementation class name (seems like the right one to me) I get the error:"com.hxtt.sql.dbf.DBFDriver not found". That file does not exist in the package , as you have noted above.
If I add driverClassName as a custom property to HxttConnectionPoolDataSource implementation class and set it to "com.hxtt.sql.access.AccessDriver" I still get the DBF not found error, and driverClasName is not recognized by the impl class.
I am at a loss as to the correct combination of files for setting up a JNDI named connection in WebSphere 6.1
Thanks for your help
|
>DataSource class cannot be used as one-phase: ClassCastException: >com.hxtt.sql.access.AccessDriver, error code: NOT_A_1_PHASE_DS.
You can download a pdf guide from here. You can try com.hxtt.sql.HxttDataSource or com.hxtt.sql.HxttConnectionPoolDataSource .
>If I use com.hxtt.sql.HxttConnectionPoolDataSource as the implementation class
> name (seems like the right one to me) I get the
>error:"com.hxtt.sql.dbf.DBFDriver not found".
The simplest way is replace all dbf with access, and DBF with Access. You can try
url
jdbc:access:///d:/accessfiles
at http://www.hxtt.com/access/faq.html#interoperability
|
Perfect! It works. You should make the documentation more clear to indicate that the driver is different based on what you indicate in the URL.
JDBC:ACCESS:// vs. JDBC:DBF://
Thanks!
|