User b1fdf71dd3
28-02-2015 16:47:38
I'm running Instant JChem 6.1.3 on a MacBook Pro (2.7 GHz Intel Core i7 processor, 16 GB RAM, 750 GB SSD) with OS X 10.9.5. I'm working with a structure database containing ~30,000 records, and have started getting an error message that is appearing more and more frequently, but unpredictably. Typically, it occurs when I'm trying to add a new Chemical Terms field to the database. A good example is when I generate InChI notation for the records. I get the following "exception" message:
java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
Caused: java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.checkStatus(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at chemaxon.jchem.db.CTColumnRegenerator.getNextMolData(CTColumnRegenerator.java:149)
at chemaxon.jchem.db.CTColumnRegenerator.access$300(CTColumnRegenerator.java:38)
at chemaxon.jchem.db.CTColumnRegenerator$RegenThread.run(CTColumnRegenerator.java:96)
Caused: java.lang.RuntimeException
at chemaxon.jchem.db.CTColumnRegenerator.createRunRegenThreads(CTColumnRegenerator.java:382)
at chemaxon.jchem.db.CTColumnRegenerator.run(CTColumnRegenerator.java:295)
[catch] at com.im.ijcs.impl.ddl.JChemTableManagerImpl$6.run(JChemTableManagerImpl.java:2148)
At that point, the field generation stops and I end up with an incomplete field. Restarting IJC doesn't seem to help, nor does rebooting the computer. Occasionally, when I re-open IJC I get a message telling me that I'm already logged-in to the database, and asking me to confirm log-out of the previous session. This seems to help the problem a little, but eventually the exception re-appears.
Thinking that perhaps I have a corrupted database, I exported the DB as an SDF file and then re-imported it into a new DB without any of the calculated fields (just structures and a few text fields). I still get the same exception in that case.
I've attached the IJC log file from one instance of this error.
Can anyone help? Thanks in advance.
Lee