roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Johnson (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (ROL-1855) Automatic table creation fails on HSQLDB
Date Sat, 27 Feb 2010 03:08:05 GMT

     [ https://issues.apache.org/jira/browse/ROL-1855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dave Johnson resolved ROL-1855.
-------------------------------

    Resolution: Fixed

Author: snoopdave
Date: Sat Feb 27 03:00:43 2010
New Revision: 916898

URL: http://svn.apache.org/viewvc?rev=916898&view=rev
Log:
Fixes Automatic table creation fails on HSQLDB
https://issues.apache.org/jira/browse/ROL-1855

> 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: Dave Johnson
>            Priority: Minor
>             Fix For: 5.0
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> 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.


Mime
View raw message