[SOLVED] traccar - H2 database

kzo81 · 09-30-2021, 03:40 AM

Hi,

I'm running Traccar in docker and I'd like to connect to its H2 database within the container.

this is my initial code:

Code:

import jaydebeapi


conn = jaydebeapi.connect("org.h2.Driver",
                           "jdbc:h2:/home/user/Documents/traccar/target/database",
                           ["sa", ""],'/usr/local/openjdk-11')
curs = conn.cursor()
conn.close()

this is the error message:

Code:

  File "dbmanager.py", line 5, in <module>
    ["sa", ""])
  File "/usr/local/lib/python3.7/dist-packages/jaydebeapi/__init__.py", line 412, in connect
    jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
  File "/usr/local/lib/python3.7/dist-packages/jaydebeapi/__init__.py", line 221, in _jdbc_connect_jpype
    jpype.JClass(jclassname)
  File "/usr/local/lib/python3.7/dist-packages/jpype/_jclass.py", line 99, in __new__
    return _jpype._getClass(jc)
TypeError: Class org.h2.Driver is not found

I also tried to initialise it with "com.mysql.cj.jdbc.Driver" however I couldnt establish connection.

Could you please help me?

pan64 · 10-01-2021, 01:21 AM

https://stackoverflow.com/questions/...t-python-to-h2
based on this your last argument is incorrect

kzo81 · 10-01-2021, 01:32 PM

Yes, thanks, this is how it works

Code:

conn = jaydebeapi.connect('org.h2.Driver', 'jdbc:h2:/home/user/Documents/traccar/target/database', ["sa", ""], '/opt/traccar/lib/h2-1.4.200.jar')