permaculture playing cards*
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insert statement not inserting correct value" Watch "Insert statement not inserting correct value" New topic

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
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,
[ June 26, 2002: Message edited by: Seema Hanji ]
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
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?

wood burning stoves
subject: Insert statement not inserting correct value
Similar Threads
Unable to Insert these Chinese Character
blob and query heap memory
Stored procedure call removes spaces in text
inserting long text into Oracle CLOB
DB2 Insert Problem - Invalid Table State