db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Voxland" <Nathan.Voxl...@sundog.net>
Subject Error on getMetaData().getTables() in 10.3.1.4
Date Thu, 09 Aug 2007 16:06:07 GMT
I'm getting the following error on 10.3.1.4 on this call: 

 

tableRS = conn.getMetaData().getTables(getCatalogName(),

getSchemaName(), null, new String[]{"TABLE", "GLOBAL TEMPORARY", "LOCAL
TEMPORARY", "ALIAS", "SYNONYM"});

 

with this stack trace:

java.sql.SQLException: The parameter position '8' is out of range.  The
number of parameters for this prepared  statement is '7'.

      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(Un

known 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

liquibase.database.AbstractDatabase.dropForeignKeys(AbstractDatabase.jav

a:714)

      ... 25 more

Caused by: ERROR XCL13: The parameter position '8' is out of range.  The
number of parameters for this prepared  statement is '7'.

      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(Un

known Source)

      ... 28 more

 

 

 

 

The same call worked before on 10.2.2.0

 

I posted the problem to the derby-user list and Bryan Pendleton said 

 

"It seems like a variant of

https://issues.apache.org/jira/browse/DERBY-2976

 

But I believe the developers thought that DERBY-2976 would only happen
with databases that were upgraded to 10.3.1.2, though, not with
10.3.1.4.

 

Can you post this problem to the derby-dev@db.apache.org (as a separate,
new problem), and see what sort of help you can get for it there?"

 

Nathan

 


Mime
View raw message