During processing, the first column is processed without error.. when it tries to process the second column I get the following:
Inner: java.sql.SQLException: Failed to define a table view C:\mark\pano\yaho
o\deliverable1\samp3\file4a.csv because its relative table is open.^M
Caused by: java.sql.SQLException: Failed to define a table view C:\mark\pano
\yahoo\deliverable1\samp3\file4a.csv because its relative table is open.^M
jdbc:csv:/c:/mark/pano/yahoo/deliverable1/samp3?schemaFile=schema.sql,,user=,password=,_CSV_Header=false
,_CSV_Separator=\t}
|
It seems that you've opened more than on connection(or statement), and one connection(or statement) is using file4a.csv table, and another new connection (or statement) wish to load CREATE TABLE sqlfor the same table. You can modify your schema file, and add "if not exists" clause to all create table to avoid the collision. For instance,
CREATE TABLE if not exists file4a ...;
That's all.
|
|
that was the solution. Thank you.
|
|
BTW, please download the latest JDBC3.0 package:)
|
Main
webmaster@hxtt.com