Solved

problem with insert statements in JDBC

Posted on 2002-03-13
3
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
Slava_K earned 50 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
String array comparison 4 58
Notify sent to other threads in Java 9 54
Running JavaFX on the Raspberry Pi 27 301
Java array sort 10 63
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
In this post we will learn different types of Android Layout and some basics of an Android App.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
Suggested Courses

752 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