Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
attachexportetkeys - name generation fails
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Tobias

Joined: 26 Jan 2005
Posts: 580

View user's profile

Back to top
Link to postPosted: Sat Mar 21, 2009 12:26 amPost subject: attachexportetkeys - name generation fails Reply with quote

Hi,

I have a normal DB tried to calculate IUPAC names and got the follwoing errors.

Only difference was that duplicate filtering was on and I renamed the database.


See attached doc, impossible to copy as text

Ijchem version 4.2


Tobias




----

Randomly I also get





java.sql.SQLException: Connection connection is closed is closed.
    at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:354)
    at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:310)
    at com.im.df.core.DatabasePlatform.attachExportedKeys(DatabasePlatform.java:3180)
Caused: org.springframework.jdbc.UncategorizedSQLException: attachExportedKeys; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Connection connection is closed is closed.; nested exception is java.sql.SQLException: Connection connection is closed is closed.
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
    at com.im.df.core.DatabasePlatform.attachExportedKeys(DatabasePlatform.java:3193)
    at com.im.df.core.DatabasePlatform$SchemaSnapshot.createSnapshot(DatabasePlatform.java:3284)
    at com.im.df.core.DatabasePlatform$SchemaSnapshot.<init>(DatabasePlatform.java:3250)
    at com.im.df.core.DatabasePlatform.refreshSchemaTables(DatabasePlatform.java:2597)
    at com.im.df.impl.db.DBSchemaImpl.refreshSchemaTables(DBSchemaImpl.java:593)
    at com.im.ijc.core.ds.SchemaConnectionDataObject$SC.run(SchemaConnectionDataObject.java:237)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)



 Filename: error-sqlkey.doc    Filesize: 30 KB    Downloaded: 320 Time(s)
 Description:  
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Mon Mar 23, 2009 10:52 amPost subject: Reply with quote

We are looking to solve this, but are so far having difficulty reproducing it, as it seems to be a rare and random event.
If you have any steps that make it happen reproducibly then please let us know.
Tim
fzimandl

Joined: 23 Jun 2011
Posts: 434

View user's profile

Back to top
Link to postPosted: Wed Oct 12, 2011 8:34 amPost subject: Reply with quote

Fixed in IJC 2.5.

This topic is locked: you cannot edit posts or make replies.
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum