to reproduce the bug:
1. i have a file "data.csv" which content is:
a,b
"a",1
2. connect with hxtt csv via smb, example:
jdbc:CSV:smb://user:user@localhost/c$/afolder?_CSV_Header=true;_CSV_Separator=\u007C;csvfileExtension=csv;_CSV_Quoter=\u0022;;_CSV_EOL=\u000A;
3. execute "select * from data"
4. Error occured: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: -1
5. this error not happen when testing the same above scenario with local folder / ftp folder
stack:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: -1
at com.hxtt.c.r.B(Unknown Source)
at com.hxtt.sql.text.b.a(Unknown Source)
at com.hxtt.sql.text.b.f(Unknown Source)
at com.hxtt.sql.text.b.aS(Unknown Source)
at com.hxtt.sql.text.b.(Unknown Source)
at com.hxtt.sql.text.l.c(Unknown Source)
at com.hxtt.sql.text.l.b(Unknown Source)
at com.hxtt.sql.text.a.a(Unknown Source)
at com.hxtt.sql.text.a.a(Unknown Source)
at com.hxtt.sql.text.f.a(Unknown Source)
at com.hxtt.sql.b0.if(Unknown Source)
at com.hxtt.sql.d4.a(Unknown Source)
at com.hxtt.sql.d4.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.d6.execute(Unknown Source)
can you please give assitance
thank you
regards
|
Checked. It should throw
character , can't follow quote character " while data is begined with quote character. Data: "a",
The error message will be fixed after solve two other issue.
You should use CSV_Separator=\u002C; to replace CSV_Separator=\u007C;
|
thank you, it was my mistake to use wrong CSV_Separator
regards
|
Main
webmaster@hxtt.com