Home » Eclipse Projects » DTP » "on delete cascade" results in syntax error (Derby)
"on delete cascade" results in syntax error (Derby) [message #37624] |
Fri, 26 October 2007 16:39 |
|
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
);
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #37644 is a reply to message #37624] |
Fri, 26 October 2007 16:44 |
|
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
>
> );
>
>
>
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #37661 is a reply to message #37644] |
Mon, 29 October 2007 01:19 |
Eclipse User |
|
|
|
Originally posted by: hui.cao.sybase.ocm
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
>>
>> );
>>
>>
>>
>
>
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #37773 is a reply to message #37661] |
Mon, 29 October 2007 20:39 |
|
Hi Hui,
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
>>>
>>> );
>>>
>>>
>>>
>>
>>
>
>
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #588299 is a reply to message #37624] |
Fri, 26 October 2007 16:44 |
|
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
>
> );
>
>
>
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #588309 is a reply to message #37644] |
Mon, 29 October 2007 01:19 |
Hui Cao Messages: 29 Registered: July 2009 |
Junior Member |
|
|
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
>>
>> );
>>
>>
>>
>
>
|
|
|
Re: "on delete cascade" results in syntax error (Derby) [message #588338 is a reply to message #37661] |
Mon, 29 October 2007 20:39 |
|
Hi Hui,
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
>>>
>>> );
>>>
>>>
>>>
>>
>>
>
>
|
|
|
Goto Forum:
Current Time: Fri Mar 29 06:07:53 GMT 2024
Powered by FUDForum. Page generated in 0.02532 seconds
|