1 Reply Latest reply on Feb 21, 2003 8:56 AM by John M. Nordgaard

    CMP Jboss3 doen't create data in Postgres DB

    Lamouret Newbie

      Hi

      I've migratting from Jboss2.4.9 to Jboss3.0.4 to use CMP2.0
      The trouble is that when i'm created data with CMP Entity Bean, the data stored in Hypersonic DB and not in PostgresDB.

      Here is my jbosscmp-jdbc.xml
      <?xml version="1.0" encoding="ISO-8859-1"?>

      <jbosscmp-jdbc>

      java:/PostgresDB
      <datasource-mapping>PostgreSQL</datasource-mapping>
      <create-table>false</create-table>
      <remove-table>false</remove-table>
      <pk-constraint>true</pk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>

      <enterprise-beans>

      <ejb-name>TvnJobName</ejb-name>
      <table-name>job</table-name>
      <cmp-field>
      <field-name>jobId</field-name>
      <column-name>job_id</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>serverId</field-name>
      <column-name>server_id</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>name</field-name>
      <column-name>name</column-name>
      </cmp-field>

      </enterprise-beans>
      </jbosscmp-jdbc>


      The datasource java:/PostgresDB is defined in postgres-service.xml in the deploy directory.

      Could you help me ?


      tia

      Bruno