[h2] Coonnecting to H2 Database from Python in a Windows 10 laptop

[Sandy James]

Folks,
I am stumped. I am trying to connect to H2 database from pythong using
JayDeBeApi.

on a Windows 10 machine.

I installed the JayDebeApi package. ( https://pypi.org/project/JayDeBeApi/)

When I try to run , I get the following error -

*jpype._jvmfinder.JVMNotFoundException: No JVM shared library file
(jvm.dll) found. Try setting up the JAVA_HOME environment variable
properly.*


I have jdk installed on my system.

I tried tweaking the JAVA_HOME but that did not make a difference.


I do see the jvm.dll in 2 folder -

here - C:\Program Files\Java\jre1.8.0_171\bin\server and
here - C:\Program Files\Java\jdk1.8.0_171\jre\bin\server



I tried the following -
C:\Program Files\Java\jre1.8.0_171
C:/Program Files/Java/re1.8.0_171

C:\Program Files\Java\jdk1.8.0_171
C:/Program Files/Java/jdk1.8.0_171


No luck. Truly stumped!

Anyone tried using JayDebeApi in python to connect to H2 database?

[Evgenij Ryazanov]

Hello.

Your current problem is not related with H2 at all and most likely is not
related with JayDeBeApi.

jpype library cannot find JVM on your system. You need to ensure that
Python and JVM use the same architecture (either 32-bit or 64-bit). If they
match with each other try to ask jpype community for help.

If they don't match try to install JRE for the same architecture as Python
first. jpype cannot find JDK on Windows due
to https://github.com/jpype-project/jpype/issues/345

[Sandy James]

That was it. when you install the default version is 32 bit. I uninstalled and installed the 64 bit version.
The error message was not clear at least to me.

Yeah, I was sure it wasn't an H2 issue.
But was sure someone in the group may have encountered in this group or have at least come across it.

Thanks for your help!