https://answers.axonivy.com/questions/4494/using-derby-database-in-axon-ivy<p>Hello, Is there any way to use the apache derby database in AxonIvy platform 8.0? I tried adding the driver to the project buildpath and configuring the database, but it isnt working through the editor. Is there something that i need to do for it to work?</p>enTue, 14 Apr 2020 06:25:52 -0400https://answers.axonivy.com/questions/4494/using-derby-database-in-axon-ivy#4503<p>I Actually wanted derby for non-memory useage - HSQLDB has some restrictions in querying that i dont like that cause hibernate to go insane with N+1 selects and application side filtering. I did endup using HSQLDB, and its ok anyway, since we are going production with MySQL, but having Derby is nice since its closer to production setups(Ive used it for entire applications before, that had ~5 gb of data per instance), and is a fair bit more optimized with off-heap memory and very stable for development use.}</p> <p>It would make a great addition to the axon ivy DB roster for future releases tho</p>TareqKTue, 14 Apr 2020 06:25:52 -0400https://answers.axonivy.com/questions/4494/using-derby-database-in-axon-ivy#4503https://answers.axonivy.com/questions/4494/using-derby-database-in-axon-ivy#4502<p>not answering the question but I wonder why you want to use derby. If it's just to have a small memory database, you may want to use HsqlDB instead. We've just updated the included version to a version that actually is fun to use: <a href="https://answers.axonivy.com/questions/960/use-the-latest-hsqldb-within-my-project">https://answers.axonivy.com/questions/960/use-the-latest-hsqldb-within-my-project</a></p>Reguel WermelingerTue, 14 Apr 2020 06:07:46 -0400https://answers.axonivy.com/questions/4494/using-derby-database-in-axon-ivy#4502