You might want to take a look at the spreadsheet import tool at
http://www.xoetrope.com/xui/demos#spreadsheet
It currently works with MS SqlServer, HSQLDB and we currently are
testing it with Derby (and it shouldn't take very long to get this
working). The tool is intended to enable repeated import of excel sheets
rather than just a one off import.
Saleem Edah-Tally wrote:
Hello,
I used to import data with CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE procedure with
success in JAVA.
The following doesn't work any more :
CALL
SYSCS_UTIL.SYSCS_IMPORT_TABLE('NMSET', 'PAYS', '/home/user/tmp/jbb/lst_pays.csv',
null, null, null, 1)
The error message is :
The exception 'java.sql.SQLException: No current connection.' was thrown while
evaluating an expression.
I'm sure there is a connection, the same which created the statement :
protected boolean importTableDataCOUNTRIES() {
try {
java.sql.Statement st =
conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
java.sql.ResultSet.CONCUR_UPDATABLE);
String sql = "";
sql = "CALL
SYSCS_UTIL.SYSCS_IMPORT_TABLE('NMSET', 'PAYS', '/home/user/tmp/jbb/lst_pays.csv',
null, null, null, 1)";
st.executeUpdate(sql);
return true;
} catch (SQLException ex) {
debug(ex.getMessage());
}
return false;
}
The database is not being accessed by another application. The table does
exist. The CSV file is comma separated and strings are enclosed by ".
Any clue how to resolve it ?
Thank you.
*******************************************
Support fight against software patents :
http://noepatents.org/
*******************************************
Free your files : Visit OpenOffice.org
-------------------------------------------
NO FORCED SOFTWARE SALE
http://www.racketiciel.info/
*******************************************
