-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Brian Power wrote:
> yeah, I tried the new connector. but I'm getting strange results when
> using a date field,
>
>
> My sql looks like..
>
> Where R_Date < ? and R_Date > ? and H_ID <> ?........
>
> My code looks like...
>
> perparedStmt.setDate(1,new java.sql.Date(myDate.getTime()));
>
> R_Date looks like...
> R_Date date Not null
>
> It doesn't crash, but it doesn't return the records either.When I use
> the stable connector/j it works fine (but of course, it's not really
> doing a prepared statement in the background)
>
> Also just at the point where I execute the statement, I get strange text
> output to stdout, something like "0 0 0 0 0 8 0 0 0 ......."
The output is from some debug code that has now been disabled.
What does your table look like (i.e. schema, and the minimum amount of
data needed to reproduce the issue)?
I haven't yet seen a bug like this. The JDBC compliance testsuite we
use, as well as our own unit and regression tests cover quite a bit of
java.sql.Date functionality with prepared statements, and they all work.
It looks like we might be working with a corner case here, so I'll need
to see exactly what data causes this to happen in your case.
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
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
iD8DBQFAEUPgtvXNTca6JD8RAi66AKCSKHkC5T4BPI/lx3qkdBuTbeW/HACdGWbt
/FFQi5dEqHbGCWTNWh7Gzpo=
=XWrG
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
