Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forums"on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/37624/#msg_37624
if I run the following SQL statement I receive in the SQL Result view the
message:Syntax error: Encountered ";" at line 183, column 2.
I used to use this statement to create the database in Derby. Can you tell
me what is wrong with the statement?
Best regards, Lars
create table sixsigma.rel_req_user(
req_id int not null,
user_id int not null,
primary key (req_id,user_id),
foreign key(req_id) references sixsigma.requirement(req_id) on delete
cascade,
foreign key(user_id) references sixsigma.users(id) on delete cascade
);]]>Lars Vogel2007-10-26T16:39:09-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/588299/#msg_588299
"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:fft57f$7fd$1@build.eclipse.org...
> Hi,
>
> if I run the following SQL statement I receive in the SQL Result view the
> message:Syntax error: Encountered ";" at line 183, column 2.
>
> I used to use this statement to create the database in Derby. Can you tell
> me what is wrong with the statement?
>
> Best regards, Lars
> create table sixsigma.rel_req_user(
>
> req_id int not null,
>
> user_id int not null,
>
> primary key (req_id,user_id),
>
> foreign key(req_id) references sixsigma.requirement(req_id) on delete
> cascade,
>
> foreign key(user_id) references sixsigma.users(id) on delete cascade
>
> );
>
>
>]]>Lars Vogel2007-10-26T16:44:14-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/37644/#msg_37644
"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:fft57f$7fd$1@build.eclipse.org...
> Hi,
>
> if I run the following SQL statement I receive in the SQL Result view the
> message:Syntax error: Encountered ";" at line 183, column 2.
>
> I used to use this statement to create the database in Derby. Can you tell
> me what is wrong with the statement?
>
> Best regards, Lars
> create table sixsigma.rel_req_user(
>
> req_id int not null,
>
> user_id int not null,
>
> primary key (req_id,user_id),
>
> foreign key(req_id) references sixsigma.requirement(req_id) on delete
> cascade,
>
> foreign key(user_id) references sixsigma.users(id) on delete cascade
>
> );
>
>
>]]>Lars Vogel2007-10-26T16:44:14-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/588309/#msg_588309
There's nothing wrong with your statement. This is a bug which has been
logged in https://bugs.eclipse.org/bugs/show_bug.cgi?id=198719
--
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:fft5h0$aa1$1@build.eclipse.org...
>I might add that I'm using Eclipse 3.3 with the latest dtp
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:fft57f$7fd$1@build.eclipse.org...
>> Hi,
>>
>> if I run the following SQL statement I receive in the SQL Result view the
>> message:Syntax error: Encountered ";" at line 183, column 2.
>>
>> I used to use this statement to create the database in Derby. Can you
>> tell me what is wrong with the statement?
>>
>> Best regards, Lars
>> create table sixsigma.rel_req_user(
>>
>> req_id int not null,
>>
>> user_id int not null,
>>
>> primary key (req_id,user_id),
>>
>> foreign key(req_id) references sixsigma.requirement(req_id) on delete
>> cascade,
>>
>> foreign key(user_id) references sixsigma.users(id) on delete cascade
>>
>> );
>>
>>
>>
>
>]]>Hui Cao2007-10-29T01:19:08-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/37661/#msg_37661
Originally posted by: hui.cao.sybase.ocm
"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:fft5h0$aa1$1@build.eclipse.org...
>I might add that I'm using Eclipse 3.3 with the latest dtp
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:fft57f$7fd$1@build.eclipse.org...
>> Hi,
>>
>> if I run the following SQL statement I receive in the SQL Result view the
>> message:Syntax error: Encountered ";" at line 183, column 2.
>>
>> I used to use this statement to create the database in Derby. Can you
>> tell me what is wrong with the statement?
>>
>> Best regards, Lars
>> create table sixsigma.rel_req_user(
>>
>> req_id int not null,
>>
>> user_id int not null,
>>
>> primary key (req_id,user_id),
>>
>> foreign key(req_id) references sixsigma.requirement(req_id) on delete
>> cascade,
>>
>> foreign key(user_id) references sixsigma.users(id) on delete cascade
>>
>> );
>>
>>
>>
>
>]]>2007-10-29T01:19:08-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/588338/#msg_588338
thank you. If I read the bug target correct it will be part of 1.5.2. Is it
already know then 1.5.2 is planned to be released? On http://www.eclipse.org/datatools/ I did not find this information.
Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:fg3ced$mhp$1@build.eclipse.org...
> Hi Lars,
> There's nothing wrong with your statement. This is a bug which has been
> logged in https://bugs.eclipse.org/bugs/show_bug.cgi?id=198719
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:fft5h0$aa1$1@build.eclipse.org...
>>I might add that I'm using Eclipse 3.3 with the latest dtp
>>
>> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
>> news:fft57f$7fd$1@build.eclipse.org...
>>> Hi,
>>>
>>> if I run the following SQL statement I receive in the SQL Result view
>>> the message:Syntax error: Encountered ";" at line 183, column 2.
>>>
>>> I used to use this statement to create the database in Derby. Can you
>>> tell me what is wrong with the statement?
>>>
>>> Best regards, Lars
>>> create table sixsigma.rel_req_user(
>>>
>>> req_id int not null,
>>>
>>> user_id int not null,
>>>
>>> primary key (req_id,user_id),
>>>
>>> foreign key(req_id) references sixsigma.requirement(req_id) on delete
>>> cascade,
>>>
>>> foreign key(user_id) references sixsigma.users(id) on delete cascade
>>>
>>> );
>>>
>>>
>>>
>>
>>
>
>]]>Lars Vogel2007-10-29T20:39:29-00:00Re: "on delete cascade" results in syntax error (Derby)
https://www.eclipse.org/forums/index.php/mv/msg/12076/37773/#msg_37773
thank you. If I read the bug target correct it will be part of 1.5.2. Is it
already know then 1.5.2 is planned to be released? On http://www.eclipse.org/datatools/ I did not find this information.
Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:fg3ced$mhp$1@build.eclipse.org...
> Hi Lars,
> There's nothing wrong with your statement. This is a bug which has been
> logged in https://bugs.eclipse.org/bugs/show_bug.cgi?id=198719.
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:fft5h0$aa1$1@build.eclipse.org...
>>I might add that I'm using Eclipse 3.3 with the latest dtp
>>
>> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
>> news:fft57f$7fd$1@build.eclipse.org...
>>> Hi,
>>>
>>> if I run the following SQL statement I receive in the SQL Result view
>>> the message:Syntax error: Encountered ";" at line 183, column 2.
>>>
>>> I used to use this statement to create the database in Derby. Can you
>>> tell me what is wrong with the statement?
>>>
>>> Best regards, Lars
>>> create table sixsigma.rel_req_user(
>>>
>>> req_id int not null,
>>>
>>> user_id int not null,
>>>
>>> primary key (req_id,user_id),
>>>
>>> foreign key(req_id) references sixsigma.requirement(req_id) on delete
>>> cascade,
>>>
>>> foreign key(user_id) references sixsigma.users(id) on delete cascade
>>>
>>> );
>>>
>>>
>>>
>>
>>
>
>]]>Lars Vogel2007-10-29T20:39:29-00:00