-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Tea Yu wrote:
Not really, I substituted the queryStmt with the actual one but it gave
the
same result.
After some work:
select last_insert_id(); //getInt() should return 14 //but now it gives java.sql.SQLException: Invalid value for getInt() - 'qt' at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:1348)
where thisRow([0]) that ResultSet holds was = (49, 52)
I haven't looked deeper into ResultSet and StringUtils... Is this as expected?
My platform is WinME and my JRE is 1.4.1_01
thanks tea
The only way I can debug this is if you give me a repeatable test case. Since the test case I showed you does not repeat the bug, you will need to generate a standalone test case, with schema, data, and the java code that demonstrates the issue.
-Mark
Hey mark, here are the files that repeats my test.
P.S. Test.class was compiled by J2SDK1.4.1_01 on WinME, just in case you need to compare this with your compiled ver. JDBCDriver used was mysql-connector-java-3.1.0-alpha-bin.jar.
Thanks Tea
I actually found what was causing this earlier today. It is an odd case that only happens when your JVM's default encoding is not single-byte (so I never saw it in my testsuites).
It is fixed in the nightly snapshots of both Connector/J 3.0.x and 3.1.x that will be up by tomorrow (the compile and upload happens at 00:00 GMT), see http://mmmysql.sourceforge.net/snapshots/.
-Mark
- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.orgiD8DBQE+Yr5gtvXNTca6JD8RAlBQAKCd+op/ojys+Gf9ZuOZz22jUfl6YgCfStul MB8f3v64KjADyGs9TqdRrBk= =4Eu5 -----END PGP SIGNATURE-----
--------------------------------------------------------------------- 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
