1 Reply Latest reply on Oct 13, 2005 5:20 AM by mroosendaal

    Jboss4.2 vs Postgres

    aneiba

      Dear All,

      I have upgrated my application server (Jboss3.2) to 4.2 and when i deployed my App.ear into deployment director of Jboss4.2, it works fine but when i carry out a function which is to do with the database(Postgres) such as insert ot update, an error shows up saying:

      ERROR: insert or update on table "diary" violates foreign key constraint "$2"

      P.S. i am using Jboss4.2, Ant 1.6 and postgres 8.0

      Any thought in that, please?

      Thanks

      Adel

        • 1. Re: Jboss4.2 vs Postgres

          Make sure you have change the following in you postgres-ds.xml:


          <type-mapping>PostgreSQL 7.2</type-mapping>


          Map it to your version, check the standardjaws.xml for the correct syntax