Feature Requests item #489540, was opened at 2001-12-05 13:00
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376688&aid=489540&group_id=22866

Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Priority: 5
Submitted By: Frank Langelage (lafr)
Assigned to: Nobody/Anonymous (nobody)
Summary: full support of informix DB

Initial Comment:
create table with primary key and alter table add 
foreign key are working for informix DB.
The syntax for this statements must be slightly
different, e.g.:

create table address 
  (
    id integer,
    name1 varchar(30),
    name2 varchar(30),
    city varchar(30),
    street varchar(30),
    country_id smallint,
    primary key (id)  constraint pkaddress
  );
alter table address add constraint foreign key
(country_id) references country constraint fkcountry;

The part "constraint <name>" must be the last part of
the statement.


I think best solution will be a template for this like
row-locking-template.

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

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376688&aid=489540&group_id=22866

_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to