db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ole Solberg <Ole.Solb...@Sun.COM>
Subject Problem with ij 'describe' and 'show ..' cmds after upgrading "10.3 trunk database" to "10.4 trunk"
Date Thu, 09 Aug 2007 09:49:59 GMT
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

Mime
View raw message