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