Re: Possible bug with BYTEA and JDBC

Greg wrote:

>Hi,
>
>I am using:
>
>Windows XP Pro SP3 EN
>JDK 1.6.0_u18
>postgresql-8.4-701.jdbc4.jar
>postgresql-8.5alpha3
>
>I followed the steps in the blob tutorial and tried to test the BYTEA example:
>http://jdbc.postgresql.org/documentation/head/binary-data.html#binary-data-example
>I found out that the BYTEA data that is persisted in the db is corrupt. This is the details:
>

Tested successfully on:

Linux Test
JRE 1.5.0_12
postgresql-8.4-701.jdbc3.jar
PostgreSQL 8.3.3 & PostgreSQL 8.4.1 on Linux

Windows XP Pro Test
JRE 1.6.0
postgresql-8.4-701.jdbc3.jar & postgresql-8.4-701.jdbc4.jar
PostgreSQL 8.3.3 on & PostgreSQL 8.4.1 on Linux

Attached test source and sql files for perhaps someone else to quickly
test in an environment that duplicates your exactly. The XP case
most closely matches yours beside SP3 and my PostgreSQL server
is not on the Windows & 8.4.5alpha3. Assume yours is on the XP
machine.

danap