[DERBY-3000] getTables() call with 10.3 causes java.sql.SQLException: The parameter position '8' is out of range. The number of parameters for this prepared statement is '7'.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: JDBC
• Urgency: Urgent
• Bug behavior facts: Regression
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 10/Aug/07 18:42
• Updated: 30/Jun/09 15:55
• Resolved: 16/Aug/07 12:54

Description

The DatabaseMetaData.getTables() call below causes this error with 10.3. 10.2 is fine.

import java.sql.*;

public class GetTables {

public static void main(String[] args) throws Exception {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection conn = DriverManager.getConnection("jdbc:derby:wombat;create=true");
ResultSet tableRS = conn.getMetaData().getTables(null,
null, null, new String[]

{"TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM"}

);

tableRS.close();
conn.close();
}

}

[C:/kmarsden/repro/2976] java GetTables
Exception in thread "main" 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(SQLExceptionFactory.java:45)
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:1766)
at GetTables.main(GetTables.java:8)
Caused by: ERROR XCL13: The parameter position '8' is out of range. The number of parameters for this prepared stateme
nt is '7'.
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)
... 2 more

Issue Links

• relates to: DERBY-1107 For existing databases JDBC metadata queries do not get updated properly between maintenance versions.