*
The moose likes JDBC and the fly likes Insert statement not inserting correct value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insert statement not inserting correct value" Watch "Insert statement not inserting correct value" New topic
Author

Insert statement not inserting correct value

Seema Hanji
Ranch Hand

Joined: Jan 29, 2001
Posts: 37
Hi All,
I am trying to insert a record into Oracle-8 database using JDBC. For a particular column somehow the data is inserted partially. This colum is of type VARCHAR2(256) . I could successfully insert comma seperated values say 'CA,GA,CO' . But when I try to insert the value like 'Exclude CA,GA,CO' it inserts only 'Exclude '. When I run this insert statement using sql*plus, it inserts fine . but inserts partially as said above when I try to insert through JDBC using
stmt.executeUpdate(sqlStmt);
Just before executing this statement in my java code, I am printing out the insert statement and it looks fine.
Any idea why???
Thanks in advance,
Seema
[ June 26, 2002: Message edited by: Seema Hanji ]
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Seema
Can you post the insert statement that is printed out? Also, are there any ' in it? Those can give you a problem if they are not properly escaped.
Just to clarify, you're putting comma separated data all into the same column not into multiple columns right?


Dave
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Insert statement not inserting correct value
 
Similar Threads
blob and query heap memory
Stored procedure call removes spaces in text
inserting long text into Oracle CLOB
DB2 Insert Problem - Invalid Table State
Unable to Insert these Chinese Character