File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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: 2477
    
    7

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Using PreparedStatement
 
Similar Threads
SQL formatting question
Error while using DriverManager to connect to MySQL DB.
"main" java.sql.SQLException: Access denied for user 'root'@'192.168.1.1' (using password: YES)
MySQLSyntaxErrorException
Syntax error while inserting a file into Mysql database.