[Info-vax] SQLite port for OpenVMS (Re: Is there currently a functioning link for hobbyist licenses?)

[Craig A. Berry]

On 3/13/15 5:13 PM, hb wrote:
> On 03/12/2015 06:26 PM, hb wrote:
>
>> SQuirreL? With a JDBC driver for VMS - available for testing - this
>> should work. Although, "The minimum version of Java supported is 1.6.x
>> as of SQuirreL version 3.0.": this would be I64. SQLite is not listed in
>> SQuirreL's "supported" drivers, but on Linux I has no problem to load
>> and use the SQLite JDBC (which is used for VMS, aka complemented with
>> JNIs for VMS). I haven't tested it, as I currently have no access to a
>> I64 system to try it.
>
> For what it is worth, I could do some testing with SQuirreL on VMS. It
> installs but at the very end there is an error/problem report in a
> Unix/shell script, which I ignored. From the available scripts I derived
> how to run it. It starts without a problem - except the splash screen
> isn't shown (which is a Java/OpenVMS problem). So I got the GUI running
> on VMS and displayed by the X11 server running on a Linux box. The JDBC
> drivers for SQLite3 and rdb need to be configured. I used the already
> mentioned JDBC for SQLite3 and connected to a local database. I also
> used rdbThin (client and server) both running on VMS (on the local and a
> remote system). SQuirreL connected to two rdb databases, a local and a
> remote one. Although I only did initial testing, SQuirreL seems to work
> as expected.
>
> I didn't try the native rdb JDBC driver. But I also ran SQuirreL on the
> Linux box with the rdbThin client and connected to the - now both remote
> - rdb database on the VMS systems running the rdbThin server.
>

Once upon a time I created a PCSI kit to install Squirrel SQL Client on VMS:

ftp://ftp.hp.com/pub/openvms/freeware/squirrel_sql/freeware_readme.txt

See the above link if you really want the cute little acorn icon on your
DECwindows desktop. There's also a command procedure in there to set up
the Java classpath. I think that was in the Squirrel SQL 1.5 era and I'm
pretty sure someone else did another port in the 2.x era. Not that these
"ports" really did much except tinker with configuration details.