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
Error reading data from file
Chi Thien Phan
2015-07-02 23:12:05.0
hi,

i can not load data from my excel file cause following error. The demo excel file i will send you via mail.

Caused by: java.sql.SQLException: Syntax error: Stopped parse at ID41339(id133)
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.g(Unknown Source)
at com.hxtt.sql.by.o(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.am.if(Unknown Source)
at com.hxtt.sql.am.executeQuery(Unknown Source)

thx!
best regards,
Re:Error reading data from file
HXTT Support
2015-07-03 00:54:30.0
Passed test with the latest pacakge:
"jdbc:excel:///d:/test/excel/testxlsx/?maxScanRows=100;firstRowHasNames=true;",
select * from "Fertige_Auftraege_KW01-2015_bis_KW26-2015_1"."084744"

AufNr INTEGER 11 10 0
Kunde VARCHAR 7 7 0
KdNr INTEGER 11 10 0
ArtikelNr INTEGER 11 10 0
Stk INTEGER 11 10 0
ArtBez VARCHAR 8 8 0
ArtGrp VARCHAR 2 2 0
Formschluessel VARCHAR 32 32 0
Teil VARCHAR 2 2 0
SN VARCHAR 8 8 0
Arbeitsgang VARCHAR 12 12 0
Mitarbeiter VARCHAR 12 12 0
Zeitstempel TIMESTAMP 20 0 0
FW VARCHAR 7 7 0
LW VARCHAR 7 7 0
FT VARCHAR 14 14 0
FV INTEGER 11 10 0
LV INTEGER 11 10 0
UEF INTEGER 11 10 0
Status VARCHAR 1 1 0
Sperrgrund VARCHAR 4 4 0
EG INTEGER 11 10 0
erfassdatum DATE 10 0 0
175551 ABC 123 10143 1072736 1 ABC-Abbc NC NC88-C-888-8,8-8,8-R8,8-88-88-TK A1 FF 88888 Konstruktion M?ller, Otte 2015-04-09 13:01:26.0 2015.19 2015.20 Kein Fixtermin 0 0 12 F null 100 2011-04-08
Re:Re:Error reading data from file
Chi Thien Phan
2015-07-03 02:23:28.0
hi,

thx for your quick reply! I have downloaded the last version. But it does not help. Our program uses alias for column name and table name. I get error if i use alias like following sql statemen:

select 084744.Arbeitsgang ID41928, 084744.ArtBez ID41933, 084744.ArtGrp ID41938, 084744.ArtikelNr ID41943, 084744.AufNr ID41948, 084744.EG ID41953, 084744.FT ID41958, 084744.FV ID41963, 084744.FW ID41968, 084744.Formschluessel ID41973, 084744.KdNr ID41978, 084744.Kunde ID41983, 084744.LV ID41988, 084744.LW ID41993, 084744.Mitarbeiter ID41998, 084744.SN ID42003, 084744.Sperrgrund ID42008, 084744.Status ID42013, 084744.Stk ID42018, 084744.Teil ID42023, 084744.UEF ID42028, 084744.Zeitstempel ID42033, 084744.erfassdatum ID42038 from Fertige_Auftraege_KW01-2015_bis_KW26-2015_1.084744 084744 where 1=1

can you try execute my sql statement in your program and fix it if the same issue occurs?

thx

Re:Re:Re:Error reading data from file
HXTT Support
2015-07-03 04:30:11.0
You should user "" to encolsing 084744 and Fertige_Auftraege_KW01-2015_bis_KW26-2015_1. Because 084744 is a number, and - is a minus token.
For instance,
select A084744.Arbeitsgang ID41928, A084744.ArtBez ID41933, A084744.ArtGrp ID41938, A084744.ArtikelNr ID41943, A084744.AufNr ID41948, A084744.EG ID41953, A084744.FT ID41958, A084744.FV ID41963, A084744.FW ID41968, A084744.Formschluessel ID41973, A084744.KdNr ID41978, A084744.Kunde ID41983, A084744.LV ID41988, A084744.LW ID41993, A084744.Mitarbeiter ID41998, A084744.SN ID42003, A084744.Sperrgrund ID42008, A084744.Status ID42013, A084744.Stk ID42018, A084744.Teil ID42023, A084744.UEF ID42028, A084744.Zeitstempel ID42033, A084744.erfassdatum ID42038 from "Fertige_Auftraege_KW01-2015_bis_KW26-2015_1"."084744" A084744 where 1=1
Re:Re:Re:Re:Error reading data from file
Chi Thien Phan
2015-07-03 05:48:45.0
Hi,

thx for your reply! It works fine now.

best regards,
gtt

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