|
|
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)
HXTT Excel
|
Error reading data from file |
Chi Thien Phan |
2015-07-02 23:12:05 |
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 |
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 |
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 |
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 |
Hi,
thx for your reply! It works fine now.
best regards,
gtt
|
|
|
Main
webmaster@hxtt.com