Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.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 Excel
NullPointerException
Jim Hobday
2011-08-15 03:51:14.0
I have a simple test spreadsheet XLS version with three columns
location id, name, county
111, Milton Keynes, Buckinghamshire
112, Chalfont St Giles, Buckinghamshire
117, Amersham,
113, Aylesbury, Buckinghamshire
114, Bedford, Bedfordshire
115, Luton,
116, Leighton Buzzard,

The County column has three "NULL" celld for 117, 115 and 116. Any select including "county" produces an NPE. If I enter a space in the three cells there is no problem (except that I want them to be nulls)

sqlCount=SELECT count(county), min(county), max(county) from "HasCountyNulls.xls".Locations
java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.e.a.a(Unknown Source)
at com.hxtt.e.a.if(Unknown Source)
at com.hxtt.sql.du.a(Unknown Source)
at com.hxtt.sql.du.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at com.hxtt.sql.al.a(Unknown Source)
at com.hxtt.sql.al.a(Unknown Source)
at com.hxtt.sql.al.executeQuery(Unknown Source)
at com.sentences.rdb.RdbMappingChapter.sampleRdbData(RdbMappingChapter.java:4393)

I downloaded the HXTT.zip 13.03MB today (link from Simon@lazysoft.net - who purchased the excel driver) so it must be the latest one. The manifest includes:
Name: com/hxtt/sql/excel/
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-Title: com.hxtt.sql.excel
Implementation-Version: 4.0.022 on August 02, 2011
Specification-Vendor: Hongxin Technology & Trade Ltd.
Specification-Title: HXTT Excel JDBC 4.0 Package
Implementation-URL: http://www.hxtt.com/excel.html
Specification-Version: 4.0.022 on August 02, 2011
Comment: JDBC 4.0 Package for MS Excel

Thanks
Jim
Re:NullPointerException
HXTT Support
2011-08-15 03:57:15.0
Please email us the HasCountyNulls.xls sample. Thanks.
Re:NullPointerException
HXTT Support
2011-08-15 04:28:23.0
Checked and fixed.
Re:Re:Re:NullPointerException
Jim Hobday
2011-08-15 04:33:30.0
Thank you - very speedy.

So how often do you create builds? When can I download the latest?

Jim
Re:Re:Re:Re:NullPointerException
HXTT Support
2011-08-15 04:49:55.0
Since your second issue has been canceled. It will be availalbe after about 2 hours.
Re:Re:Re:Re:Re:NullPointerException
Jim Hobday
2011-08-15 04:52:16.0
brilliant - thanks
Re:Re:Re:Re:Re:Re:NullPointerException
HXTT Support
2011-08-15 06:13:40.0
Please download the latest package.
Re:Re:Re:Re:Re:Re:Re:NullPointerException
Jim Hobday
2011-08-15 06:38:49.0
Sorry but the download page still has the 2nd August version:
Excel JDBC 4.0 Package 1,279Kb 2011-08-02 07:49

Do I go somewhere else for the latest packages?
Re:Re:Re:Re:Re:Re:Re:Re:NullPointerException
HXTT Support
2011-08-15 06:51:44.0
Please relogin and download it.
Re:Re:Re:Re:Re:Re:Re:Re:NullPointerException
Jim Hobday
2011-08-15 06:55:24.0
I can confirm that is fixed.

Thank you for such a fast service.

Jim

Search Key   Search by Last 50 Questions




Google
 

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