connect to camunda database

(1) By Parth (parthdatwani251000) on 2022-03-31 23:38:09 [source]

Hi i am trying to connect SQLite to camunda run. I need jdbc URL and class name for that can anyone suggest me how do I get that and as I am new I would also like links or demo to use SQLite

(2) By Gunter Hick (gunter_hick) on 2022-04-01 05:25:11 in reply to 1 [link] [source]

What exactly do you mean by "connect"?

SQLite is in C, Camunda is in Java, so you will need to use JNI to interface between the two languages.

If you want to access Camunda microservices withtin SQL Queries in SQLite, you will need to write functions and/or virtual tables to match the interfaces.

Working the other way round you can either write JNI classes to call the SQLite C interface functions or some kind of jdbc. Not being familiar with Javev I cannot offer advice on the latter.

(3) By MBL (UserMBL) on 2022-04-01 08:54:26 in reply to 1 [link] [source]

I understand the request as if you need a JDBC driver for SQLite3 or an appropriate compilation that offers you JDBC.

I succeeded with the driver sqlite-jdbc-3.37.2.jar from MVNrepository with my own requirement for a newer version of SQLite3 than I had at hand before.

The URL template I use:

jdbc:sqlite:[location=file?<file>][location=in-memory?file:<database>?mode=memory&cache=shared]

The Driver class: org.sqlite.JDBC

The Driver version: 3.37.0

I did not check if meanwhile any newer driver would be available at that site.