Repository navigation
[Java][FlightRPC] Flight SQL JDBC driver parameter getting an exception: parameter ordinal 1 out of range #121
Description
Describe the bug, including details regarding any error messages, version, and platform.
protected AvaticaParameter getParameter(int param) throws SQLException {
try {
return (AvaticaParameter)this.getSignature().parameters.get(param - 1);
} catch (IndexOutOfBoundsException var3) {
throw AvaticaConnection.HELPER.toSQLException(AvaticaConnection.HELPER.createException("parameter ordinal " + param + " out of range"));
}
}
Getting this exception
My code:
public static void handleSqlStatements() throws SQLException {
String url = "jdbc:arrow-flight://localhost:5000;useEncryption=false;useServerPrepStmts=false;";
String sql = "select * from MixedTypeDB.`Table` where OID=?"; // Example SQL query
System.out.println("SQL query: " + sql); // Debugging: Log the query
try (var connection = DriverManager.getConnection(url)) {
ArrowFlightPreparedStatement pstmt = (ArrowFlightPreparedStatement)connection.prepareStatement(sql);
ParameterMetaData metadata = pstmt.getParameterMetaData();
pstmt.setInt(1, 12345); // crashing here
System.out.println("Executing SQL query: " + sql);
try (final ResultSet rs = pstmt.executeQuery()) {
}
} catch (SQLException e) {
e.printStackTrace();
}
}
<dependency>
<groupId>org.apache.arrow</groupId>
<artifactId>flight-sql-jdbc-driver</artifactId>
<version>13.0.0</version>
</dependency>
Component(s)
Java
Activity
lidavidm commentedon Feb 18, 2024
Duplicate of apache/arrow#33475
This was fixed in 15.0.0, can you upgrade and try again?
HackPoint commentedon Feb 18, 2024
Have tried it with 15.0.0 and it's has the same issue
lidavidm commentedon Feb 18, 2024
Can you post all the details with 15.0.0 (stack trace, versions, etc)?
HackPoint commentedon Feb 18, 2024
Sir, the error is still the same and the code is exactly the same, if you want I can repaste in here again , including the exception details. I can even add the project it self if needed. Which I will do.
anybase-inspector-probe.zip
lidavidm commentedon Feb 18, 2024
I'm just asking for the stack trace, so I can take a quick look. While the project is appreciated, I don't have the time to build this from scratch.
HackPoint commentedon Feb 18, 2024
`
@lidavidm
Error executing SQL: parameter ordinal 1 out of range java.sql.SQLException: parameter ordinal 1 out of range at cfjd.org.apache.calcite.avatica.Helper.createException(Helper.java:60) at cfjd.org.apache.calcite.avatica.AvaticaPreparedStatement.getParameter(AvaticaPreparedStatement.java:427) at cfjd.org.apache.calcite.avatica.AvaticaPreparedStatement.getSite(AvaticaPreparedStatement.java:434) at cfjd.org.apache.calcite.avatica.AvaticaPreparedStatement.setInt(AvaticaPreparedStatement.java:174) at com.ge.core.SQLInterpreterWithParameters.setParameter(SQLInterpreterWithParameters.java:62) at com.ge.core.SQLInterpreterWithParameters.handleSqlStatements(SQLInterpreterWithParameters.java:38) at com.ge.grid.Main.main(Main.java:11)lidavidm commentedon Feb 18, 2024
Is the server implementation actually returning a parameter schema?
HackPoint commentedon Feb 18, 2024
all the column names are back other than that IDK, can you point me where to look please?
lidavidm commentedon Feb 18, 2024
What server implementation are you using? It needs to fill in the parameter_schema in the CreatePreparedStatement response https://github.com/apache/arrow/blob/a03d957b5b8d0425f9d5b6c98b6ee1efa56a1248/format/FlightSql.proto#L1524-L1549
HackPoint commentedon Feb 18, 2024
Seems like it's empty: The calcite oriented db
lidavidm commentedon Feb 18, 2024
The server needs to return the schema so that the driver knows how many and what type the parameters are. We could perhaps improve the error message on the client, or assume what the type/number of parameters are based on what the client does, but that is a duplicate of #156
HackPoint commentedon Feb 18, 2024
I understand and already opened an issue in our code base, really appreciate you assistance. Awesome responsiveness.
lidavidm commentedon Feb 18, 2024
Sounds good. I'll leave this open and link it in that issue to track the error message improvement.
MaoMiMao commentedon Mar 12, 2024
I encountered the same problem
Termainl commentedon Jan 6, 2025
I encountered the same problem
the version 15.0.0