This week's book giveaway is in the OCAJP forum. We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line! See this thread for details.
" java.sql.SQLException: General error " is occuring on the following code. Please explain why and does it mean.
posted 12 years ago
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.