[ https://forge.continuent.org/jira/browse/SEQUOIA-1041?page=all ]
Emmanuel Cecchet resolved SEQUOIA-1041:
---------------------------------------
Resolution: Duplicate
Fix Version: sequoia 2.10.10
I have duplicated the issue in SEQUOIA-1052 (sorry about that)
> 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
> 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
