Legacy 8.0.2 Question

[former_SQLA_member1694906]

I've been asked to install an ancient version of SQLAnyhere - ASA 8 - to bring an old DB back to life.

I had to install on an old version of Ubuntu (8.04) and it mostly seems to have worked.

However, some of the tools don't.

In particular, dbisql complains "The Java2 runtime environment could be found but not loaded. The application could not be started."

I believe that the ASA8 install installed some old version of Java, but that obviously wasn't quite enough. I even tried a manual install of Java6 - and that made no difference.

Any suggestions on how to get this old bird off the ground?

[former_SQLA_member1694906]

Just wondering the same myself! Not sure what's going on, but dbisqlc not quite enough for me...

[Vlad]

Do you have the ASA Windows installer? Would it be better if you install ASA 8 on Windows?

[former_SQLA_member1694906]

I'm afraid not. It's only the pesky dbisql that doesn't work. I might try a direct copy of the bare metal machine disk we have that does work. It's annoying that this is probably something simple...

[Vlad]

Internet says that Java2 runtime is 1.4.2. Maybe you can install it? Portable, and don't forget about $PATH$ and $JAVA_HOME$.

[VolkerBarth]

Just for curiosity:

What exactly are you missing with dbisqlc? With v8, I think you should be able to run all scripts and queries as with DBISQL. There might be differences w.r.t. the OUTPUT options, and you cannot edit result sets, and it sure does look older, but otherwise?

[Breck_Carter · Accepted solution]

Try installing a later version of SQL Anywhere, and using the dbisql from that version. Multiple different versions of SQL Anywhere can coexist on the same machine, and I have found the same problem you have with earlier versions... later versions of dbisql seem to work fine with older databases, with SQL Anywhere 5.5 being the only one that's on "the other side" of a legacy barrier.

[former_SQLA_member1694906 · Accepted solution]

What a great idea - thanks.

[former_SQLA_member1694906 · Accepted solution]

Awesome! That worked a dream. Strangely, asking for 75% of the memory to be used as cache freaked out 32 bit ASA8 when it found 8GB installed RAM, and it complained of "not enough memory" when it really meant "too much memory", but we are now in business. Many thanks.

[VolkerBarth]

I'd try the C-based DBISQLC, it does not require Java and should be enough to apply SQL scripts and ad-hoc queries. (I still use it with v12.0.1...)