I recently switched backends from Oracle to PostgreSQL. When I start JBoss it works fine. Calling the create and get methods on my CMP entity beans all seem to be working. Everything works fine when I use JDBC directly.
The problem is when I call the set and delete methods. For some reason, these changes aren't being committed to the database.
I'm wondering if there's something wrong with my PostgreSQL configuration. I'm using the JBoss-2.4.4-Tomcat-3.2.3 bundle, PostgreSQL 7.2, the PostgreSQL pgjdbc2.jar downloaded from jdbc.postgresql.org. I have all the environment variables set. I do have Postgres installed in a nontraditional location. Could that affect things?
Here's my jboss.jcml:
<!-- ==================================================================== -->
<!-- JDBC -->
<!-- ==================================================================== -->
org.postgresql.Driver
DefaultDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:postgresql://localhost/pt3
1200000
pt3
10
kumar
false
false
false
true
120000
1800000
false
false
1.0
0
TRANSACTION_READ_COMMITTED
<!-- Connection factory for the Minerva JDBC resource adapter. This
points at the same database as DefaultDS. -->
MinervaDS
JCA:service=RARDeployer
Minerva JDBC LocalTransaction ResourceAdapter
ConnectionURL=jdbc:postgresql://localhost/pt3
I found the thread on Autocommit and this seems to be the issue.