[
https://issues.apache.org/jira/browse/DERBY-3000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12519478
]
Kathey Marsden commented on DERBY-3000:
---------------------------------------
My plan is to create a connection level warning if an invalid type is passed.
Please let me know if that is not ok. The alternative is to continue to throw
an error but a more meaningful one. I hesitate to do that as it may impact
existing apps.
I am open to opinions though.
Kathey
> 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'.
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3000
> URL: https://issues.apache.org/jira/browse/DERBY-3000
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Kathey Marsden
>
> 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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
