Update of /cvsroot/csvtosql/csvtosql_jdk50/doc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1274/doc
Modified Files:
WHATSNEW.txt
Log Message:
no message
Index: WHATSNEW.txt
===================================================================
RCS file: /cvsroot/csvtosql/csvtosql_jdk50/doc/WHATSNEW.txt,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** WHATSNEW.txt 25 Apr 2005 21:30:37 -0000 1.2
--- WHATSNEW.txt 6 Apr 2006 14:57:53 -0000 1.3
***************
*** 1,2 ****
--- 1,26 ----
+ Changes from csvtosql 3.0.0 to csvtosql 3.0.1
+ =============================================
+
+ * Daniel Marek <dan...@qb...>
+ We tried to use csvtosql to import some data directly to Oracle9i
+ database, but Exception ORA-00911: invalid character occurs ...
+ Problem is, that JdbcWriter/JdbcBatchWriter gets SQL statements from
+ storage and puts them directly into stmt.executeUpdate method. Every SQL
+ statement (String) contains as last character semicolon (as delimiter of
+ SQL statements), however stmt.executeUpdate() method expect this SQL
+ statement without any delimiter. Quick and dirty patch is to remove last
+ character of every statement, for example ...
+ Here is diff between
+ csvtosql_jdk50\src\net\sf\csv2sql\writers\JdbcWriter.java
+ and patched file
+ 95c95,96
+ < stmt.executeUpdate(getStorage().get(i));
+ ---
+ > String line = (String) getStorage().get(i);
+ > stmt.executeUpdate(line.substring(0,line.length()-1));
+ Well, it should be better to test, if last characted is semicolon, if
+ yes, remove it, if no, no action is necessary ...
+
+
Changes from csvtosql 2.2.0 to csvtosql 3.0.0
=============================================
***************
*** 14,18 ****
=============================================
! * Dana Cordes <blo...@us...
To the JdbcBatchWriter, I've added some additional debug reporting when
exceptions are thrown. I've also added a clearBatch() statement after
--- 38,42 ----
=============================================
! * Dana Cordes <blo...@us...>
To the JdbcBatchWriter, I've added some additional debug reporting when
exceptions are thrown. I've also added a clearBatch() statement after
|
