Create table bug with HSQLDB

I added 2 fields to the table creation SQL, one of which (CODE) is non


nullable, and got the error





java.sql.SQLException: Attempt to insert null into a non-nullable column: column


: CODE table: JCHEM_STRUCTURES in statement [INSERT INTO JCHEM_STRUCTURES (


cd_structure,


cd_smiles,


cd_formula,


cd_molweight,


cd_hash,


cd_flags,


cd_timestamp,


cd_fp1,


cd_fp2,


cd_fp3,


cd_fp4,


cd_fp5,


cd_fp6,


cd_fp7,


cd_fp8,


cd_fp9,


cd_fp10,


cd_fp11,


cd_fp12,


cd_fp13,


cd_fp14,


cd_fp15,


cd_fp16) VALUES (?,?,?,?,?,?,NOW(),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]


at org.hsqldb.jdbc.Util.throwError(Lorg.hsqldb.Result;)V(Unknown Source)





at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate()I(Unknown Source)


at chemaxon.jchem.db.UpdateHandler.execute(Z)I(UpdateHandler.java:1520)


at chemaxon.jchem.db.UpdateHandler.execute()V(UpdateHandler.java:1386)


at chemaxon.jchem.db.TableInfo.createTable(Lchemaxon.util.ConnectionHandler;Lchemaxon.jchem.db.DatabaseOptions;Ljava.lang.String;IIIILjava.lang.String;ZLjava.lang.String;Ljava.lang.String;Ljava.lang.String;)V(TableInfo.java:802)


at chemaxon.jchem.gui.Creator.run()V(Creator.java:92)


at java.lang.Thread.run()V(Unknown Source)


at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)





This update statement (a test?) does not include my two custom fields,


which seems wrong in and of itself. Also the fact that the error didn't


seem to faze the admin program.





Later the import job seems to have correctly imported the custom


fields in question, though, so whatever happened above is apparently


harmless.

Hi,





This is a truly harmless error message indeed.





Thank you for reporting this, we will fix it in future versions.





Best regards,





Szilard