Import script problems

users
#1

I use LibreOffice to connect to HSQLDB 2.6.1 on UBUNTU 20.04. The problem is with this SQL statement:

PERFORM IMPORT SCRIPT DATA FROM <single-quoted file path> { CONTINUE | STOP | CHECK } ON ERROR

The following is one of the properties of my database:

jdbc:hsqldb:file:/media/dan/Storage/.database/2020personal/2020personal;

The file that I want to import is Main-subform.cvs.

I have place this file in the folder containing the 4 database files (data,log, properties, script). Then in Tools > SQL, I entered this statement:

PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR; CHECKPOINT;     and then

PERFORM IMPORT SCRIPT DATA FROM './Main-subform.cvs' STOP ON ERROR; CHECKPOINT;     and then

PERFORM IMPORT SCRIPT DATA FROM '../Main-subform.cvs' STOP ON ERROR; CHECKPOINT;

None of them worked. So, where should the cvs file be placed or what should the path be for this file?

Dan

#2

Hi Dan,

PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR; CHECKPOINT;

This seems to be the right path:
"You can specify the ACL file path with an absolute or relative
path. If you use a relative path, it must be relative to the .properties file." (p 310 of User Guide HSQLDB 2.6.1)

But:
"The file to be imported must be a file exported with the EXPORT SCRIPT statements listed above with DATA qualifier, or strictly in the same format." (p 245 User Guide)

Which error do you get?

Regards

Robert