Exception when calling DatabaseMetaData.getTables with non null fourth
parameter types)
---------------------------------------------------------------------------------------
Key: DERBY-3124
URL: https://issues.apache.org/jira/browse/DERBY-3124
Project: Derby
Issue Type: Bug
Components: JDBC
Affects Versions: 10.3.1.4
Environment: Ubuntu 6.03 Server - foundation for the server
Ubuntu 6.06 Desktop - foundation for the client
Reporter: Juergen Key
Priority: Critical
org.apache.derby.client.am.SqlException
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)
at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.executeCatalogQuery(Unknown
Source)
at org.apache.derby.client.am.DatabaseMetaData.getTablesX(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.getTables(Unknown Source)
at de.netsysit.db.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:356)
at de.netsysit.db.sniffer.DatabaseMetaData.getTables(DatabaseMetaData.java:574)
at
de.netsysit.db.ui.SQLShellComponent.refreshTables(SQLShellComponent.java:1837)
at de.netsysit.db.ui.SQLShellComponent.<init>(SQLShellComponent.java:391)
at de.netsysit.db.ui.ShellOpener.run(ShellOpener.java:117)
at de.netsysit.util.threads.Synchronizer.run(Synchronizer.java:16)
at de.netsysit.util.threads.ThreadManagerHelper.run(ThreadManagerHelper.java:42)
[derby] BEGIN TRACE_DIAGNOSTICS
[EMAIL PROTECTED] java.sql.SQLException
[EMAIL PROTECTED]@4a3158] DERBY SQLCA from server
[EMAIL PROTECTED]@4a3158] SqlCode = -1
[EMAIL PROTECTED]@4a3158] SqlErrd = { 0, 0, 0, 0, 0, 0 }
[EMAIL PROTECTED]@4a3158] SqlErrmc = java.sql.SQLException: The parameter
position '8' is out of range. The number of parameters for this prepared
statement is '7'.38000XCL13:87XCL13.S
[EMAIL PROTECTED]@4a3158] SqlErrmcTokens = { java.sql.SQLException: The
parameter position '8' is out of range. The number of parameters for this
prepared statement is '7'.38000XCL13:87XCL13.S }
[EMAIL PROTECTED]@4a3158] SqlErrp = CSS10030
[EMAIL PROTECTED]@4a3158] SqlState = 38000
[EMAIL PROTECTED]@4a3158] SqlWarn =
[EMAIL PROTECTED] SQL state = 38000
[EMAIL PROTECTED] Error code = -1
[EMAIL PROTECTED] Tokens = java.sql.SQLException: The parameter position
'8' is out of range. The number of parameters for this prepared statement is
'7'.38000XCL13:87XCL13.S
[EMAIL PROTECTED] Stack trace follows
org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1,
SQLSTATE: 38000, SQLERRMC: java.sql.SQLException: The parameter position '8' is
out of range. The number of parameters for this prepared statement is
'7'.38000XCL13:87XCL13.S
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)
at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)
at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.executeCatalogQuery(Unknown
Source)
at org.apache.derby.client.am.DatabaseMetaData.getTablesX(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.getTables(Unknown Source)
at de.netsysit.db.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:356)
at de.netsysit.db.sniffer.DatabaseMetaData.getTables(DatabaseMetaData.java:574)
at
de.netsysit.db.ui.SQLShellComponent.refreshTables(SQLShellComponent.java:1837)
at de.netsysit.db.ui.SQLShellComponent.<init>(SQLShellComponent.java:391)
at de.netsysit.db.ui.ShellOpener.run(ShellOpener.java:117)
at de.netsysit.util.threads.Synchronizer.run(Synchronizer.java:16)
at de.netsysit.util.threads.ThreadManagerHelper.run(ThreadManagerHelper.java:42)
[derby] END TRACE_DIAGNOSTICS
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
