[
https://issues.apache.org/jira/browse/DERBY-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534083
]
Kathey Marsden commented on DERBY-3124:
---------------------------------------
I wonder if this is DERBY-3000?
Can you look at the JDBC code there and tell us if that is your issue. If it
is you can try building the latest on the 10.3 branch to get the fix.
Kathey
> 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.
