|
|
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)
HXTT Excel
|
HXTT Excel JDBC Adapter |
Kabir Sondhi |
2010-01-15 13:10:02 |
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 |
>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 |
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 |
>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.
|
|
|
Main
webmaster@hxtt.com