Since my DB.data file continued to grow I discovered
"SHUTDOWN ABORT". Result (embedded DB driver):
--- snip (console output of my program) ----
SQL-DB update with command SHUTDOWN COMPACT
Couldn't shutdown DB.
java.sql.SQLException: error in script file line: 40
Header not allowed or too long in statement [SET TABLE
"Ships4History" SOURCE HEADER "shipclassnumber
"] in statement [SHUTDOWN COMPACT]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown
Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown
Source)
at
de.retsiemuab.witpDecoder.HsqlDB.update(HsqlDB.java:119)
at
de.retsiemuab.witpDecoder.gui.MainGuiAdaptor.shutdownDB(MainGuiAdaptor.java
:127)
.....
---- snip ----
The lines of the respective table in the script file
looks as follows:
----- snip ----
CREATE TEXT TABLE "Ships4History"("shiptypeID" TINYINT
DEFAULT 0 NOT NULL,CONSTRAINT SYS_FK_3243 FOREIGN
KEY("shiptypeID") REFERENCES "ShipTypes"("shiptypeID"))
SET TABLE "Ships4History" READONLY TRUE
SET TABLE "Ships4History" SOURCE
"ships4history.csv;ignore_first=true"
SET TABLE "Ships4History" SOURCE HEADER
"shipclassnumber\u000a"
---- snip ----
The last line is line 40.
(note that the table has only one column)
In the csv file there is no such character:
---- snip ----
% od -xc ships4history.csv
0000000 6873 7069 6c63 7361 6e73 6d75 6562 0a72
s h i p c l a s s n u m
b e r \n
0000020 0a31 0a32 0a33 0a34 0a35 0a36 0a37 0a38
1 \n 2 \n 3 \n 4 \n 5 \n 6 \n
7 \n 8 \n
0000040 0a39 3031 310a 0a31 3231 310a 0a36 3931
9 \n 1 0 \n 1 1 \n 1 2 \n 1
6 \n 1 9
0000060 340a 0a31 3234 340a 0a33 3534 340a 0a37
\n 4 1 \n 4 2 \n 4 3 \n 4 5
\n 4 7 \n
0000100
---- snip ---
Maybe HSQLDB has a problem with TEXT tables with only
one column?
Nobody/Anonymous
engine
current-release
Public
|
Date: 2009-09-16 01:40 In 1.8.x, The issue is |
|
Date: 2006-11-12 12:54 Logged In: YES |
|
Date: 2006-11-11 21:57 Logged In: YES |
| Field | Old Value | Date | By |
|---|---|---|---|
| status_id | Open | 2009-09-16 01:40 | fredt |
| resolution_id | None | 2009-09-16 01:40 | fredt |
| priority | 5 | 2009-09-16 01:40 | fredt |
| allow_comments | 1 | 2009-09-16 01:40 | fredt |
| close_date | - | 2009-09-16 01:40 | fredt |
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use