[Info-vax] SQLite and vmsvfs

[hb]

On 10/31/2016 03:36 PM, Neil Rieck wrote:
> I have been playing with SQLite3 on OpenVMS for the past few days now and have published my notes here:
>  
> http://www3.sympatico.ca/n.rieck/docs/openvms_notes_sqlite.html
>  
> Neil Rieck
> Waterloo, Ontario, Canada.
> http://www3.sympatico.ca/n.rieck/ 

I created a JDBC driver for this version as well. If there is interest, ...

$ sqlite3 sample.db
Initialization option - trace : 0
Initialization option - default_vfs : openvms
Initialization option - lock_method : 0
Initialization option - perf_timer : 1
OpenVMS VFS module initializing...
--RMS native implementation 1.3.2, override: getcwd,xFullPathname
SQLite version 3.14.1 2016-08-11 18:53:32
Enter ".help" for usage hints.
sqlite> select * from person;
1|leo
2|yui
sqlite>  Exit

 ELAPSED:    0 00:00:03.45  CPU: 0:00:00.03  BUFIO: 52  DIRIO: 29
FAULTS: 147
$
$ def SQLITE3_VMS_OPTIONS
"trace:-1","default_vfs:openvms","lock_method:0","perf_timer:0"

$ java Sample
name = leo
id = 1
name = yui
id = 2
$