Automatic table creation fails on HSQLDB
----------------------------------------
Key: ROL-1855
URL: https://issues.apache.org/jira/browse/ROL-1855
Project: Roller
Issue Type: Bug
Components: Database Access & Data Model
Affects Versions: 5.0
Environment: Ubuntu 8.04 LTS, Sun JDK 1.6, Tomcat 6.0.20, HSQLDB 2.0
RC8
Reporter: Juergen Kellerer
Assignee: Roller Unassigned
Priority: Minor
When Tomcat and Roller is set up with HSQLDB, I get a complaint when Roller
tries to create its tables.
The exact message is "Unexpected token 'DEFAULT'" and comes up during the
execution of the create table script for the table "webpage".
The bug is caused by a mistake in the keyword order and can be fixed by
replacing:
action varchar(16) not null default 'custom'
with:
action varchar(16) default 'custom' not null
After this change all tables are created just fine.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
