However when testing the 30-day trial version of the jar (Acess_JDBC40.jar) I have run into some compatibility issues with the existing drivers above. This is the error that I am receiving:
Exception in thread "main" java.lang.NoSuchMethodError: com.hxtt.sql.common.b.b5()Ljava/lang/String;
at com.hxtt.sql.access.r.if(Unknown Source)
at com.hxtt.sql.b0.do(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.an.a(Unknown Source)
at com.hxtt.sql.an.a(Unknown Source)
at com.hxtt.sql.an.if(Unknown Source)
at com.hxtt.sql.an.executeQuery(Unknown Source)
at com.internationalpresence.databaseserver.HTXXAcessDemo.main(HTXXAcessDemo.java:28)
And here is the code sample:
String url = "jdbc:access:///f:/temp/Database1.accdb";
String sql = "select * from employees";
Connection con = DriverManager.getConnection(url, "", "");
Statement stmt = con.createStatement();
stmt.setFetchSize(10);
ResultSet rs = stmt.executeQuery(sql);
(Note the last line is where it fails)
If I remove Text_JDBC4.0 and Excel_JDBC4.0 from the classpath it produces the expected result which is why I'm wondering if it's a compatibility issue or not using correct driver jar when more than one hxtt driver in classpath
Are there updated versions of these jars that we need to use, or is it because we are mixing a trial version with full versions? Please note that we have only recently upgraded the Text driver to (V6.0) so that it works with the Excel driver (V5.0)
JRE is 1.8.0_161, Operating System is Windows 10 Professional (64 bit)
Let me know if there's any other information you need, we will need to prove the Access driver works in conjunction with the other two drivers before we can go ahead with purchasing.
|
Your Acess_JDBC40.jar should be newer than Text and Excel driver. You should login to download the latest Text and Excel driver.
|