Re: PreparedStatement returns different result than regular Statement???

[Mark Matthews]

s.a.w.gooren wrote:
> CREATE TABLE test(
> id int(2),
> guid varbinary(16)
> );
>
> INSERT INTO test(1, UNHEX(REPLACE(UUID(),
> _utf8"-", _utf8"")) );
>
> When I run some java code:
>
> // Case 1: regular connection:
> ResultSet rs = statement.executeQuery("SELECT guid
> FROM test WHERE id=1");
> byte[] bytes = rs.getBytes("guid");
>
> // Case 2: preparedStatement
> PreparedStatement ps = connection.prepare("SELECT
> guid FROM test WHERE id=?");
> ps.setInt(1, 1);
> ResultSet rs2 = ps.executeQuery();

Maybe need an rs2.next() here?

> byte[] bytes2 = rs.getBytes("guid");

This should be rs2.getBytes(), I'm assuming?
>
> On my systems bytes contains a different value
> from bytes2.
> This problem did not exist in the 3.0.x driver,
> but after switching to 3.1.6 it was introduced.
> Setting "useServerPrepStmts=false" obviously fixes
> it, but it's not really a solution.

I just tested with 3.1.6 and MySQL-4.1.8 and I get the same values for both byte[]s.

Is there something else that could be affecting this (charsets for example, are you running with 'latin1' or something else?)

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html