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
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
