Trouble inserting structures using jc_insert

I am having problems inserting structures using jc_insert. Whenever I try to insert any structure, I get the following error message:

Code:

ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: Statement 'INSERT INTO JOET.CHEMICALS (cd_id, 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(?, ?, ?, ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' failed for structure '   Marvin  10280510432D  10 11  0  0  0  0

I'm new to JChem, but all the question marks would make me think that some how my data is not making its way into the function which is generating this sql statement. However, it does seem to pick up the structure information because it displays the initial contents of the mol file.





I am running JChem 3.1.1 on Windows XP with Oracle 9.2.

Please, could you post the Java stack trace to be found in the Oracle session logfile. (The session log files are either located in $ORACLE_BASE/admin/<your-database-name>/udump or $ORACLE_HOME/admin/<your-database-name>/udump.)

I found the error. It a problem in the constraints that I put on the table.