How to resolve NoResultSet-Produce problem in JAVA?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gobindap
    New Member
    • Feb 2013
    • 25

    How to resolve NoResultSet-Produce problem in JAVA?

    Whenever I try either to insert new record of update existing record in the database it produces NoResultSet-Produce error but it makes effect in database. How to resolve this problem. The code I have used is as below:
    Code:
    try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:MarksheetDB", " ", "222222");
    	Statement st = con.createStatement();
    	String sql="update valueTable set field1='value1', field2='value2' where ID = 1";
    ResultSet rs = st.executeQuery(sql); 
        } catch (Exception e) {
           JOptionPane.showMessageDialog(null, e);
        }
    Last edited by Rabbit; Apr 8 '13, 04:05 PM. Reason: Please use code tags when posting code.
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Do not use executeQuery to run insert and update statements. Only use it for selects. Use executeUpdate instead.

    Comment

    Working...