Problème with java version or hsqldb driver version in base?

[gelinp]

Hi,

I’ve using LibreOffice 7.1.3.2 on both a Windows 10 Pc and Linux Mint. I’m writing a base application with external hsqldb connexion, both with hsqld driver 2.4.1. On Windows I’m using Java version Oracle 1.8.0.311 but on linux I don’t know (I coul’d know this evening only…)

With Linux all is runnning, but with Windows 10 a sub form doesn’t refresh : I can see that unoform.command doesn’t assign, ant even with Access2Base, oA2BForm.RecordSource doesn’t assign …

The SQL is complex, with set operator EXCEPT :

SELECT * FROM "DOCPLANGESTION" WHERE "FKARCHIVE" = 101 AND (("TYPECATEGORIE" IS NULL) OR "TYPECATEGORIE" IN (SELECT "TYPECATEGORIE" FROM "DOCPLANGESTION" WHERE "FKARCHIVE" = 101 EXCEPT SELECT "AUTORITE" AS "TYPECATEGORIE" FROM "IDXLESAUTORITES", "IDXLESCATEGORIES", "AUTLESARCHIVES" WHERE "FKCATEGORIE" = "IDCATEGORIE" AND "FKLISTE" = "FKLISTEAUTORITES" AND "IDARCHIVE" = 101))

So I’m wondering myself is the problem java version problem ? Or operating system because it’s working with same hsqldb driver version on Linux ? May be also a problem with SQL reading before to execute/assign ?

Note I tried to use last hsqldb driver version 2.6.1 but I’ve got a java class version error saying that I’m using a old java version that can read only java class version 52 but not java class version 55 … What I can’t understand is that I downloaded last java version 8 and this message is talking about a java version 11 to use … But oracle say that java verison 11 is older that java version 8 … What about this order java version ? Is it because Oracle by Sun java that java version order will be break ???

Thank you for your help !

[RobertG]

There are different versions of Java available.
Oracle Java 8 will be the last version, which you could download and install as JRE. For newer version of Oracle Java you will need JDK instead of JRE.
OpenJDK is available in version 18, see OpenJDK.

One hint when reading “subform”: Open the database file → Edit → Database → Advanced Settings. If there is a tab “Special settings” and → "Replace named parameters with ‘?’: choose this option. Will solve many problems with connection from forms to subforms.

[gelinp]

Nothing changed with “Replace named parameters with ‘?’” option activated… unoform.command doesn’t assign, and same with Access2Base, oA2BForm.RecordSource doesn’t assign …

I’m trying to downlad and use JDK (minimum 11) with hsqldb 2.6.1 driver…

[gelinp]

I finded that the problem is when analysing the SQL request by subform before to execute it. So I erased this option into subform and it succeded to synchronize. The problem is that request get a very long time (about 6 secondes) to execute …