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

2004-05-27 Thread jae77
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

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

2004-05-20 Thread joehobson
jae77 wrote : i've checked in the latest changes that should resolve the postgres compatiblity issues. | ... | let me know if you have any problems. I updated via CVS and it works great on my postgreSQL database. Thanks for your hard work on this one. I was beginning to wonder if CMP was

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

2004-05-20 Thread jae77
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. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3835676#3835676 Reply to the post :

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

2004-05-19 Thread jae77
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

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

2004-05-18 Thread sgwood
Sorry I didn't bring this up earlier (am busy keeping the company afloat here) but there are a few issues I can clear up. The installer, which Noel wrote initially and I enhanced, uses the setup.xmls to create and populate the database tables for the selected modules, before deploying the

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

2004-05-18 Thread jae77
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. View the original post :

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

2004-05-18 Thread jae77
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

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

2004-05-17 Thread joehobson
I posted an update with some additional thoughts on the user side, continuing the previous discussion. The dev forum is a better place for CMP issues than the user area of course. See what i speculated on that side... http://www.jboss.org/index.html?module=bbop=viewtopict=48788start=10 ...

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

2004-05-17 Thread jae77
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

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

2004-05-17 Thread joehobson
I downloaded your changes for the TopicEJB and tried it out with no luck - same problem as before. Since i didn't completely understand how it would be different from the faq module I dropped my faq tables (manually this time, relied on the installer to do it last time) and rebuilt redeployed