SQL Exception: java.sql.SQLException: No data found

Question

i get an error wherein it says SQL Exception: java.sql.SQLException: No data found, i cant seems to find the problem here. please help me, sorry for asking.

try{
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url = "jdbc:odbc:ict11";
    Connection con = DriverManager.getConnection(url);
    Statement statement = con.createStatement();
       statement.executeUpdate( "DELETE from Employee where EmployeeID ="+txtId.getText()+"" );
       statement.close();
    con.close();
    JOptionPane.showMessageDialog(rootPane, "Successfully Deleted");
    }
        catch(Exception e){
        JOptionPane.showMessageDialog(null, e);

    }

Does the data you are trying to remove exists?? But actually that too should not throw an exception.. — Rohit Jain
– Rohit Jain, Commented Oct 6, 2012 at 9:57
you are using jdbc-odbc driver, not sure but check this link. Might be helpful. — Nandkumar Tekale
– Nandkumar Tekale, Commented Oct 6, 2012 at 10:36

PeakGen · Accepted Answer · 2012-10-06 17:10:47Z

1

I can think about 2 issues

This could be because of unnecessary white spaces that getText() doesn't eliminate. Try txtId.getText().trim()
URL might be wrong.

Apart from that, do the following to improve the code.

Print complete stack trace
Use PreparedStatement instead of statement.

answered Oct 6, 2012 at 17:10

PeakGen

23.1k101 gold badges291 silver badges495 bronze badges

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

Comments

Bhavik Shah · Accepted Answer · 2012-10-11 12:51:31Z

0

statement.executeUpdate( "DELETE from Employee where EmployeeID ="+txtId.getText()+"" );

try using this

statement.executeUpdate( "DELETE from Employee where EmployeeID ='"+txtId.getText()+"'" );

note the addition of single inverted comma at the start and end of txtId.getText()

answered Oct 11, 2012 at 12:51

Bhavik Shah

5,1933 gold badges26 silver badges40 bronze badges

Collectives™ on Stack Overflow

SQL Exception: java.sql.SQLException: No data found

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related