wood burning stoves 2.0*
The moose likes JDBC and the fly likes java.sql.SQLException: General error; is occuring Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: General error; is occuring" Watch "java.sql.SQLException: General error; is occuring" New topic
Author

java.sql.SQLException: General error; is occuring

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
" java.sql.SQLException: General error " is occuring on the following code.
Please explain why and does it mean.

Jason Cox
Ranch Hand

Joined: Jan 21, 2004
Posts: 287
A "General Error" generally means there is something wrong with your SQL query. More than likely one of the values you are inserting doesn't match the SQL Data Type you are trying to insert it into. My guess would be the Messages column as the most likely culprit. Don't focus on that too much, it could be another problem with the statement, but definitely check your SQL query and make sure it can handle what you're trying to put into it.
You might also consider using pstmt.executeUpdate() as a best practice. Though I suppose it doesn't really matter if you're never doing anything with the return value of the execution.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: General error; is occuring