User 773d472e7f
06-07-2014 20:30:19
I have data in Oracle and imported an SDF into a local database. I would like to see tthe overlap between these two databases using the overlap tool.
I get this error, see below:
Alex
Starting overalap analysis
Running Duplicate overlap analysis for Molecules as query and Akos Moltable as target
Options are: sep=, t:d,tautomerSearch:n,maxResults:10
Using max hit count of 10
Created field AKos_Number count
Created field AKos_Number hits
Starting searches...
Error: Unexpected error during search for structure 1
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Konvertierung zu interner Darstellung nicht erfolgreich; nested exception is java.sql.SQLException: Konvertierung zu interner Darstellung nicht erfolgreich
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:236)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:418)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Konvertierung zu interner Darstellung nicht erfolgreich
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 8 more
Error: Unexpected error during search for structure 2
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Konvertierung zu interner Darstellung nicht erfolgreich; nested exception is java.sql.SQLException: Konvertierung zu interner Darstellung nicht erfolgreich
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:236)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:418)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Konvertierung zu interner Darstellung nicht erfolgreich
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 8 more
ChemAxon 2bdd02d1e5
10-07-2014 09:24:48
Hi Alex,
this is a bug when the target table has ID column represented as text (e.g. VARCHAR2).
Thanks for your report, we recorded it for fixing.
Filip
User 773d472e7f
15-07-2014 19:28:12
Thanks, I am waiting. It works if both files are in DERBY.
Alex
User 773d472e7f
27-03-2015 09:51:33
Starting overalap analysis
Running Duplicate overlap analysis for Molecules as query and Akos Moltable as target
Options are: sep=, t:d,maxResults:10,tautomerSearch:n
Using max hit count of 10
Created field AKos count
Created field AKos hits
Starting searches...
Error: Unexpected error during search for structure 1
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 2
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 4
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 5
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 7
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 8
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 9
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 10
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 12
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 13
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 15
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 17
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Error: Unexpected error during search for structure 18
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representation
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler.run(JChemCartridgeSearchHandler.java:88)
at com.im.df.query.JChemSearchCapability.execute(JChemSearchCapability.java:239)
at com.im.df.query.JChemSearchCapability$AbstractStandardSearch.executeOverlapAnalysis(JChemSearchCapability.java:422)
at com.im.ijc.chem.overlap.wizard.OverlapAnalysisWizardAction$1.run(OverlapAnalysisWizardAction.java:82)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at com.im.df.impl.db.entity.JChemCartridgeSearchHandler$2.extractData(JChemCartridgeSearchHandler.java:115)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Searches complete
ChemAxon 26d92e5dcd
27-03-2015 11:18:35
Dear Alex,
I am sorry, but the fix for this problem has not yet been done, but it is planned for the first quarter of this year. I have raised the priority of this issue.
I am sorry for the inconvenience
David
User 773d472e7f
31-03-2015 09:42:27
Thank you for promoting the issue!