Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Porting database to 5.3

I am using Ubuntu 14.04 and a 4.2.8.2 embedded hsqldb database. I want to port over to LO 5.3. I have tried on both Linux 16.04 and win7 with 5.3 loaded and I get the same error on both:

-SQL Status: S1000 Error code: -40 General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:

Java is up to date and loaded and checked in options.

when selecting the table. Is there a fix or way to do this?

Porting database to 5.3

I am using Ubuntu 14.04 and a 4.2.8.2 embedded hsqldb database. I want to port over to LO 5.3. I have tried on both Linux 16.04 and win7 with 5.3 loaded and I get the same error on both:

-SQL Status: S1000 Error code: -40 General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:

Java is up to date and loaded and checked in options.

when selecting the table. Is there a fix or way to do this?

Here is the script file in question from the last comment -

SET DATABASE COLLATION "Latin1_General" CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE "chs68"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"FirstName" VARCHAR(255),"LastName" VARCHAR(255),"SpouseName" VARCHAR(255),"Address" VARCHAR(255),"City" VARCHAR(255),"State" VARCHAR(255),"PostalCode" VARCHAR(255),"HomePhone" VARCHAR(255),"WorkPhone" VARCHAR(255),"CellPhone" VARCHAR(255),"EmailAddress" VARCHAR(255),"NumberAttending" VARCHAR(255),"GuestsID" VARCHAR(255),"Address2" VARCHAR(255),"NewLastname" VARCHAR(255),"SendMail" VARCHAR(255),"PlanAttend2008" VARCHAR(255),"MyElementary" VARCHAR(255),"MyJunior" VARCHAR(255),"class photo" VARCHAR(100),"PersonalComment" VARCHAR(255),"Deceased" BOOLEAN,"Contact2008" BOOLEAN,"Contact2018" BOOLEAN,"EmailOK" BOOLEAN,"Comments" VARCHAR(255),"Committee" BOOLEAN,"NeverFound" BOOLEAN,"EmailNotConfirmed" BOOLEAN,"PlanAttend2018" BOOLEAN) SET TABLE "chs68" INDEX'59664 544' ALTER TABLE "chs68" ALTER COLUMN "ID" RESTART WITH 544 CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 60

Porting database to 5.3

I am using Ubuntu 14.04 and a 4.2.8.2 embedded hsqldb database. I want to port over to LO 5.3. I have tried on both Linux 16.04 and win7 with 5.3 loaded and I get the same error on both:

-SQL Status: S1000 Error code: -40 General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:

Java is up to date and loaded and checked in options.

when selecting the table. Is there a fix or way to do this?

Here is the script file in question from the last comment -

SET DATABASE COLLATION "Latin1_General" CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE "chs68"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"FirstName" VARCHAR(255),"LastName" VARCHAR(255),"SpouseName" VARCHAR(255),"Address" VARCHAR(255),"City" VARCHAR(255),"State" VARCHAR(255),"PostalCode" VARCHAR(255),"HomePhone" VARCHAR(255),"WorkPhone" VARCHAR(255),"CellPhone" VARCHAR(255),"EmailAddress" VARCHAR(255),"NumberAttending" VARCHAR(255),"GuestsID" VARCHAR(255),"Address2" VARCHAR(255),"NewLastname" VARCHAR(255),"SendMail" VARCHAR(255),"PlanAttend2008" VARCHAR(255),"MyElementary" VARCHAR(255),"MyJunior" VARCHAR(255),"class photo" VARCHAR(100),"PersonalComment" VARCHAR(255),"Deceased" BOOLEAN,"Contact2008" BOOLEAN,"Contact2018" BOOLEAN,"EmailOK" BOOLEAN,"Comments" VARCHAR(255),"Committee" BOOLEAN,"NeverFound" BOOLEAN,"EmailNotConfirmed" BOOLEAN,"PlanAttend2018" BOOLEAN) SET TABLE "chs68" INDEX'59664 544' ALTER TABLE "chs68" ALTER COLUMN "ID" RESTART WITH 544 CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 60

and here is the script once the new DB was working under split wizzard -

SET DATABASE UNIQUE NAME HSQLDB5CBE196A76 SET DATABASE GC 0 SET DATABASE DEFAULT RESULT MEMORY ROWS 0 SET DATABASE EVENT LOG LEVEL 0 SET DATABASE TRANSACTION CONTROL LOCKS SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE SET DATABASE TEXT TABLE DEFAULTS '' SET DATABASE DEFAULT TABLE TYPE CACHED SET DATABASE SQL NAMES FALSE SET DATABASE SQL REFERENCES FALSE SET DATABASE SQL SIZE TRUE SET DATABASE SQL TYPES FALSE SET DATABASE SQL TDC DELETE TRUE SET DATABASE SQL TDC UPDATE TRUE SET DATABASE SQL TRANSLATE TTI TYPES TRUE SET DATABASE SQL CONCAT NULLS TRUE SET DATABASE SQL UNIQUE NULLS TRUE SET DATABASE SQL CONVERT TRUNCATE TRUE SET DATABASE SQL AVG SCALE 0 SET DATABASE SQL DOUBLE NAN TRUE SET FILES WRITE DELAY 500 MILLIS SET FILES BACKUP INCREMENT TRUE SET FILES CACHE SIZE 10000 SET FILES CACHE ROWS 50000 SET FILES SCALE 32 SET FILES LOB SCALE 32 SET FILES DEFRAG 0 SET FILES NIO TRUE SET FILES NIO SIZE 256 SET FILES LOG TRUE SET FILES LOG SIZE 50 CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' ALTER USER SA SET LOCAL TRUE CREATE SCHEMA PUBLIC AUTHORIZATION DBA ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC GRANT DBA TO SA

