db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (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'.
Date Wed, 15 Aug 2007 18:23:30 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden reassigned DERBY-3000:
-------------------------------------

    Assignee: Kathey Marsden

> 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
>            Assignee: 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.


Mime
View raw message