Thanks so much for your help.
I managed to find my 'public' file with the help of our IT technician. Our school system is weird and whilst C drive exists, it's not labelled as such - which was part of the problem.
My initial database file was very small (around 1kb) which might mean it was corrupted. Luckily, an uncorrupted copy had been backed up on the school's server and I now have a copy of this.
I made a second backup in a separate folder (in case) and followed your steps.
Now the error says:
---
Code: Select all
The connection to the data source "2013 GTT Learners.file" could not be established.
error in script file line: 39 file input/output errorerrororg.hsqldb.HsqlException:java.io.IOExpception: There is not enough space on the disk opening file - file /users/public/databases/mydb/mydb.data
---
Interestingly, the 'new' data file has 0 kb (the 'backup' is 160kb).
So I think my data is still in-tact but I can't connect to it just yet...
I'm not sure whether I'm using CACHED or MEMORY tables (step 12). How would I tell? I'm assuming sharing MEMORY tables would be a breach of security??? I think it's CACHED because the only information is the table headings / links between tables - there is no obviously private data although you can probably get quite a good idea of the database's architecture.
Line 39 is the one that talks about restarting the numbering on my "students in courses" table. This table records which kid is in which class. At the start of the year there was a fair bit of movement whilst students figured out their course schedules. This means that I ended up deleting some kids from the database (had it set up so that when a kid was deleted, it cascaded). Offhand, I'm not sure how many kids I should have on the table but the 127 id seems quite high (before we thought it might be 109 based on the error message). Of course, there could well be an id of 127 or more but only 109 entries as some kids have been deleted.
Problem is, I have very little idea of what I'm doing
Here's the contents of the script file (which I'm afraid to edit!) ...
---
Code: Select all
SET DATABASE UNIQUE NAME HSQLDB3C5B0FE781
SET DATABASE GC 0
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
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 NULLS FIRST 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 DATABASE SQL LONGVAR IS LOB FALSE
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 FILES WRITE DELAY 500 MILLIS
SET FILES BACKUP INCREMENT TRUE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 8
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
SET SCHEMA PUBLIC
CREATE CACHED TABLE PUBLIC."Students_in_Courses"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Student_ID" VARCHAR(10),"Course_ID" VARCHAR(10))
ALTER TABLE PUBLIC."Students_in_Courses" ALTER COLUMN "ID" RESTART WITH 127
CREATE CACHED TABLE PUBLIC."Results"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Student_ID" VARCHAR(10),"Standard_ID" VARCHAR(10),"Grade_ID" VARCHAR(3),"Comment" VARCHAR(200))
ALTER TABLE PUBLIC."Results" ALTER COLUMN "ID" RESTART WITH 54
CREATE CACHED TABLE PUBLIC."Standards"("Standard_ID" VARCHAR(10) PRIMARY KEY,"Topic" VARCHAR(20),"Description" VARCHAR(150),"Version" VARCHAR(2),"Level" VARCHAR(1),"Credits" INTEGER,"Course_ID" VARCHAR(10),"External" BIT(1))
CREATE CACHED TABLE PUBLIC."Parent_Contact"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Student_ID" VARCHAR(10),"Date" DATE,"Contact_Person" VARCHAR(30),"Description" VARCHAR(200))
ALTER TABLE PUBLIC."Parent_Contact" ALTER COLUMN "ID" RESTART WITH 143
CREATE CACHED TABLE PUBLIC."Missing_Time"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Student_ID" VARCHAR(10),"Course_ID" VARCHAR(10),"Date" DATE,"Time" INTEGER,"Reason_ID" VARCHAR(30),"Description" VARCHAR(200))
ALTER TABLE PUBLIC."Missing_Time" ALTER COLUMN "ID" RESTART WITH 423
CREATE CACHED TABLE PUBLIC."Standards_in_Courses"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Standard_ID" VARCHAR(10),"Course_ID" VARCHAR(10),FOREIGN KEY("Standard_ID") REFERENCES PUBLIC."Standards"("Standard_ID") ON DELETE CASCADE)
ALTER TABLE PUBLIC."Standards_in_Courses" ALTER COLUMN "ID" RESTART WITH 22
CREATE CACHED TABLE PUBLIC."Grades"("Grade_ID" VARCHAR(6) PRIMARY KEY,"Description" VARCHAR(25))
CREATE CACHED TABLE PUBLIC."Courses"("Course_ID" VARCHAR(50) NOT NULL PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Excuse_List"("Reason_ID" VARCHAR(15) PRIMARY KEY,"Description" VARCHAR(50),"Category" VARCHAR(10))
CREATE CACHED TABLE PUBLIC."Students"("Student_ID" VARCHAR(6) PRIMARY KEY,"Last_Name" VARCHAR(20),"First_Name" VARCHAR(20))
ALTER TABLE PUBLIC."Students_in_Courses" ADD FOREIGN KEY("Course_ID") REFERENCES PUBLIC."Courses"("Course_ID")
ALTER TABLE PUBLIC."Students_in_Courses" ADD FOREIGN KEY("Student_ID") REFERENCES PUBLIC."Students"("Student_ID") ON DELETE CASCADE
ALTER TABLE PUBLIC."Results" ADD FOREIGN KEY("Grade_ID") REFERENCES PUBLIC."Grades"("Grade_ID")
ALTER TABLE PUBLIC."Results" ADD FOREIGN KEY("Student_ID") REFERENCES PUBLIC."Students"("Student_ID") ON DELETE CASCADE
ALTER TABLE PUBLIC."Results" ADD FOREIGN KEY("Standard_ID") REFERENCES PUBLIC."Standards"("Standard_ID") ON DELETE CASCADE
ALTER TABLE PUBLIC."Parent_Contact" ADD FOREIGN KEY("Student_ID") REFERENCES PUBLIC."Students"("Student_ID") ON DELETE CASCADE
ALTER TABLE PUBLIC."Missing_Time" ADD FOREIGN KEY("Reason_ID") REFERENCES PUBLIC."Excuse_List"("Reason_ID")
ALTER TABLE PUBLIC."Missing_Time" ADD FOREIGN KEY("Student_ID") REFERENCES PUBLIC."Students"("Student_ID") ON DELETE CASCADE
ALTER TABLE PUBLIC."Standards_in_Courses" ADD FOREIGN KEY("Course_ID") REFERENCES PUBLIC."Courses"("Course_ID")
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
SET TABLE PUBLIC."Students_in_Courses" INDEX '9997 9645 9502 0 0 0 109'
SET TABLE PUBLIC."Results" INDEX '20355 17435 16940 20491 0 0 0 0 53'
SET TABLE PUBLIC."Standards" INDEX '5346 0 21'
SET TABLE PUBLIC."Parent_Contact" INDEX '16055 11299 0 0 130'
SET TABLE PUBLIC."Missing_Time" INDEX '18300 10732 12224 0 0 0 400'
SET TABLE PUBLIC."Standards_in_Courses" INDEX '10467 10407 10557 0 0 0 21'
SET TABLE PUBLIC."Grades" INDEX '5775 0 7'
SET TABLE PUBLIC."Courses" INDEX '5814 0 6'
SET TABLE PUBLIC."Excuse_List" INDEX '5906 0 12'
SET TABLE PUBLIC."Students" INDEX '6196 0 97'
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 USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
---
Thanks in advance for your suggestions!