db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jørgen Løland <Jorgen.Lol...@Sun.COM>
Subject Re: DatabaseMetaData.getTables() problems for 10.3.1.3 with a 10.3.1.2 database
Date Wed, 25 Jul 2007 11:01:05 GMT
I see this as well. I created DERBY-2976 for it.

Tim Dudgeon wrote:
> I'm seeing an exception for the DatabaseMetaData.getTables() method when 
> using 10.3.1.3 with a database that has been upgraded to 10.3.1.2.
> 10.2 databases that have not been upgraded seem to be OK.
> 
> Tim
> 
> Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
> Connection con = 
> DriverManager.getConnection("jdbc:derby:/path/to/somedb;upgrade=true", 
> null, null);
> DatabaseMetaData meta = con.getMetaData();
> ResultSet rs = meta.getTables(null, "APP", null, null);
> 
> 
> 
> Exception in thread "main" 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(Unknown 
> Source)
>         at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>         at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Source)
>         at 
> org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown 
> Source)
>         at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(Unknown Source)
>         at 
> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTables(Unknown Source)
>         at derbytest.Main.main(Main.java:49)
> 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(Unknown Source)
>         at 
> org.apache.derby.impl.sql.GenericParameterValueSet.checkPosition(Unknown 
> Source)
>         at 
> org.apache.derby.impl.sql.GenericParameterValueSet.getParameterForSet(Unknown 
> Source)
>         ... 3 more
> 
> 


-- 
Jørgen Løland

Mime
View raw message