Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 Go to next message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

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 Go to previous message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

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 Go to previous message
Hui Cao is currently offline Hui CaoFriend
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 Go to previous message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

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
>>>
>>> );
>>>
>>>
>>>
>>
>>
>
>
Previous Topic:"on delete cascade" results in syntax error (Derby)
Next Topic:Line number
Goto Forum:
  


Current Time: Sat Nov 29 06:44:09 GMT 2014

Powered by FUDForum. Page generated in 0.07816 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software