You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/10/11 18:43:50 UTC
[jira] Commented: (DERBY-3124) Exception when calling
DatabaseMetaData.getTables with non null fourth parameter types)
[ 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
> [derby][SQLException@14d659d] java.sql.SQLException
> [derby][SQLException@14d659d][Sqlca@4a3158] DERBY SQLCA from server
> [derby][SQLException@14d659d][Sqlca@4a3158] SqlCode = -1
> [derby][SQLException@14d659d][Sqlca@4a3158] SqlErrd = { 0, 0, 0, 0, 0, 0 }
> [derby][SQLException@14d659d][Sqlca@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
> [derby][SQLException@14d659d][Sqlca@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 }
> [derby][SQLException@14d659d][Sqlca@4a3158] SqlErrp = CSS10030
> [derby][SQLException@14d659d][Sqlca@4a3158] SqlState = 38000
> [derby][SQLException@14d659d][Sqlca@4a3158] SqlWarn =
> [derby][SQLException@14d659d] SQL state = 38000
> [derby][SQLException@14d659d] Error code = -1
> [derby][SQLException@14d659d] 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
> [derby][SQLException@14d659d] 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.