Porting database to 5.3

I am using Ubuntu 14.04 and a 4.2.8.2 embedded hsqldb database. I want to port over to LO 5.3. I have tried on both Linux 16.04 and win7 with 5.3 loaded and I get the same error on both:

-SQL Status: S1000 Error code: -40 General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:

Java is up to date and loaded and checked in options.

when selecting the table. Is there a fix or way to do this?

Here is the script file in question from the last comment -

SET DATABASE COLLATION "Latin1_General" "Latin1_General"

CREATE SCHEMA PUBLIC AUTHORIZATION DBA DBA

CREATE CACHED TABLE "chs68"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"FirstName" VARCHAR(255),"LastName" VARCHAR(255),"SpouseName" VARCHAR(255),"Address" VARCHAR(255),"City" VARCHAR(255),"State" VARCHAR(255),"PostalCode" VARCHAR(255),"HomePhone" VARCHAR(255),"WorkPhone" VARCHAR(255),"CellPhone" VARCHAR(255),"EmailAddress" VARCHAR(255),"NumberAttending" VARCHAR(255),"GuestsID" VARCHAR(255),"Address2" VARCHAR(255),"NewLastname" VARCHAR(255),"SendMail" VARCHAR(255),"PlanAttend2008" VARCHAR(255),"MyElementary" VARCHAR(255),"MyJunior" VARCHAR(255),"class photo" VARCHAR(100),"PersonalComment" VARCHAR(255),"Deceased" BOOLEAN,"Contact2008" BOOLEAN,"Contact2018" BOOLEAN,"EmailOK" BOOLEAN,"Comments" VARCHAR(255),"Committee" BOOLEAN,"NeverFound" BOOLEAN,"EmailNotConfirmed" BOOLEAN,"PlanAttend2018" BOOLEAN) BOOLEAN)

SET TABLE "chs68" INDEX'59664 544' 544'

ALTER TABLE "chs68" ALTER COLUMN "ID" RESTART WITH 544 544

CREATE USER SA PASSWORD "" ""

GRANT DBA TO SA SA

SET WRITE_DELAY 60

and here is the script once the new DB was working under split wizzard -

SET DATABASE UNIQUE NAME HSQLDB5CBE196A76 HSQLDB5CBE196A76

SET DATABASE GC 0 0

SET DATABASE DEFAULT RESULT MEMORY ROWS 0 0

SET DATABASE EVENT LOG LEVEL 0 0

SET DATABASE TRANSACTION CONTROL LOCKS LOCKS

SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED COMMITTED

SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE TRUE

SET DATABASE TEXT TABLE DEFAULTS '' ''

SET DATABASE DEFAULT TABLE TYPE CACHED CACHED

SET DATABASE SQL NAMES FALSE FALSE

SET DATABASE SQL REFERENCES FALSE FALSE

SET DATABASE SQL SIZE TRUE TRUE

SET DATABASE SQL TYPES FALSE FALSE

SET DATABASE SQL TDC DELETE TRUE TRUE

SET DATABASE SQL TDC UPDATE TRUE TRUE

SET DATABASE SQL TRANSLATE TTI TYPES TRUE TRUE

SET DATABASE SQL CONCAT NULLS TRUE TRUE

SET DATABASE SQL UNIQUE NULLS TRUE TRUE

SET DATABASE SQL CONVERT TRUNCATE TRUE TRUE

SET DATABASE SQL AVG SCALE 0 0

SET DATABASE SQL DOUBLE NAN TRUE TRUE

SET FILES WRITE DELAY 500 MILLIS MILLIS

SET FILES BACKUP INCREMENT TRUE TRUE

SET FILES CACHE SIZE 10000 10000

SET FILES CACHE ROWS 50000 50000

SET FILES SCALE 32 32

SET FILES LOB SCALE 32 32

SET FILES DEFRAG 0 0

SET FILES NIO TRUE TRUE

SET FILES NIO SIZE 256 256

SET FILES LOG TRUE TRUE

SET FILES LOG SIZE 50 50

CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' 'd41d8cd98f00b204e9800998ecf8427e'

ALTER USER SA SET LOCAL TRUE TRUE

CREATE SCHEMA PUBLIC AUTHORIZATION DBA DBA

ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 1

SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC PUBLIC

GRANT DBA TO SA