Re: BLOBs etc

On Fri, 7 Jan 2005, [ISO-8859-15] Sven Köhler wrote:

> on the jdbc-webpages it says, that the JDBC team may decide to change
> getBLOBG/setBLOB to support bytea only, and that one should use the
> PostGreSQL specific LargeObject extension to acces them.

I'm not sure where it says that, but it is either out of date or just
plain bad advice. If you could point out where it says that I'd
appreciate it. I would stick withe the standard Blob interface for now.
There are no plans to change this until better lob support is added to the
server and I don't know of anyone working on that. Even when
that happens backward compatibility will be provided by a URL parameter.

> Well, how should one be abled to use the LargeObjects extension, when
> ConnectionPools are used? The Connection object supplied by the
> ConnectionPool implementation is usually not the one supplied by the
> JDBC driver and therefor the object cannot be casted to PGConnection
> anymore. So the LargeObject extension cannot be used anymore like
> suggested on the page

That depends on your connection pool. For example jakarta's dbcp allows
access to the underlying connection like this:

PoolingDataSource dataSource = ...;
dataSource.setAccessToUnderlyingConnectionAllowed(true);

Connection conn = dataSource.getConnection();
Connection realConn = ((DelegatingConnection)conn).getInnermostDelegate();
PGConnection pgConn = (PGConnection)realConn;

Kris Jurka