From: arne@vajhoej.dk   
      
   On 1/11/2025 8:12 PM, Lawrence D'Oliveiro wrote:   
   > On Sat, 11 Jan 2025 17:24:52 -0500, Arne Vajhøj wrote:   
   >> 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.   
   >   
   > Isn’t there a more direct way yet, to access the world’s most popular   
   > DBMS from Java?   
   >   
   >    
      
   Not really.   
      
   The context put some constraints on the options.   
      
   SQLite is an embedded database. SQLite is written in C.   
      
   The only way for Java to ensure 100% compatibility with native   
   code is to have the Java code call the same C code. That   
   means the JDBC driver will include native code (type 2 driver).   
      
   The application programmer do not care about the implementation   
   only about the API. Most Java code use the JDBC API or an   
   ORM on top of JDBC. Android additionally offers an Android   
   specific API.   
      
   But the implementation is still needed. Out of the box   
   driver comes with:   
      
   org/sqlite/native/Mac/x86_64/libsqlitejdbc.dylib   
   org/sqlite/native/Mac/aarch64/libsqlitejdbc.dylib   
   org/sqlite/native/Linux/armv7/libsqlitejdbc.so   
   org/sqlite/native/Linux/arm/libsqlitejdbc.so   
   org/sqlite/native/Linux/x86_64/libsqlitejdbc.so   
   org/sqlite/native/Linux/riscv64/libsqlitejdbc.so   
   org/sqlite/native/Linux/x86/libsqlitejdbc.so   
   org/sqlite/native/Linux/ppc64/libsqlitejdbc.so   
   org/sqlite/native/Linux/armv6/libsqlitejdbc.so   
   org/sqlite/native/Linux/aarch64/libsqlitejdbc.so   
   org/sqlite/native/Linux-Musl/x86_64/libsqlitejdbc.so   
   org/sqlite/native/Linux-Musl/x86/libsqlitejdbc.so   
   org/sqlite/native/Linux-Musl/aarch64/libsqlitejdbc.so   
   org/sqlite/native/Windows/armv7/sqlitejdbc.dll   
   org/sqlite/native/Windows/x86_64/sqlitejdbc.dll   
   org/sqlite/native/Windows/x86/sqlitejdbc.dll   
   org/sqlite/native/Windows/aarch64/sqlitejdbc.dll   
   org/sqlite/native/FreeBSD/x86_64/libsqlitejdbc.so   
   org/sqlite/native/FreeBSD/x86/libsqlitejdbc.so   
   org/sqlite/native/FreeBSD/aarch64/libsqlitejdbc.so   
   org/sqlite/native/Linux-Android/arm/libsqlitejdbc.so   
   org/sqlite/native/Linux-Android/x86_64/libsqlitejdbc.so   
   org/sqlite/native/Linux-Android/x86/libsqlitejdbc.so   
   org/sqlite/native/Linux-Android/aarch64/libsqlitejdbc.so   
      
   so people on those platforms do not need to do anything.   
      
   OpenVMS did not make the cut. So we need to find   
   a way to provide that native module for VMS.   
      
   Builds for VMS Alpha and VMS Itanium have been available   
   for years, but I have not seen anything for VMS x86-64,   
   so I created something.   
      
   It must be the same for that Android specific API. Google   
   just make sure the native piece is there.   
      
   If the database is a database server or written in Java, then   
   the JDBC driver can be made all Java (type 4 driver) and   
   life is easier because same driver can be used everywhere.   
      
   Arne   
      
   --- SoupGate-DOS v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)