java.sql.SQLException: Unexpected token: ) in statement [INSERT INTO sureshtable

[s.thinkbig]

Hi All,

Can you throw some light on this. I always getting this error.

-----------------------------------------------------

hsqldb/isomorphic
=== 2008-07-15 15:32:33,895 [sor4] ERROR AdminConsole - [adminConsole.importData
Sources] There was a problem importing datasource 'suresh'. The error report be
java.sql.SQLException: Unexpected token: ) in statement [INSERT INTO sureshtable
() VALUES ()]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:307)
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:298)
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:377)
at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.ja
va:205)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:642)
at com.isomorphic.sql.SQLDataSource.executeMultipleInsert(SQLDataSource.
java:684)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:570)
at com.isomorphic.sql.SQLDataSource.execute(SQLDataSource.java:161)
at com.isomorphic.tools.SQLImport.importData(SQLImport.java:817)
at com.isomorphic.tools.SQLImport.processSQLDataSource(SQLImport.java:42
0)


Regards,
Suresh

[Isomorphic]

Well, it looks like the generated SQL statement has no fields or values, which is a syntax error. Can you share your DataSource definition?