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] Created: (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 Fri, 10 Aug 2007 18:43:42 GMT
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.


Mime
View raw message