Inconsistent Loading of Bytea accross platform

Поиск
Список
Период
Сортировка
От Marc-André Laverdière
Тема Inconsistent Loading of Bytea accross platform
Дата
Msg-id 4CFC754F.9060600@atc.tcs.com
обсуждение исходный текст
Ответы Re: Inconsistent Loading of Bytea accross platform
Список pgsql-jdbc
Hello,

Our team has recently upgraded from PostgreSQL 8.4 to 9.0. We ran all
our tests on one Linux box, and everything ran fine. However, we ran
into problems in our pre-production environment. Here are the details

Developer's box: Ubuntu 10.10 with Sun JDK 1.6.0_22-b04
Preprod box: Windows 2003 server SP2 Enterprise Edition with Sun JVM
1.6.0_22-b04

We are using Hibernate 3.6 with infinispan cache and the latest JDBC
driver (build 801).

Our table has 2 bytea columns. The columns are supposed to contain data
of size 256 bytes. On the Linux box, we get our 256 bytes correctly. On
the Windows box, we get 511 bytes however.

I detailed my problem here:
http://stackoverflow.com/questions/4335088/hibernate-not-loading-postgresql-bytea-consistently

After narrowing it down, it seems like the issue would be in the driver,
not Hibernate, as I have the same problem using JDBC. Here is some
sample code.

ssess = xyz.getFactory().openStatelessSession();
Connection rawConn = sess.connection();
PreparedStatement ps =
  rawConn.prepareStatement("select encryptedkey,encryptediv from abc
where id=?");
ps.setString(1,"fff4f538-aea5-4703-b9d6-dcd7829766e4");
ResultSet rs = ps.executeQuery();
if (rs.next()){
    byte[] key = rs.getBytes("encryptedkey");
    byte[] iv = rs.getBytes("encryptediv");
    logger.info("Key:{}\tIV:{}", key.length, iv.length);
}
rs.close();
ps.close();
conn.close();

Any ideas what could be wrong here?

--
Marc-André Laverdière
Software Security Scientist
Innovation Labs, Tata Consultancy Services
Hyderabad, India

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Maciek Sakrejda
Дата:
Сообщение: Re: Driver work slow with new upgrade of Openjdk in Ubuntu
Следующее
От: Marc-André Laverdière
Дата:
Сообщение: Re: Inconsistent Loading of Bytea accross platform