Thread: FW: OID, compatible=7.1 and getBinaryStream() in 7.4 driver + 7.4 database
FW: OID, compatible=7.1 and getBinaryStream() in 7.4 driver + 7.4 database
From
"Alexey Yudichev"
Date:
Can I have any comments on this? -----Original Message----- From: Alexey Yudichev Sent: Wednesday, December 10, 2003 12:17 PM To: pgsql-jdbc@postgresql.org Subject: [JDBC] OID, compatible=7.1 and getBinaryStream() in 7.4 driver + 7.4 database I have noticed that I can use only latest 7.4 driver with 7.4 database. I tried both driver from jdbc.postgresql.org (7.4beta3) and from CVS (:pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot) and discovered that with compatible=7.1flag invoking rs.getBinaryStream() or rs.getBytes() on an OID column blocks forever (somewhere in java.net.SocketInputStreamso I guess it's a server that is not responding). According to 7.4 documentation http://www.postgresql.org/docs/current/static/jdbc-binary-data.html,this should work. getBLOB() works great, but JBoss 3.2server which I am using is only capable of dealing with large objects via getBinaryStream()/setBinaryStream(). Combination "OID, compatible=7.1 and getBinaryStream()" worked well in PostgreSQL 7.2 with latest 7.3 driver. What options do I have? I could migrate to bytea although I don't liked the performance of it. But before I do that I wantto make sure that this issue is a bug that is about to be fixed or something different. Thanks.
Alexey, Can you put together a test case and I'll try to fix it? Dave On Tue, 2003-12-16 at 04:40, Alexey Yudichev wrote: > Can I have any comments on this? > > -----Original Message----- > From: Alexey Yudichev > Sent: Wednesday, December 10, 2003 12:17 PM > To: pgsql-jdbc@postgresql.org > Subject: [JDBC] OID, compatible=7.1 and getBinaryStream() in 7.4 driver > + 7.4 database > > > I have noticed that I can use only latest 7.4 driver with 7.4 database. I tried both driver from jdbc.postgresql.org(7.4 beta3) and from CVS (:pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot) and discovered thatwith compatible=7.1 flag invoking rs.getBinaryStream() or rs.getBytes() on an OID column blocks forever (somewhere injava.net.SocketInputStream so I guess it's a server that is not responding). According to 7.4 documentation http://www.postgresql.org/docs/current/static/jdbc-binary-data.html,this should work. getBLOB() works great, but JBoss 3.2server which I am using is only capable of dealing with large objects via getBinaryStream()/setBinaryStream(). > > Combination "OID, compatible=7.1 and getBinaryStream()" worked well in PostgreSQL 7.2 with latest 7.3 driver. > > What options do I have? I could migrate to bytea although I don't liked the performance of it. But before I do that Iwant to make sure that this issue is a bug that is about to be fixed or something different. > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >