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 [email protected] (as a separate,
new problem), and see what sort of help you can get for it there?"
Nathan
