Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.193
  Buy Now
  HXTT Cobol 5.0.193
  HXTT DBF 7.1.194
  HXTT Excel 6.1.197
  HXTT Json 1.0.165
  HXTT Paradox 7.1.193
  HXTT PDF 2.0.193
  HXTT Text(CSV) 7.1.193
  HXTT Word 1.1.193
  HXTT XML 4.0.194
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

Compatibility of demo version with live Excel/Text drivers
Paul Gibbs
2018-06-13 00:09:28.0
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 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 Source)
at com.hxtt.sql.b0.a(Unknown Source)
at Source)
at Source)
at Source)
at Source)
at com.internationalpresence.databaseserver.HTXXAcessDemo.main(

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();
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.
Re:Compatibility of demo version with live Excel/Text drivers
HXTT Support
2018-06-13 00:41:09.0
Your Acess_JDBC40.jar should be newer than Text and Excel driver. You should login to download the latest Text and Excel driver.

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap