[luciddb-users] SQLArchitect with LucidDB

[rails.info i. <rai...@gm...>]

Hello everyone,

I've been trying to use SQL Power Architect with LucidDB. Everything works
nicely except for the DDL generation. When I follow the steps decribed
here: http://pub.eigenbase.org/wiki/LucidDbPowerArchitect

and try to generate the DDL I get the following exception:

*2571742 [Thread-79] INFO  ca.sqlpower.architect.swingui.SQLScriptDialog  -
executing: *
*
*
*
*
*CREATE TABLE dim_time (*
*                time_key INTEGER NOT NULL,*
*                time TIME NOT NULL,*
*                hours24 SMALLINT NOT NULL,*
*                hours12 SMALLINT NOT NULL,*
*                minutes SMALLINT NOT NULL,*
*                seconds SMALLINT NOT NULL,*
*                am_pm CHAR(3) NOT NULL,*
*                CONSTRAINT dim_time_key PRIMARY KEY (time_key)*
*)*
*2571758 [Thread-79] INFO  ca.sqlpower.architect.swingui.SQLScriptDialog  -
sql statement failed: org.eigenbase.sql.parser.SqlParseException:
Encountered "time" at line 6, column 17.*
*Was expecting one of:*
*    "CONSTRAINT" ...*
*    "PRIMARY" ...*
*    "UNIQUE" ...*
*    <IDENTIFIER> ...*
*    <QUOTED_IDENTIFIER> ...*
*    <UNICODE_QUOTED_IDENTIFIER> ...*
*
*
*
*
*
*
Am I doing something wrong here, or is this a bug ?


Regards,
Bryan