Eclipse Community Forums: ServerTools (WTP) » DTP: Why SQL statements die saying "no database selected"

Help

Home

Home » Language IDEs » ServerTools (WTP) » DTP: Why SQL statements die saying "no database selected"

Show: Today's Messages :: Show Polls :: Message Navigator

DTP: Why SQL statements die saying "no database selected" [message #211225]

Fri, 28 March 2008 03:26

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

I'm still working through my first Data Tools Platform use of MySQL. I
had exactly the same problems with Derby--never resolved.

I have set up and connected to a MySQL database which I've actually used
successfully from a hand-deployed Java project. So, I know this database
works, though here I'm using a different schema and table within it. The
reason I switched to MySQL was that I couldn't get Derby to accept SQL
statements, but had never used the latter before.

At the following link, you see the illustration of my SQL statements,
Data Source Explorer set-up of the MySQL database to which I'm connected.

http://www.windofkeltia.com/j2ee/tut-images/mysql-database.j pg

In the next link, you see the result of doing an Execute All with the
error displayed as there being no database selected.

http://www.windofkeltia.com/j2ee/tut-images/mysql-statement- failure.jpg

Would this not simply be that I don't know what it means to "select" a
database in DTP? I've tried several silly things like selecting various
subicons in the Data Source Explorer view before doing an Execute All in
the SQL statement window--all to no avail. I've been stumped here for
several days.

Both Derby and MySQL have slain my knight before the gates of DTP
success here. I need a knight who knows his way around this obstacle!

A million thanks in advance!

Russ Bateman

Report message to a moderator

Re: DTP: Why SQL statements die saying "no database selected" [message #211266 is a reply to message #211225]

Fri, 28 March 2008 15:01

Lawrence Mandel

Messages: 486
Registered: July 2009

Senior Member

Hi Russ,

I think you'll have more success with DTP questions on the DTP newsgroup.

Lawrence Mandel
-
Co-author Eclipse Web Tools Platform: Developing Java Web Applications
http://www.eclipsewtp.org

>I'm still working through my first Data Tools Platform use of MySQL. I
>had exactly the same problems with Derby--never resolved.
>
>I have set up and connected to a MySQL database which I've actually used
>successfully from a hand-deployed Java project. So, I know this database
>works, though here I'm using a different schema and table within it. The
>reason I switched to MySQL was that I couldn't get Derby to accept SQL
>statements, but had never used the latter before.
>
>At the following link, you see the illustration of my SQL statements,
>Data Source Explorer set-up of the MySQL database to which I'm connected.
>
> http://www.windofkeltia.com/j2ee/tut-images/mysql-database.j pg
>
>In the next link, you see the result of doing an Execute All with the
>error displayed as there being no database selected.
>
> http://www.windofkeltia.com/j2ee/tut-images/mysql-statement- failure.jpg
>
>Would this not simply be that I don't know what it means to "select" a
>database in DTP? I've tried several silly things like selecting various
>subicons in the Data Source Explorer view before doing an Execute All in
>the SQL statement window--all to no avail. I've been stumped here for
>several days.
>
>Both Derby and MySQL have slain my knight before the gates of DTP
>success here. I need a knight who knows his way around this obstacle!
>
>A million thanks in advance!
>
>Russ Bateman

Report message to a moderator

Previous Topic:	BIRT 2.2.0 Library Problem
Next Topic:	Re: Publishing error on a dynamic web app project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:50:39 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter