Results 1 to 2 of 2
  1. #1
    gerard kowara is offline Member
    Join Date
    Oct 2010
    Posts
    8
    Rep Power
    0

    Default problem with inserting new record

    Hi All,

    I have this following code:

    Statement stmtInsert = connection.createStatement();
    String test = "insert into calltract (transaction_id,location_code) values (1,\"01\")";
    stmtInsert.executeUpdate(test);


    and the result is:
    No data - zero rows fetched, selected, or processed

    The purpose of this code is to insert data into table "calltract"

    Any Idea what wrong with this code?

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Lets see some more of the code around this. Namely the try/catch/finally block in which it occurs.

    One thing though, that "\"01\" should probably be '01'

Similar Threads

  1. Replies: 5
    Last Post: 04-05-2010, 01:24 PM
  2. Some problem in fetching record
    By Shivraj in forum NetBeans
    Replies: 1
    Last Post: 03-27-2009, 11:19 AM
  3. Replies: 1
    Last Post: 12-30-2008, 04:39 PM
  4. Replies: 0
    Last Post: 12-24-2007, 09:47 AM
  5. Replies: 2
    Last Post: 11-11-2007, 08:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •