Hi Joshua, welcome to the Marmotta community!
The short answer is: Yes, at the moment you are limited to Postgresql/MySQL/H2. The long answer: LMF [1] (from where Marmotta originates) once had experimental support for Oracle but that was long ago when we still used hibernate as a persistence layer. Hibernate was dropped due to performance considerations several versions ago. Until now, a Oracle backend was not a requirement for the project. Also, for a serious production setting you need a deep understanding of DB-specific performance tweaks regarding query optimisation and db-indexes. Sebastian did this for postgresql and it brought us a performance gain by magnitudes for certain operations. However, for Oracle I fear we do not have such an expert on the current development team. If you are familiar with Oracle as relational database, we would welcome any contribution towards an oracle backend for kiwi - just join d...@marmotta.apache.org for discussion and pointers were to start. Best, Jakob [1] http://lmf.googlecode.com/ On 24 April 2014 17:56, Joshua Dunham <joshua_dun...@vrtx.com> wrote: > Hi Marmotta Users, > > I’m new to the group (Hi) and wanted to see about the possibility of an > Oracle based > backend store. I see there is reference to it in the older > config-defaults.properties, > > # Hibernate-specific configuration for Oracle > database.oracle.url = jdbc:oracle:thin:@//localhost:1521/XE > database.oracle.driver = oracle.jdbc.OracleDriver > > > but those options don’t exactly work for me when I try to manually code them > in with the appropriate changes for my db instance. > > Is there a possibility to use Oracle or am I limited to mySQL/Postgresql. > > Thx, > -Joshua > This email message and any attachments are confidential and intended for use > by the addressee(s) only. If you are not the intended recipient, please > notify me immediately by replying to this message, and destroy all copies of > this message and any attachments. Thank you.
