Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » drop schema lars; results in syntax error
drop schema lars; results in syntax error [message #34890] Sun, 19 August 2007 22:45 Go to next message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

Hello,

I have in Derby 10.2.2.0 a schema called "lars". This was created via the
SQL Editor and the following statement:

create schema lars;

I'm not able to delete this schema. If I type the following into the SQL
Editor:

drop schema lars;

The SQL Editor returns with an error message:

Syntax error: Encountered "<EOF>" at line 2, column 18.

Can you please check? I assume this is a bug and will open a bug report for
this if noone know a solution for this.

Best regards, Lars
Re: drop schema lars; results in syntax error [message #34944 is a reply to message #34890] Mon, 20 August 2007 02:31 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Hi Lars,
The error comes from Derby server and this is not a bug. You should use:
drop schema lars RESTRICT;
instead.
Here's the exerpt from the Derby manual:
The RESTRICT keyword enforces the rule that no objects can be defined in the
specified
schema for the schema to be deleted from the database. The RESTRICT keyword
is
required

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD


"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:faah63$s73$1@build.eclipse.org...
> Hello,
>
> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
> SQL Editor and the following statement:
>
> create schema lars;
>
> I'm not able to delete this schema. If I type the following into the SQL
> Editor:
>
> drop schema lars;
>
> The SQL Editor returns with an error message:
>
> Syntax error: Encountered "<EOF>" at line 2, column 18.
>
> Can you please check? I assume this is a bug and will open a bug report
> for this if noone know a solution for this.
>
> Best regards, Lars
>
Re: drop schema lars; results in syntax error [message #35080 is a reply to message #34944] Mon, 20 August 2007 18:32 Go to previous message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

Hi Hui,

thank you.

Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:faaue1$io$1@build.eclipse.org...
> Hi Lars,
> The error comes from Derby server and this is not a bug. You should
> use:
> drop schema lars RESTRICT;
> instead.
> Here's the exerpt from the Derby manual:
> The RESTRICT keyword enforces the rule that no objects can be defined in
> the specified
> schema for the schema to be deleted from the database. The RESTRICT
> keyword is
> required
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:faah63$s73$1@build.eclipse.org...
>> Hello,
>>
>> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
>> SQL Editor and the following statement:
>>
>> create schema lars;
>>
>> I'm not able to delete this schema. If I type the following into the SQL
>> Editor:
>>
>> drop schema lars;
>>
>> The SQL Editor returns with an error message:
>>
>> Syntax error: Encountered "<EOF>" at line 2, column 18.
>>
>> Can you please check? I assume this is a bug and will open a bug report
>> for this if noone know a solution for this.
>>
>> Best regards, Lars
>>
>
>
Re: drop schema lars; results in syntax error [message #587409 is a reply to message #34890] Mon, 20 August 2007 02:31 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi Lars,
The error comes from Derby server and this is not a bug. You should use:
drop schema lars RESTRICT;
instead.
Here's the exerpt from the Derby manual:
The RESTRICT keyword enforces the rule that no objects can be defined in the
specified
schema for the schema to be deleted from the database. The RESTRICT keyword
is
required

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD


"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:faah63$s73$1@build.eclipse.org...
> Hello,
>
> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
> SQL Editor and the following statement:
>
> create schema lars;
>
> I'm not able to delete this schema. If I type the following into the SQL
> Editor:
>
> drop schema lars;
>
> The SQL Editor returns with an error message:
>
> Syntax error: Encountered "<EOF>" at line 2, column 18.
>
> Can you please check? I assume this is a bug and will open a bug report
> for this if noone know a solution for this.
>
> Best regards, Lars
>
Re: drop schema lars; results in syntax error [message #587468 is a reply to message #34944] Mon, 20 August 2007 18:32 Go to previous message
Lars Vogel is currently offline Lars VogelFriend
Messages: 1049
Registered: July 2009
Senior Member

Hi Hui,

thank you.

Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:faaue1$io$1@build.eclipse.org...
> Hi Lars,
> The error comes from Derby server and this is not a bug. You should
> use:
> drop schema lars RESTRICT;
> instead.
> Here's the exerpt from the Derby manual:
> The RESTRICT keyword enforces the rule that no objects can be defined in
> the specified
> schema for the schema to be deleted from the database. The RESTRICT
> keyword is
> required
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:faah63$s73$1@build.eclipse.org...
>> Hello,
>>
>> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
>> SQL Editor and the following statement:
>>
>> create schema lars;
>>
>> I'm not able to delete this schema. If I type the following into the SQL
>> Editor:
>>
>> drop schema lars;
>>
>> The SQL Editor returns with an error message:
>>
>> Syntax error: Encountered "<EOF>" at line 2, column 18.
>>
>> Can you please check? I assume this is a bug and will open a bug report
>> for this if noone know a solution for this.
>>
>> Best regards, Lars
>>
>
>
Previous Topic:Getting all jdbc connection info in a reliable way ?
Next Topic:new error from DTP 1.5 with Eclipse 3.3.0 accessing stored procedures from SQL Server 2000 db
Goto Forum:
  


Current Time: Sun Dec 21 07:08:53 GMT 2014

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

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