SQLException: ORA-01008: not all variables bound -- SQL error using java to query database JDBC

Question

        Statement stmt = con.createStatement();

        String pubBooks = "select title_name " +
                "from publisher, title " +
                "where pub_name = ? " +
                "and publisher.pub_no = title.pub_no " +
                "order by title_name";
        ResultSet rS = stmt.executeQuery(pubBooks);
        stmt.close();
        String pubss = "Irwin";
        PreparedStatement pStmt = 
            con.prepareStatement(pubBooks);
        pStmt.setString(1, pubss);
        pStmt.executeUpdate();

Hey, I'm trying to use JDBC to query my database to the the list of book titles produced by that publisher however I run into the error java.sql.SQLException: ORA-01008: not all variables bound. I've been trying everything that I can think of but I am just not quite sure what to do at this point.

rgettman · Accepted Answer · 2014-03-29 00:22:55Z

3

You were close with trying PreparedStatement, except that you just called the wrong "execute" method. Use the executeQuery() method to return your ResultSet.

PreparedStatement pStmt = 
con.prepareStatement(pubBooks);
pStmt.setString(1, pubss);
ResultSet rS = pStmt.executeQuery();

answered Mar 29, 2014 at 0:22

rgettman

179k30 gold badges282 silver badges365 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rgettman Over a year ago

You don't need your Statement at all, just your PreparedStatement.

Chitta · Accepted Answer · 2014-03-29 00:38:24Z

1

Statement can't be used when supplying parameters to the query, use PreparedStatement. You may have to revise your code as below:

    String pubBooks = "select title_name " +
            "from publisher, title " +
            "where pub_name = ? " +
            "and publisher.pub_no = title.pub_no " +
            "order by title_name";

    String pubss = "Irwin";

    PreparedStatement pStmt =  con.prepareStatement(pubBooks);
    pStmt.setString(1, pubss);
    ResultSet rS = pStmt.executeQuery();

    //TODO: code to use resultset rS

    rS.close();
    pstmt.close();

answered Mar 29, 2014 at 0:38

Chitta

213 bronze badges

Collectives™ on Stack Overflow

SQLException: ORA-01008: not all variables bound -- SQL error using java to query database JDBC

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related