wood burning stoves 2.0*
The moose likes JDBC and the fly likes Using PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using PreparedStatement" Watch "Using PreparedStatement" New topic
Author

Using PreparedStatement

Tim Francisco
Greenhorn

Joined: Apr 03, 2010
Posts: 12
Hello,
Not sure what I am missing here but its driving me crazy. Its a simple PreparedStatement test program I am trying to test that I keeps failing. Here're the codes:


The exception is


I would appreciate if someone could help me figure out what's not right here.
Thanks.
T
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2501
    
    8

What if you try: stmt.executeUpdate();


OCUP UML fundamental and ITIL foundation
youtube channel
kv ruby
Ranch Hand

Joined: Jul 23, 2009
Posts: 38
can you check the data type of value in DB?
if it is not integr then you will have to insert values in single quotes.


Regards, ruby kv
rubyshiv.blogspot.com
 
GeeCON Prague 2014
 
subject: Using PreparedStatement