[JBoss-dev] Using postgreSQL 7.3.2 with JBoss 3.0.6

hi all, I am trying to using postgreSQL 7.3.2 with JBoss 3.0.6 on Win2K JDK1.4.1 b2 but I run into some problems: 1. create table failed. I have tried the code with the default Database setting and it works fine, when I switch to PostgreSQL, the problem pop up. 2003-04-02 12:30:58,796

[JBoss-dev] Anybody ever had problem with CMR when using PostgreSQL ?

I have 2 CMP entity beans that have one to many relationship. The "Many" side have a foreign key "user_id" that reference primary key in another table. If I declare the foreign key as both CMP and CMR fields, it works only with the default database, doesn't work with postgreSQL. postgresql