?
Solved

problem with insert statements in JDBC

Posted on 2002-03-13
3
Medium Priority
?
259 Views
Last Modified: 2010-03-31
Not sure if this is a Java question or a MySql question.

I'm trying basic insert statements and am using a totorial on the sun web page.  From what I can see the code is identical to that on the tutorial and I have just altered it to fit the names of my own db.

 Statement stmt = C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                     ResultSet.CONCUR_UPDATABLE);
      ResultSet uprs = stmt.executeQuery("SELECT entrykey, headword, part_of_speech, crossref, gramm_info FROM irishentries");

      uprs.moveToInsertRow();

      uprs.updateInt("entrykey", 63893);
      uprs.updateString("headword", "Liz");
      uprs.updateString("part_of_speech", "Clear");
      uprs.updateString("crossref", "was");
      uprs.updateString("gramm_info", "here");
      uprs.insertRow();

      uprs.updateInt("entrykey", 63894);      
      uprs.updateString("headword", "Kona_Decaf");
      uprs.updateString("part_of_speech", "blah");
      uprs.updateString("crossref","none" );
      uprs.updateString("gramm_info","none here either" );
      uprs.insertRow();

      uprs.beforeFirst();

      System.out.println("Table iIRISHENTRIES after insertion:");
      while (uprs.next()) {
       int ekey = uprs.getInt("entrykey");    
       String headwd = uprs.getString("headword");
          String pofs = uprs.getString("part_of-speech");
          String cross = uprs.getString("crossref");
          String grinf = uprs.getString("gramm_info");

          System.out.print(ekey + "   " + headwd + "   " + pofs);
          System.out.println("   " + cross + "   " + grinf);
             }

It's compiling correctly but I'm getting the response

SQLException: ResultSet is from UPDATE. No Data
SQLState:     S1000
VendorError:  0

from MySql.  

Any ideas where I'm going wrong?

thanks
liz
0
Comment
Question by:Cleare
3 Comments
 
LVL 2

Accepted Solution

by:
Slava_K earned 150 total points
ID: 6861897
why not do just a simple insert?
String x, y, z;
x = "x";
y = "y";
z = "z";

String strSQL = "Insert into TBL(x,y,z) Values(" +x+ "," + y + "," + z " ")";

Statement statment = connection.createStatement();
            rs = statment.executeQuery(strSQL);
            connection.commit();
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 6862038
i'm guessing you're using org.gjt.mm.mysql driver...

if so, i would also do like slava_k suggests above.  the driver seems to be a little screwy especially when doing updates/inserts.
0
 
LVL 6

Expert Comment

by:kotan
ID: 6863453
Does your driver support jdbc 2.0?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
This video teaches viewers about errors in exception handling.
Suggested Courses
Course of the Month8 days, 3 hours left to enroll

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question