On Oct 1, 2008, at 8:47 PM, Claire McLister wrote:

> Hi,
>
>  We have an application running on Tomcat and are evaluating
> migration to Resin.
>
>  One of the current sticking points is the use of Postgresql Large
> Objects. In the Tomcat configuration, we could use the
> 'allowAccesstoUnderlyingConnection' property to access the
> PGConnection object and use the large object API from there.

You can either use Resin's getConnection() method or the unwrap method,

Connection conn = _database.getConnection();

PGConnection pgConn = conn.unwrap(PGConnection.class);

or

PGConnection pgConn = (PGConnection) ((com.caucho.sql.UserConnection)  
conn).getConnection();

-- Scott

> It seems Resin supports the retrieval of the Connection object from
> the Datasource, but trying to cast it into a PGConnection gives an
> exception.


>
>
>  Can someone please tell us how we can use Large Object API from
> within the Resin container.
>
>  Thanks for any pointers.
>
> Claire
>
>
>
> _______________________________________________
> resin-interest mailing list
> resin-interest@caucho.com
> http://maillist.caucho.com/mailman/listinfo/resin-interest



_______________________________________________
resin-interest mailing list
resin-interest@caucho.com
http://maillist.caucho.com/mailman/listinfo/resin-interest

Reply via email to