From: arne@vajhoej.dk   
      
   On 1/11/2025 10:46 PM, Arne Vajhøj wrote:   
   > 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   
      
   It is "or" not "and". Either the logical or the define.   
   But the logical is preferable as the define can be tricky   
   with other JVM languages.   
      
   And for those that prefer JPA and JPQL over JDBC and SQL,   
   then out of the box Hibernate 5.6 and the SQLite dialect from   
   https://mvnrepository.com/artifact/com.github.gwenn/sqlite-dialect   
   works fine.   
      
   Arne   
      
   --- SoupGate-DOS v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)