dear hxtt,
i think there is a bug in CSV driver regarding writing data inside ftp or smb
to reproduce the bug:
1. i have a csv file with three columns a,b,c
2. access this file with ftp or smb url
example:
jdbc:CSV:smb://user:user@localhost/c$/afolder?_CSV_Header=true;_CSV_Separator=\u002C;csvfileExtension=csv;_CSV_Quoter=\u0022;
or
jdbc:CSV:ftp://user:user@localhost?_CSV_Header=true;_CSV_Separator=\u007C;csvfileExtension=csv;_CSV_Quoter=\u0022;
3. execute: "insert into data1t values('1','2','3')"
4. the output row is only "2,3", missing out the first column and shifted all the data
this problem does not happen when i use local url example:
jdbc:CSV:////afolder?_CSV_Header=true;_CSV_Separator=\u002C;csvfileExtension=csv;_CSV_Quoter=\u0022
|
That's resulted by SAMBA file can't get the correct file size in time.
2014-08-08 fixed an insert bug on SAMBA CSV file.
|
Hello,
where can i download the fixed version ?
thank you
|
|
Checked. Your version is too old, and you should click the Renew Support/Service link on your download page to get the latest version.
|
|
Now you can download the latest version.
|
Dear hxtt,
after repeating the test above using the new driver:
(http://www.hxtt.com/downloadagent.jsp?product=Text_JDBC40.jar)
Text JDBC 4.0 Package for JDK 1.6.X, JDK1.7.X, and JDK1.8.X 1,413Kb 2014-08-08 10:33
the result is not yet correct
1. i have a csv file with three columns a,b,c
2. access this file with ftp
jdbc:CSV:ftp://user:user@localhost?_CSV_Header=true;_CSV_Separator=\u007C;csvfileExtension=csv;_CSV_Quoter=\u0022;
3. execute: "insert into data1t values('1','2','3')"
4. the output file (data1t.csv) is not changed at all (viewed using notepad)
5. when query "select * from data1t" the result is:
column name: a,b,c1,2,3 --> data becomes new column
rows: 0 rows
6. repeating another insert command, the result stays like point 4 & 5
7. quit app
8. the file(data1t.csv) still not changed
9. has confirmed this is not permission problem, because i have tested to put a file using ftp client
can you give assistance ?
thank you
regards
|
Main
webmaster@hxtt.com