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
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