[JBoss-dev] [Nukes Development] - postgres and cmp issues

[jae77 <nu...@jb...>]

i've tracked down the postgres problem, and it stems from the fact that the db does not support "auto-increment" in the same way that hsqldb (and i'm assuming mysql does) - rather then repost past disucssions, use the following as a search criteria if you want to read up on it "postgres AND create AND primary AND key".

in order to get around this, the sql-type of the primary key needs to be set to "SERIAL". this will be added to the individual db properties files in the build/etc dir so it can be set per database (every other db should work w/ "INTEGER", but being that i don't have oracle installed, someone will have to test that).

i'm surprised this issue hasn't come up before, as i don't think any of the modules writing to the db should currently work w/ postgres (i tried the faq module, and it doesn't work either) - or perhaps this is just an issue w/ moving to a pure cmp solution. 

in any case, thx again joe for helping to track this down. i'll post another message once i've completed my changed and checked everything in. 

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835259#3835259

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835259