I am having a hard time getting the Text and Excel drivers working at the same time. I am using a demo version of the Excel driver and a purchased version of the Text driver.
I downloaded and placed in the classpath "HXTT_Common_JDBC30.jar", "Text_Core_JDBC30.jar" and "Excel_Core_JDBC30.jar".
I always get this error:
at com.hxtt.sql.text.e.(Unknown Source)
at com.hxtt.sql.text.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
-Edwin S. Ramirez-
You should have an older HXTT_Common_JDBC30.jar file according to your download history. If those jar files are released at the same day, it can work.
Currently, I've purchased two of your products: Text & DBF. I am would like to purchase the Excel product as well, but I need them all working at the same time.
What is the best way to find all the Core versions that belong to a particular Common jar.
-Edwin S. Ramirez-
In fact, you needn't to use Common jar, which is providing because some professional users like to integrate some tiny packages.
Just remove all core and common package files , then download and update batch your Text_JDBC30.jar, DBF_JDBC30.jar, and Excel_JDBC30.jar, you won't be confused again. To know the detailed version information of HXTT DBF package?
1st way: "java com.hxtt.sql.dbf.DBFDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.
BTW, HXTT DBF 4.0, Text (CSV) 4.0, and Excel 2.0, will be released in 24 hours, then you can download those package:)
For HXTT DBF:
* v4.0.001 supports memory (.mem) file.
* v4.0.001 supports INTO variable[,...] for SELECT sql.
* v4.0.001 supports SET variable = expression [,...].
* v4.0.001 supports DECLARE Local Variables.
For HXTT Text (CSV):
# v4.0.001 supports INTO variable[,...] for SELECT sql.
# v4.0.001 supports SET variable = expression [,...].
# v4.0.001 supports DECLARE Local Variables.
# For data export purpose, v3.1.085's will detect numeric(precision, scale) type and varchar(maxDataLength) type when maxScanRows=0 and readOnlyMode=true. ResultSetMetaData.getColumnDisplaySize() can still be used to know the max data length for all data types.