access database cannot execute SQL LIKE

Question

I am not able to query records from my database, and getting "UCAExc:::4.0.2 Invalid argument in JDBC call: parameter index out of range: 1" error message

How is this caused and how can I solve it?

    public void  query(){
    String name = name_tt.getText();
    DefaultTableModel model= new DefaultTableModel();
    JScrollPane scrollPane = new JScrollPane();
    scrollPane.setBounds(0, 283, 555, 212);
    contentPane.add(scrollPane);

    table = new JTable(model);
    scrollPane.setViewportView(table);
    model.addColumn("ID");
    model.addColumn("IDs");
    model.addColumn("Name");
    try
    {
        PreparedStatement pst = con.prepareStatement("SELECT * FROM TEST 
        WHERE IDs LIKE '?*' ");
        pst.setString(1, name);
        ResultSet rs = pst.executeQuery();
        while(rs.next())
        {
            model.addRow(new Object[]{rs.getInt(1),rs.getString(2),rs.getInt(3)});
        }

    }
    catch(Exception e){
        System.out.println(e.getMessage());

    };

}

Gord Thompson · Accepted Answer · 2017-07-02 01:10:08Z

1

You need to do

PreparedStatement pst = con.prepareStatement("SELECT * FROM TEST WHERE IDs LIKE ?");
pst.setString(1, name + "*");
ResultSet rs = pst.executeQuery();

That way the parameter placeholder ? is part of the basic SQL statement, instead of being part of a string literal within the SQL statement.

answered Jul 2, 2017 at 1:10

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

Collectives™ on Stack Overflow

access database cannot execute SQL LIKE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related