User cb6c8cdd0f
13-03-2006 03:52:11
I am getting the following error when trying to import an SDF file via java code:
chemaxon.jchem.db.TransferException: ERROR: column "cd_fp14" specified more than once
I am using the latest version of jchem (3.1.5) and postgresql.
Here is the full stack trace:
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
at chemaxon.jchem.db.UpdateHandler.execute(UpdateHandler.java:893)
at chemaxon.jchem.db.UpdateHandler.execute(UpdateHandler.java:816)
at chemaxon.jchem.db.FileToSQLHandler.importFile(FileToSQLHandler.java:230)
at chemaxon.jchem.db.Importer.importMols(Importer.java:306)
at final2.main(final2.java:32)
problem: chemaxon.jchem.db.TransferException: ERROR: column "cd_fp14" specified more than once
....
another problem I have is this:
"chemaxon.jchem.db.PropertyNotSetException: Auto-increment property not set"
This goes away when I add db.isAutoIncrementProperty to the JChemProperties table. However, I don't think I should have to do this because jcman import feature works fine without this.
chemaxon.jchem.db.TransferException: ERROR: column "cd_fp14" specified more than once
I am using the latest version of jchem (3.1.5) and postgresql.
Here is the full stack trace:
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
at chemaxon.jchem.db.UpdateHandler.execute(UpdateHandler.java:893)
at chemaxon.jchem.db.UpdateHandler.execute(UpdateHandler.java:816)
at chemaxon.jchem.db.FileToSQLHandler.importFile(FileToSQLHandler.java:230)
at chemaxon.jchem.db.Importer.importMols(Importer.java:306)
at final2.main(final2.java:32)
problem: chemaxon.jchem.db.TransferException: ERROR: column "cd_fp14" specified more than once
....
another problem I have is this:
"chemaxon.jchem.db.PropertyNotSetException: Auto-increment property not set"
This goes away when I add db.isAutoIncrementProperty to the JChemProperties table. However, I don't think I should have to do this because jcman import feature works fine without this.