Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT XML v3.0
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)

HXTT ACCESS
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 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.
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




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2018 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap