db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3124) Exception when calling DatabaseMetaData.getTables with non null fourth parameter types)
Date Thu, 11 Oct 2007 16:43:50 GMT

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


Mime
View raw message