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?

asked 08.04 at 04:49

TareqK's gravatar image

accept rate: 33%


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: https://answers.axonivy.com/questions/960/use-the-latest-hsqldb-within-my-project

(14.04 at 06:07) Reguel Werme... ♦♦ Reguel%20Wermelinger's gravatar image

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.}

It would make a great addition to the axon ivy DB roster for future releases tho

(14.04 at 06:25) TareqK TareqK's gravatar image
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 08.04 at 04:49

Seen: 119 times

Last updated: 14.04 at 06:25