René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"flight-sql-jdbc-driver throws \"parameter ordinal 1 out of range\" for PreparedStatement in SELECT query","articleBody":"### Describe the usage question you have. Please include as many useful details as possible.\n\n\nI am using the flight-sql-jdbc-driver (version 18.x / Doris 3.x) and I am trying to execute a simple SELECT query with a PreparedStatement and a ? placeholder. However, I consistently get the following exception: \n\njava.sql.SQLException: parameter ordinal 1 out of range\n\nHere is the minimal example of the code : \n\nimport java.sql.*;\n\n public class DorisTest \n {\n    public static void main(String[] args) throws Exception {\n        // Connect to Doris Flight SQL\n        String url = \"jdbc:apache:arrow:flight://host:port\";\n        Connection conn = DriverManager.getConnection(url);\n\n        // SQL with a single parameter\n        String sql = \"SELECT * FROM Connectors WHERE connectorID = ?\";\n        PreparedStatement ps = conn.prepareStatement(sql);\n        ps.setInt(1, 1); // This line throws SQLException\n\n        ResultSet rs = ps.executeQuery();\n        while (rs.next()) {\n            System.out.println(rs.getInt(\"connectorID\"));\n        }\n\n        conn.close();\n     }\n }\n\nThe driver throws: java.sql.SQLException: parameter ordinal 1 out of range\n\nAdditional observations:\n1. PreparedStatement is obtained directly from the JDBC connection.\n2. PreparedStatement.getParameterMetaData() seems to return 0 parameters.\n3. The driver works fine for queries without placeholders or with inline values.\n4. The Flight SQL JDBC driver appears to not support ? placeholders reliably in this version.\n\nQuestion:\n1. Is this a known limitation of the Doris Flight SQL JDBC driver?\n2. Are there any workarounds to use PreparedStatement with parameters for SELECT queries?\n3. If placeholders are not supported, what is the recommended way to safely execute parameterized queries (especially for IN clauses with multiple   \n    values) in Doris Flight SQL JDBC driver?\n\nAny guidance or best practices would be greatly appreciated!\n","author":{"url":"https://github.com/eqrvivek","@type":"Person","name":"eqrvivek"},"datePublished":"2026-02-06T06:05:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/1009/arrow-java/issues/1009"}