[ openjms-Bugs-705363 ] create_hsql.sql

Bugs item #705363, was opened at 2003-03-17 18: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: Open
Resolution: None
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
);

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

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