Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Excel
HXTT Excel JDBC Adapter
Kabir Sondhi
2010-01-15 13:10:02.0
Hey,

I was evaluating your HXTT Excelv2.2 jdbc adapter. I am looking for a jdbc adapter to read and write to excel. I've noticed your adapter has overcome the shortcomings of the sun jdbc adapter (which uses a windows sDsn). Your adapter is able to read strings in numeric columns (when the column has mixed data types). What I'm wondering is, is development for this adapter still ongoing i.e are future versions going to be released. Is there going to be a version available that reads xlsx files i.e Excel files that are created from Microsoft Excel versions greater than 2003.

Thanks,
Re:HXTT Excel JDBC Adapter
HXTT Support
2010-01-15 17:21:56.0
>Is there going to be a version available that reads xlsx files i.e Excel files
> that are created from Microsoft Excel versions greater than 2003.
It's in schedule, and should be supported in this year.
Re:Re:HXTT Excel JDBC Adapter
Kabir Sondhi
2010-01-18 10:30:20.0
Hey,

Thanks for the quick reply to the first email. I am continuing to evaluate your product and had a few more questions. I would appreciate it if you could answer them.

1. I am using the 30-day trial version. In that, when I use ResultSetMetaData object to retrieve the column type i.e metaData.getColumnTypeName(i), It returns JAVA_OBJECT for mixed columns (columns with varchars and numeric). I was looking over other questions in this "forum" and have seen that for other people, they get the exact column type i.e varchar or numeric rather than java_object. Does that mean that only the trial version returns "java_object" and the full version would return the proper object type?

2. It is my understanding that by modifying the connectionString, I can get the driver to look at all rows in a column before deciding what the column type should be. Is that correct? Also, how big of a performance hit is it i.e noticible or just a couple extra seconds?

3. Going by the Q & A on this forum, your driver does allow DELETE statements to be handed out?

4. The sun excel driver doesn't allow updates to columns that have formulas. Does yours allow?

5. Does your driver support database functions i.e ASCII,CHAR,CONCAT,LCASE,LEFT,LENGTH,LOCATE,LOCATE_2,LTRIM,RIGHT,RTRIM,SPACE,SUBSTRING,UCASE (these are functions that the sun driver supports).

6. As for licensing, if we wish to ship the driver (jar file) with our commercial product, how much is the license?

Once again, I appreciate you taking the time to answer these questions.

Sincerely,
Re:Re:Re:HXTT Excel JDBC Adapter
HXTT Support
2010-01-19 02:56:00.0
>metaData.getColumnTypeName(i), It returns JAVA_OBJECT for mixed columns (columns
>with varchars and numeric).
If it contains only string value, it will return varchar. If it contains only number, it will return double. It will return JAVA_OBJECT if there're string, date, and number in the same column.

>I can get the driver to look at all rows in a column before deciding what the column type should be. Is that correct?
Yeah. maxScanRows can do it. If there's date value at the 10th rows, and all of the 9th rows are string value, it wll return VARCHAR when maxScanRows=8;

>Also, how big of a performance hit is it i.e noticible or just a couple extra
>seconds?
No performance issue. Because Excel is a special sheet which need to parse total content.

>3. Going by the Q & A on this forum, your driver does allow DELETE statements
>to be handed out?
Yeah. You can even CREATE/DELETE an xls file or sheet.

>4. The sun excel driver doesn't allow updates to columns that have formulas.
>Does yours allow?
Yeah. It doesn't support formulas, but won't corrupt your sheet.

>5. Does your driver support database functions i.e >ASCII,CHAR,CONCAT,LCASE,LEFT,LENGTH,LOCATE,LOCATE_2,LTRIM,RIGHT,RTRIM,SPACE,
>SUBSTRING,UCASE (these are functions that the sun driver supports).
You can use about 230 sql function at Scalar Functions and Aggregate Functions

>6. As for licensing, if we wish to ship the driver (jar file) with our
>commercial product, how much is the license?
You can find some price information at here.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap