File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Using PreparedStatement" Watch "Using PreparedStatement" New topic

Using PreparedStatement

Tim Francisco

Joined: Apr 03, 2010
Posts: 12
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.
Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

What if you try: stmt.executeUpdate();

OCUP UML fundamental and ITIL foundation
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
I agree. Here's the link:
subject: Using PreparedStatement
It's not a secret anymore!