1 Reply Latest reply on Mar 22, 2002 12:00 AM by Steve Park

    CMP set methods not committed to Postgres database

    Steve Park Newbie

      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