[ https://forge.continuent.org/jira/browse/SEQUOIA-1041?page=all ] Emmanuel Cecchet closed SEQUOIA-1041: -------------------------------------
SEQUOIA-1052 is now fixed > Exception when executing getExportedKeys(null, null, null) : > java.sql.SQLException: Table name can not be null > -------------------------------------------------------------------------------------------------------------- > > Key: SEQUOIA-1041 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-1041 > Project: Sequoia > Type: Bug > Components: Core > Versions: sequoia 2.10.10 > Environment: Derby Embedded Backends (10.3.2.1) > Solaris X86 & SPARC > JAVA 1.5.0 > Reporter: Nick Smith > Assignee: Emmanuel Cecchet > Priority: Minor > Fix For: sequoia 2.10.10 > > > The following warning message is written to the Sequoia logs when starting a > 2.10.10 virtual database when configured with Derby Embedded Backends . > WARN DatabaseBackend.RWDSTEST.bugatti-db1 Got an exception when executing > getExportedKeys(null, null, null) : java.sql.SQLException: Table name can not > be null > From the JDBC JAVADOC it is apparent that the tablename should not be null - > it could be "%" for all tables however. > My patches " > cvs diff -c > src/org/continuent/sequoia/controller/backend/SequoiaSchemaFactory.java > Index: src/org/continuent/sequoia/controller/backend/SequoiaSchemaFactory.java > =================================================================== > RCS file: > /cvsroot/sequoia/sequoia/src/org/continuent/sequoia/controller/backend/Attic/SequoiaSchemaFactory.java,v > retrieving revision 1.1.2.1 > diff -c -r1.1.2.1 SequoiaSchemaFactory.java > *** src/org/continuent/sequoia/controller/backend/SequoiaSchemaFactory.java > 8 Nov 2007 17:50:55 -0000 1.1.2.1 > --- src/org/continuent/sequoia/controller/backend/SequoiaSchemaFactory.java > 22 Feb 2008 14:20:57 -0000 > *************** > *** 114,125 **** > boolean optimized = false; > try > { > ! optimized = metaData.getExportedKeys(null, null, null) != null; > } > catch (SQLException ignored) > { > logger > ! .warn("Got an exception when executing getExportedKeys(null, > null, null) : " > + ignored); > } > > --- 114,125 ---- > boolean optimized = false; > try > { > ! optimized = metaData.getExportedKeys(null, null, "%") != null; > } > catch (SQLException ignored) > { > logger > ! .warn("Got an exception when executing getExportedKeys(null, > null, \"%\") : " > + ignored); > } > > and the also the following... > cvs diff -c > src/org/continuent/sequoia/controller/backend/DatabaseSQLMetaData.java > Index: src/org/continuent/sequoia/controller/backend/DatabaseSQLMetaData.java > =================================================================== > RCS file: > /cvsroot/sequoia/sequoia/src/org/continuent/sequoia/controller/backend/DatabaseSQLMetaData.java,v > retrieving revision 1.26.2.7 > diff -c -r1.26.2.7 DatabaseSQLMetaData.java > *** src/org/continuent/sequoia/controller/backend/DatabaseSQLMetaData.java > 13 Dec 2007 16:59:29 -0000 1.26.2.7 > --- src/org/continuent/sequoia/controller/backend/DatabaseSQLMetaData.java > 22 Feb 2008 14:21:59 -0000 > *************** > *** 495,501 **** > // and table drop them from the selection criteria so it returns all > the > // foreign keys of the database. > > ! rs = metaData.getExportedKeys(null, null, null); > > if (rs == null) > { > --- 495,501 ---- > // and table drop them from the selection criteria so it returns all > the > // foreign keys of the database. > > ! rs = metaData.getExportedKeys(null, null, "%"); > > if (rs == null) > { > Many Thanks in Advance, > Nick -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
