traccar with Oracle DB

[xizoaziz]

Hi vitalidze

can we use Oracle DB in traccar instead of H2

thanx

[vitalidze]

Traccar-web uses hibernate library, which has an oracle dialect. I have experience with application that worked through hibernate with oracle, mysql and sqlserver database engines. I haven't tried traccar with oracle, but it should work if you configure it properly. Briefly, you need:

1) JDBC driver for oracle database put at some folder accessible by traccar application

2) Add JDBC driver to the traccar classpath. This should be done in wrapper.cfg file.

3) Update following entries in traccar.cfg file (see https://www.traccar.org/configuration-file/):

• database.driver change database driver classname to the oracle's
• database.url - you need to read some docs on how to properly set it up
• database.user
• database.password
• database.selectDevice, database.insertPosition and database.updateLatestPosition queries. Maybe default ones will work, but I'm not sure

Then after all these things are set up and restarting service you should try accessing web interface, which should create your database tables. Then check wrapper.log file for error messages.

Generally, I would recommend to stick with MySQL database, which is proven to work without any issues. Also there is an official documentation on how to set up this database, which is much less painful than oracle set up.

[xizoaziz]

thank u very much i will try and notify you with the result

[xizoaziz]

it is working now but i faced some issues i fix all issues and i will post a replay her for what i did ..

many thanks to you and thanks for your great product

[gpproton]

Hu @xizoaziz i'll like to know how you made oracle to work with Traccar web, i've not had any luck with it, and i desperately need to make it work.