Installation

A package for installing jaydebeapi-hsqldb from pypi.org will soon be available To install jaydebeapi-hsqldb from pypi.org, open a command prompt and type:

pip install jaydebeapi-hsqldb

Alternatively the module can be downloaded from its repository on GitHub:

jaydebeapi-hsqldb repository

Use the ‘pip install <path>’ syntax to install, where <path> points to where your local copy is installed, e.g.

pip install ./jaydebeapi-hsqldb

Post-install Configuration

Your system needs to know where the Java Runtime Environment is. If not detected automatically you may need to add ‘JAVA_HOME’ or ‘JRE_HOME’ to your environment variables.

set "JAVA_HOME=C:\Program Files\Java\jre-1.8\bin"

import jaydebeapi_hsqldb as jaydebeapi

jclassname = 'org.hsqldb.jdbc.JDBCDriver'               # driver path
url = 'jdbc:hsqldb:hsql://localhost/db1'                # connection string
driver_args = ['SA', '']                                                # username and password
jars = ('/PROGS/HSQLDB/hsqldb-osgi-jdk8.jar',)  # location of HSQLDB jar

try:
        conn = jaydebeapi.connect(
                jclassname,
                url,
                driver_args,
                jars
        )
        curs = conn.cursor()
        curs.execute('VALUES(DATABASE_VERSION())')
        version = curs.fetchone()[0]
        print(f'\nSuccessfully connected!\nHSQLDB version: {version}\n')
        curs.close()
        conn.close()
except Exception as e:
        # Connection failed...
        print(f'\n{repr(e)}\n{str(e)}\n')

Troubleshooting

This project was coded and tested on a 64-bit Windows system. It should work on other platforms too, but you may find the code examples and docs need adapting.

If you’re struggling to get jaydebeapi-hsqldb working, here are a few things you can try:

• Avoid mixing 32-bit and 64-bit software components

• If the Java Runtime Environment (JRE) is not automatically detected you may need to add ‘JAVA_HOME’ or ‘JRE_HOME’ to your environment variables.

• If you suspect a permissions issue, try installing and running with an administrator account.

• If you suspect a firewall issue, temporarily disable the firewall to see if this is the case.

• If you suspect some other configuration issue, ensure all paths specified are correct. Use back slashes or forward slashes as appropriate for your OS. Do they need escaping?

• Submit a question via StackOverflow!

  It’s quite possible others have already encountered the same issue and SO can often provide a quick response. Tag your question with an appropriate tag, such as ‘jaydebeapi-hsqldb’, which I can then monitor.

If you think you’ve found a bug please feel welcome to submit a report via GitHub:

• jaydebeapi-hsqldb issues

Changelog

0.0.3 Added support for more data types. 0.0.1 Initial release.