[ openjms-Bugs-705363 ] create_hsql.sql

Bugs item #705363, was opened at 2003-03-18 02:28
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=705363&group_id=54559

Category: documentation
Group: v0.7.4
>Status: Closed
Resolution: Fixed
Priority: 5
Submitted By: Nebiyu Yohannes (daillest)
Assigned to: Jim Alateras (jalateras)
Summary: create_hsql.sql 

Initial Comment:
In openjms 0.7.4 distribution , in the file

create_hsql.sql the following sql statement is incorrect:

create table destinations (
  name                   varchar(255) not null,
  isQueue                numeric(3) not null,
  destinationId          numeric(28) not null
);

-- isQueue is the wrong datatype for hsqldb
The correct version is  :

create table destinations (
  name                   varchar(255) not null,
  isQueue                bit not null,
  destinationId          numeric(28) not null
);

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2003-03-19 13:06

Message:
Logged In: YES 
user_id=557161

Fixed in CVS. Will be available in the 0.7.5 release.
Check it out to verify that it works.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=705363&group_id=54559