[DRILL-2494] Binding parameters to a PreparedStatement throws a SQLException

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Client - JDBC
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 18/Mar/15 17:39
• Updated: 27/Jul/15 21:51
• Resolved: 25/Jun/15 04:24

Description

git.commit.id.abbrev=7b4c887

Code :

    prepStatement = conn.prepareStatement("SELECT int_col AS INTCOL FROM dfs.jdbctesting.fewtypes_txt_view where int_col > ?");
    prepStatement.setInt(1, 20);

The above code resulted in the below exception

Exception in thread "main" java.sql.SQLException: parameter ordinal 1 out of range
	at net.hydromatic.avatica.Helper.createException(Helper.java:44)
	at net.hydromatic.avatica.AvaticaPreparedStatement.getParameter(AvaticaPreparedStatement.java:246)
	at net.hydromatic.avatica.AvaticaPreparedStatement.setInt(AvaticaPreparedStatement.java:105)
	at Dummy.testBindParamsPrepStatement(Dummy.java:57)
	at Dummy.main(Dummy.java:30)

Issue Links

• relates to: DRILL-3566 Calling Connection.prepareStatement throws a ClassCastException