LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (https://www.linuxquestions.org/questions/programming-9/)
-   -   traccar - H2 database - python connection (https://www.linuxquestions.org/questions/programming-9/traccar-h2-database-python-connection-4175701269/)

kzo81 09-30-2021 03:40 AM
traccar - H2 database - python connection
 
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')


All times are GMT -5. The time now is 05:20 AM.