Nice article on building a user community

http://headrush.typepad.com/creating_passionate_users/2006/12/how_to_build_a_.html

Re: Derby with JBoss ?

I think that would be a great thing to post, both on this list and perhaps on the JBoss forum, if such a thing exists... David Charlie Kelly wrote: Hi David, Yes, the EntitytManager is based on Hibernate; and Derby and Hibernate work well together. There is an error in the xml files that a

Re: Update Trigger Issues

Hello Alex, Your update trigger condition is on the entire table which will result in self-triggers firing repeatedly on the same table. Derby does not allow that,m there is an existing issue logged for that - http://issues.apache.org/jira/browse/DERBY-1261 Hopefully this helps, try referen

Update Trigger Issues

I have some issues with triggers; generally I like the SQL Triggers in Derby very much, however, I am stuck now: I want to add two triggers to a table, that automatically set a timestamp, when a record is inserted and when it is updated. the insert part works fine, however I fail with the upda

Re: Re: database in jar slower?

Thanks for your test results! I've put my databases in jar files, ran some use case tests (contains a lot of "SELECT x FROM y WHERE z = v" queries) and the database in jar indeed seems to be faster: In jar: Hs_EGFR1_NetPath_4:3218 ms Hs_Fatty_Acid_Synthesis:260 ms Hs_iInsulin_Signalli