This functionality is only available for certain module packages.

You are here: EEC > BASE > Data sources > Data source objects > DatabaseDataSource > hsqldb

hsqldb

User name and password must always be provided in uppercase letters so as to allow for access from the EEC.

Table and column names are always converted to uppercase letters for SQL requests. If this is not desired, they will have to be placed in quotes (“).

Examples:

‘select PartNumber from Parts’ does not function: Error message: Table 'PARTS' does not exist.

‘select PartNumber from “Parts”’ does not function: Error message: Column 'PARTNUMBER' does not exist.

‘select “PartNumber” from “Parts”’ works.

‘select SupplierNumber from Suppliers’ works.

‘select SUPPLIERNUMBER from SUPPLIERS’ works.

The column names in the query results are case-sensitive, i.e., they must be precisely as stated in the database:

...perform('select "Artikelnummer" from "Artikel"').collect(x|x.Artikelnummer)
...perform('select Lieferantennummer from Lieferanten').collect(x|x.LIEFERANTENNUMMER)

Note:

OpenOffice Base behaves exactly like hsqldb in the case of SQL requests.