ok - i've checked in some changes, but i'm not sure if they will 100% solve the problem. i can successfully create topics, but i am unable to post a story. it keeps telling me that i am trying to insert null into the topic_id column (but a quick debug session shows that the topicEJBLocal object is there when it does the create).

take a look at it and tell me if it works for you. perhaps my postgres install is f-ed up - i'm not really all that familiar w/ the admin side of it.

i added xdoclet tokens the the db fragment files, defining the sql-type for postgres to be "SERIAL" (all others are "INTEGER").

when you take a look at the xdoclet, i don't think the fact that i'm not using the "unknown-pk" method makes any difference (altho someone pls let me know if this is wrong!) - and either way, the db is controling it, i just wrote a specific getter/setter for it.

my gut tells me i'm missing some postgres specific configuration, but given my previous statement that i'm not really familiar w/ postgres, it could just be gas. :)

let me know!

i tried using the unknown-pk setup as well and i still couldn't get the rows to insert. i have one last thing that i'm going to try, and if i can't get it working i'll create postgre specific ddl.

ok - in order for this to work correctly w/ postgres, the "insert-after-ejb-post-create" flag needs to be set to true on the entity bean container configuration and "dummy" values need to be set for the primary keys in the "ejbCreate" methods.

i'm thinking that it may be a good idea to just enable this directly in the standardjboss.xml file, instead of having each of the individual modules create a specific container config just to enable this.

i'll get this updated tonight and post back w/ any final instructions that you would need to perform on your end. i'll also put something on the wiki for this.

thx to juha and sesques for pointing me in the direction!

i've checked in the latest changes that should resolve the postgres compatiblity issues.

for now, i've created a specific container configuration for news, instead of going to the global standardjboss.xml file - defining "post-create = true" there causes inserts into the "core" tables not work work properly (those ejbCreate methods need to be updated w/ the "dummy" pk values).

i've tested this against postgres and hsqldb, and have found no issues. my fingers are crossed that mysql will have no problems as well (any oracle users out there to test this?).

let me know if you have any problems.

in the works of mr. burns.... excellent! :)

there's a little bit of a headache here, but nothing that can't be overcome, esp now that i know how to resolve the issue.

i've recommitted changes that remove the "hacks" and instead define sql/jdbc-type xdoclet tags on the foreign key relations so that the columns can be created null.

you should drop your tables and re-create them (both for news and downloads), however you can export and reload any data you may have created b/c the table definitions stayed the same.

the only modification you will have to make to the dataset is to update any foreign key columns that have 0 as their value to be null.