Csvtosql Free and open source CVS conversion tool
Download

Csvtosql Ranking & Summary

Csvtosql Tags

read write convert convert csv csv converter write sql list

Csvtosql Description

Free and open source CVS conversion tool CsvToSql is a free and open source, Java based, configurable and expandable conversion tool and library.You can define the structure of data how render and where write it through a descriptor. Is compatible with the most common rdbms. Here are some key features of "Csvtosql": · can read data from comma separated value file · can read data from excel files multiple output: · can write list of sql statements to console · can create text file with the list of sql statements · can store data to jdbc resource (database) Requirements: · Java 5 What's New in This Release: · 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_jdk50src · etsfcsv2sqlwritersJdbcWriter.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.

Csvtosql Related Software