3 messages in com.mysql.lists.javaRe: Code not inserting....?| From | Sent On | Attachments |
|---|---|---|
| Berlin Brown | 26 Jan 2004 07:06 | |
| Berlin Brown | 26 Jan 2004 07:17 | |
| Mark Matthews | 26 Jan 2004 07:28 |
| Subject: | Re: Code not inserting....? |
|---|---|
| From: | Mark Matthews (ma...@mysql.com) |
| Date: | 01/26/2004 07:28:19 AM |
| List: | com.mysql.lists.java |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Berlin Brown wrote:
Not posting the entire code, but I am trying to insert a BLOB, the code works on my other machine, with the exact same configuration(no configuration) but now I dont get an exeception but when I check execute, the boolean is false and the code doesnt insert any data?
PreparedStatement.execute() doesn't return the boolean to indicate success or failure, it returns true if execute() produces a result set, and false if execute() produced an update count. What you want to check is PreparedStatement.getUpdateCount() for the expected number of rows updated.
You're not showing any examples of how you're checking whether the insert happened or not, so really, we can't tell you what's going wrong :(
-Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com
Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAFTIptvXNTca6JD8RApIkAJ9yKRWON890bdAPy3wkJ9iatagiaACdEECA noyfP1xtuIO2+Sm9a7DVqZg= =CBON -----END PGP SIGNATURE-----