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 Ole Solberg <Ol...@Sun.COM> on 2007/08/09 11:49:59 UTC
Problem with ij 'describe' and 'show ..' cmds after upgrading
"10.3 trunk database" to "10.4 trunk"
To continue to use my "large datavolume" database, which is used for
testing on *trunk*, I did the "for debugging only" kind of upgrade.
That is, I built a sane, debug Derby 10.4 and then did the upgrade on my
10.3 database to 10.4.
(I first did a soft upgrade and later a full/hard upgrade.)
The upgrade seems to have been successful: My "large datavolume test" is
now running on an insane, nodebug Derby 10.4.
The problem I see is that when I do ij commands like
'describe table'
and
'show [ tables | views | ....] in schema'
I get this error:
ERROR 38000: The exception 'java.sql.SQLException: The parameter
position '4' is out of range. The number of parameters for this
prepared statement is '3'.' was thrown while evaluating an expression.
ERROR XCL13: The parameter position '4' is out of range. The number of
parameters for this prepared statement is '3'.
-----------------------------------------------------------------------------------------
>From derby.log:
2007-08-08 08:10:34.314 GMT Thread[DRDAConnThread_2,5,main] (XID =
254165672), (SESSIONID = 2), (DATABASE =
/export/raid/tmp/os136789/DOTS/derby/TESTDB), (DRDAID =
O19F76D6.EB43-796291522553895625{3}), Cleanup action starting
2007-08-08 08:10:34.314 GMT Thread[DRDAConnThread_2,5,main] (XID =
254165672), (SESSIONID = 2), (DATABASE =
/export/raid/tmp/os136789/DOTS/derby/TESTDB), (DRDAID =
O19F76D6.EB43-796291522553895625{3}), Failed Statement is: CALL
SYSIBM.SQLTABLES(?,?,?,?,?) with 5 parameters begin parameter #1: NULL
:end parameter begin parameter #2: U1 :end parameter begin parameter #3:
BID :end parameter begin parameter #4: NULL :end parameter begin
parameter #5:
DATATYPE='JDBC';DYNAMIC=0;REPORTPUBLICPRIVILEGES=1;CURSORHOLD=1 :end
parameter
ERROR 38000: The exception 'java.sql.SQLException: The parameter
position '4' is out of range. The number of parameters for this
prepared statement is '3'.' was thrown while evaluating an expression.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:294)
at
org.apache.derby.iapi.error.StandardException.unexpectedUserException(StandardException.java:554)
at
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:63)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:57)
at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:116)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1304)
at org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:666)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:4039)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3843)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:985)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:275)
Caused by: java.sql.SQLException: The parameter position '4' is out of
range. The number of parameters for this prepared statement is '3'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(EmbedResultSet.java:4414)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:495)
at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(EmbedDatabaseMetaData.java:1765)
at
org.apache.derby.catalog.SystemProcedures.SQLTABLES(SystemProcedures.java:308)
at
org.apache.derby.exe.acf81e0010x0114x447ex2cb3x00000207a6c82.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
... 11 more
Caused by: java.sql.SQLException: The parameter position '4' is out of
range. The number of parameters for this prepared statement is '3'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 23 more
Caused by: ERROR XCL13: The parameter position '4' is out of range. The
number of parameters for this prepared statement is '3'.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)
at
org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(GenericParameterValueSet.java:317)
at
org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(GenericParameterValueSet.java:174)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:492)
... 19 more
============= begin nested exception, level (1) ===========
java.sql.SQLException: The parameter position '4' is out of range. The
number of parameters for this prepared statement is '3'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(EmbedResultSet.java:4414)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:495)
at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(EmbedDatabaseMetaData.java:1765)
at
org.apache.derby.catalog.SystemProcedures.SQLTABLES(SystemProcedures.java:308)
at
org.apache.derby.exe.acf81e0010x0114x447ex2cb3x00000207a6c82.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:57)
at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:116)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1304)
at org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:666)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:4039)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3843)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:985)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:275)
Caused by: java.sql.SQLException: The parameter position '4' is out of
range. The number of parameters for this prepared statement is '3'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 23 more
Caused by: ERROR XCL13: The parameter position '4' is out of range. The
number of parameters for this prepared statement is '3'.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)
at
org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(GenericParameterValueSet.java:317)
at
org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(GenericParameterValueSet.java:174)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:492)
... 19 more
============= end nested exception, level (1) ===========
============= begin nested exception, level (2) ===========
java.sql.SQLException: The parameter position '4' is out of range. The
number of parameters for this prepared statement is '3'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(EmbedResultSet.java:4414)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:495)
at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(EmbedDatabaseMetaData.java:1765)
at
org.apache.derby.catalog.SystemProcedures.SQLTABLES(SystemProcedures.java:308)
at
org.apache.derby.exe.acf81e0010x0114x447ex2cb3x00000207a6c82.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:57)
at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:116)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1304)
at org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:666)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:4039)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3843)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:985)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:275)
Caused by: ERROR XCL13: The parameter position '4' is out of range. The
number of parameters for this prepared statement is '3'.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)
at
org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(GenericParameterValueSet.java:317)
at
org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(GenericParameterValueSet.java:174)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:492)
... 19 more
============= end nested exception, level (2) ===========
============= begin nested exception, level (3) ===========
ERROR XCL13: The parameter position '4' is out of range. The number of
parameters for this prepared statement is '3'.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)
at
org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(GenericParameterValueSet.java:317)
at
org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(GenericParameterValueSet.java:174)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(EmbedPreparedStatement.java:492)
at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(EmbedDatabaseMetaData.java:1765)
at
org.apache.derby.catalog.SystemProcedures.SQLTABLES(SystemProcedures.java:308)
at
org.apache.derby.exe.acf81e0010x0114x447ex2cb3x00000207a6c82.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:57)
at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:116)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1304)
at org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:666)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:4039)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3843)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:985)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:275)
============= end nested exception, level (3) ===========
-----------------------------------------------------------------------------------------
--
Ole Solberg, Database Technology Group,
Sun Microsystems, Trondheim, Norway
Re: Problem with ij 'describe' and 'show ..' cmds after upgrading
"10.3 trunk database" to "10.4 trunk"
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> The problem I see is that when I do ij commands like
> 'describe table'
> and
> 'show [ tables | views | ....] in schema'
> I get this error:
This is https://issues.apache.org/jira/browse/DERBY-2976, I think.
thanks,
bryan