Posted by whartung
on April 23, 2006 at 10:12 PM PDT
I'm getting this as a root cause in my application trying to talk to a Postgres 8.1 DB:
javax.transaction.xa.XAException: javax.resource.ResourceException: This Managed Connection is not valid as the phyiscal connection is not usable
I was getting this in 8.2 as well, but I figured I'd try to upgrade. I also changed my JDBC driver to the latest http://jdbc.postgresql.org/download/postgresql-8.2dev-501.jdbc3.jar
I was following the directions from http://blogs.sun.com/roller/page/Glassfish_PostgreSQL?entry=introducing_...
These are my pool settings from domain.xml:
I saw some mutterings that this may be a BLOB issue? I'm using a TEXT field on this particular table. These are CMP 2.x beans that I am using, not EJB 3.
Can I use Postgres at all for this application? It has a Content component, so it will need to manage BLOB/CLOBs of some kind.
Can I use BLOBs in MySQL or Derby? Is Derby usable for a mostly read, light traffic web site? I'm avoiding these for several reasons, but mostly I'd like to avoid learning a new DB at this juncture.
Any tips are greatly appreciated.