java.sql.SQLException : Illegal operation on empty result set

Question

I have code like this

String sql_kode_kategori = "select kategori from data_kategori \n" +
                                   "where kode_kategori = ?";
    try{
        pst = (PreparedStatement) koneksiMySQL.GetConnection().prepareStatement(sql_kode_kategori);
        pst.setString(1, (String)cbKategori.getSelectedItem());
        rst2 = pst.executeQuery();
        rst2.next();

        stat = (Statement) koneksiMySQL.GetConnection().createStatement();
        String sql_insert = "INSERT INTO data_pasal VALUES ('"+jTPasal.getText() + "','"+jTIsi_Pasal.getText()+"'"
                + ",'"+jTHukuman.getText()+"','"+jTDenda.getText()+"','"+rst2.getString(1)+"')";
        stat.executeUpdate(sql_insert);
        javax.swing.JOptionPane.showMessageDialog(null, "Data CES Berhasil Ditambahkan");
        ClearField();
        TampilTabel();

    }catch(Exception e){
        JOptionPane.showMessageDialog(null, e);
    }

i tried to get kode_kategori with kategori but that error appear, please help me

First thing to do: stop inserting values directly into your SQL. Use parameterized SQL, as you're already doing for the query part. — Jon Skeet
– Jon Skeet, Commented Dec 7, 2015 at 13:16
If rst2.next() returns false, there is no data for rst2.getString(1). You need to check for result as if(rst2.next()) { — Jan
– Jan, Commented Dec 7, 2015 at 13:18

Jan · Accepted Answer · 2015-12-07 13:20:10Z

1

If rst2.next() returns false, there is no data for rst2.getString(1). You need to check for result as

if(rst2.next()) { 
    stat = (Statement) koneksiMySQL.GetConnection().createStatement();
    String sql_insert = "INSERT INTO data_pasal VALUES ('"+jTPasal.getText() + "','"+jTIsi_Pasal.getText()+"'"
            + ",'"+jTHukuman.getText()+"','"+jTDenda.getText()+"','"+rst2.getString(1)+"')";
    stat.executeUpdate(sql_insert);
} else {
  // handle invalid category
}

answered Dec 7, 2015 at 13:20

Jan

13.9k3 gold badges35 silver badges58 bronze badges

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

2 Comments

Pramesty Jaya Over a year ago

program can't run with that way

Jan Over a year ago

? Please explain. Do you get errors? Not compiling?

Abdelhak · Accepted Answer · 2015-12-07 13:33:22Z

0

Remove \n from your query:

 String sql_kode_kategori = "select kategori from data_kategori where kode_kategori = ?";

Try to verify this (String)cbKategori.getSelectedItem() variable does contain right value.

edited Dec 7, 2015 at 13:33

answered Dec 7, 2015 at 13:21

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

3 Comments

Abdelhak Over a year ago

@Pramesty Jaya Try to verify this (String)cbKategori.getSelectedItem() variable does contain right value.

Pramesty Jaya Over a year ago

that's part work perfectly, nothing wrong on that part

Pramesty Jaya Over a year ago

oh god, my bad. I want to get kode_kategori use kategori, i use wrong query. Thanks man

Collectives™ on Stack Overflow

java.sql.SQLException : Illegal operation on empty result set

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related