Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL Editor Syntax Error
SQL Editor Syntax Error [message #35361] Thu, 23 August 2007 11:07 Go to next message
Massimo Montecchi is currently offline Massimo MontecchiFriend
Messages: 8
Registered: July 2009
Junior Member
Hi,
we work on Derby Network with DTP 1.5.1 (and previous).
With ij we create the database from DDL we use.
But when i want to use SQL Editor (with cinnection info) to Execute the
DDL we have this error Syntax error: Encountered ";".
Can someone help me?

PS I have tried enablind and disabling sysntax checking but i had the same
results

Thanks
Massimo Montecchi
BS Company Srl
Re: SQL Editor Syntax Error [message #35429 is a reply to message #35361] Fri, 24 August 2007 04:26 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Hi,
Can you try to terminate each SQL statement with a ";" in a new line
instead of just by appending ";" at the end of the statement? ( I suppose
this can be done by a batch replace: ";(\r\n)"->"$1;$1" in SQL editor )
Semicolon is not part of the Derby grammar and won't be accepted by the
server, and by default SQL editor only filters out statement
terminators(";") in a standalone line.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:62045b3fe7d206664d23260b44371062$1@www.eclipse.org...
> Hi,
> we work on Derby Network with DTP 1.5.1 (and previous).
> With ij we create the database from DDL we use.
> But when i want to use SQL Editor (with cinnection info) to Execute the
> DDL we have this error Syntax error: Encountered ";".
> Can someone help me?
>
> PS I have tried enablind and disabling sysntax checking but i had the same
> results
>
> Thanks
> Massimo Montecchi
> BS Company Srl
>
Re: SQL Editor Syntax Error [message #36108 is a reply to message #35429] Tue, 04 September 2007 15:04 Go to previous messageGo to next message
Massimo Montecchi is currently offline Massimo MontecchiFriend
Messages: 8
Registered: July 2009
Junior Member
Hi Max (Hui),
the hint you give to me it works!!!
But I think it's not so useful that SQL Editor check the end statement
only in a new line.
Think about using DTP for all the development fase: i mean, that we
develop the db DDL from the DTP plugin and when you estract the DDL from
DTP the file.sql you have is with ; at the end of every sql line!!!
Thanks

Massimo Montecchi
BS Company Srl
Re: SQL Editor Syntax Error [message #36141 is a reply to message #36108] Fri, 07 September 2007 04:43 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Hi Massimo,
I think your request does make sense. Can you open a bugzilla to track
this problem for Derby enablement? I'll find a time to look into it. Thanks!

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD


"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:5149a6a22050ffa751ccacdf468f360f$1@www.eclipse.org...
> Hi Max (Hui),
> the hint you give to me it works!!!
> But I think it's not so useful that SQL Editor check the end statement
> only in a new line.
> Think about using DTP for all the development fase: i mean, that we
> develop the db DDL from the DTP plugin and when you estract the DDL from
> DTP the file.sql you have is with ; at the end of every sql line!!!
> Thanks
>
> Massimo Montecchi
> BS Company Srl
>
Re: SQL Editor Syntax Error [message #36175 is a reply to message #36141] Fri, 07 September 2007 08:32 Go to previous messageGo to next message
Massimo Montecchi is currently offline Massimo MontecchiFriend
Messages: 8
Registered: July 2009
Junior Member
Hui Cao wrote:

> Hi Massimo,
> I think your request does make sense. Can you open a bugzilla to track
> this problem for Derby enablement? I'll find a time to look into it. Thanks!

Hi Max,
here is the bugs
https://bugs.eclipse.org/bugs/show_bug.cgi?id=202579
Hi hope is well write!!

Massimo Montecchi
BS Company Srl
Re: SQL Editor Syntax Error [message #37230 is a reply to message #36141] Sun, 14 October 2007 17:50 Go to previous message
Eclipse UserFriend
Originally posted by: bmf1972.fastmail.fm

Seems to be the same problem with MySQL.
Adrian.

Hui Cao wrote:
> Hi Massimo,
> I think your request does make sense. Can you open a bugzilla to track
> this problem for Derby enablement? I'll find a time to look into it. Thanks!
>
Re: SQL Editor Syntax Error [message #587600 is a reply to message #35361] Fri, 24 August 2007 04:26 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi,
Can you try to terminate each SQL statement with a ";" in a new line
instead of just by appending ";" at the end of the statement? ( I suppose
this can be done by a batch replace: ";(\r\n)"->"$1;$1" in SQL editor )
Semicolon is not part of the Derby grammar and won't be accepted by the
server, and by default SQL editor only filters out statement
terminators(";") in a standalone line.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:62045b3fe7d206664d23260b44371062$1@www.eclipse.org...
> Hi,
> we work on Derby Network with DTP 1.5.1 (and previous).
> With ij we create the database from DDL we use.
> But when i want to use SQL Editor (with cinnection info) to Execute the
> DDL we have this error Syntax error: Encountered ";".
> Can someone help me?
>
> PS I have tried enablind and disabling sysntax checking but i had the same
> results
>
> Thanks
> Massimo Montecchi
> BS Company Srl
>
Re: SQL Editor Syntax Error [message #587822 is a reply to message #35429] Tue, 04 September 2007 15:04 Go to previous message
Massimo Montecchi is currently offline Massimo MontecchiFriend
Messages: 8
Registered: July 2009
Junior Member
Hi Max (Hui),
the hint you give to me it works!!!
But I think it's not so useful that SQL Editor check the end statement
only in a new line.
Think about using DTP for all the development fase: i mean, that we
develop the db DDL from the DTP plugin and when you estract the DDL from
DTP the file.sql you have is with ; at the end of every sql line!!!
Thanks

Massimo Montecchi
BS Company Srl
Re: SQL Editor Syntax Error [message #587832 is a reply to message #36108] Fri, 07 September 2007 04:43 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi Massimo,
I think your request does make sense. Can you open a bugzilla to track
this problem for Derby enablement? I'll find a time to look into it. Thanks!

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD


"Massimo Montecchi" <massimo.montecchi@bs-company.com> wrote in message
news:5149a6a22050ffa751ccacdf468f360f$1@www.eclipse.org...
> Hi Max (Hui),
> the hint you give to me it works!!!
> But I think it's not so useful that SQL Editor check the end statement
> only in a new line.
> Think about using DTP for all the development fase: i mean, that we
> develop the db DDL from the DTP plugin and when you estract the DDL from
> DTP the file.sql you have is with ; at the end of every sql line!!!
> Thanks
>
> Massimo Montecchi
> BS Company Srl
>
Re: SQL Editor Syntax Error [message #587838 is a reply to message #36141] Fri, 07 September 2007 08:32 Go to previous message
Massimo Montecchi is currently offline Massimo MontecchiFriend
Messages: 8
Registered: July 2009
Junior Member
Hui Cao wrote:

> Hi Massimo,
> I think your request does make sense. Can you open a bugzilla to track
> this problem for Derby enablement? I'll find a time to look into it. Thanks!

Hi Max,
here is the bugs
https://bugs.eclipse.org/bugs/show_bug.cgi?id=202579
Hi hope is well write!!

Massimo Montecchi
BS Company Srl
Re: SQL Editor Syntax Error [message #588180 is a reply to message #36141] Sun, 14 October 2007 17:50 Go to previous message
Adrian Herscu is currently offline Adrian HerscuFriend
Messages: 33
Registered: July 2009
Member
Seems to be the same problem with MySQL.
Adrian.

Hui Cao wrote:
> Hi Massimo,
> I think your request does make sense. Can you open a bugzilla to track
> this problem for Derby enablement? I'll find a time to look into it. Thanks!
>
Previous Topic:Dependencies of view columns
Next Topic:Connectivity sub-project API changes for community review
Goto Forum:
  


Current Time: Fri Nov 28 03:37:55 GMT 2014

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

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