Re: SQLite JDBC on VMS x86-64

On 1/11/2025 5:24 PM, Arne Vajhøj wrote:

This is a little HOWTO.
 1) Get latest SQLite for VMS from https://sourceforge.net/projects/vms- ports/files/SQLITE3/
    (currently sqlite3_vms_051.zip)
2) Build with 64 bit pointers using MMS:
      $ mms/macro=(pointer_opt=64)
3) Get latest SQLite JDBC driver from https://github.com/xerial/sqlite-jdbc
    (currently sqlite-3.47.2.0.jar)
4) Get latest NativeDB.c from https://github.com/xerial/sqlite-jdbc/ tree/master/src/main/java/org/sqlite/core
5) Generate JNI shareable image using COM file below.
 $ jcc := cc/pointer=64/name=(as_is,shortened)/reent=multi/float=ieee/ ieee=denorm/include=(sys$common:[openjdk$80.include],sys$common
:[openjdk$80.include.openvms],sqlite3_include)"
$ javah -cp sqlite-jdbc-3_47_2_0.jar org.sqlite.core.NativeDB
$ ren org_sqlite_core_NativeDB.h NativeDB.h
$ jcc NativeDB
$ pipe java$build_option NativeDB.obj > NativeDB.opt
$ link/map/share=sqlitejdbc NativeDB + NativeDB/opt + sys$input/opt
sqlite3shr64/share
$
$ exit
 When running your JVM language application just put
the JDBC har in classpath and define java.library.path to
point to directory with sqlitejdbc.EXE

And have a logical sqlitejdbc pointing to sqlitejdbc.EXE
(unless it is in current directory)

                                       .
 Example:
 $ javac Demo.java

$ define/nolog sqlitejdbc sys$disk:[]sqlitejdbc.exe

$ java -cp .:sqlite-jdbc-3_47_2_0.jar -Djava.library.path=. Demo

Arne