In the last episode (Nov 20), yilmaz said: > Well, > i am answering my own question. > It was keeping telling me that there is a syntax error. > However, the real problem was at the bottom the preparedstatement code > snippet > "stmt.executeUpdate(query);" > statement should have been > "stmt.executeUpdate();" (without parameter) > Wouldn't it make our lives easier if MySQL had thrown a sensible and > a logical error message so that developers need not to waste a lot of > time on a fairly small problem?
MySQL doesn't come with a Java interface, so it cannot have thrown an exception. According to the contributed software page, there are a number of JDBCs you can choose from. Make sure you are using the latest version of whichever driver you have, and if it still doens't work, try using a different JDBC, or send a bug report to the author. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php