Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Re: DTP: Why SQL statements die saying "no database selected"
Re: DTP: Why SQL statements die saying "no database selected" [message #590689] Fri, 28 March 2008 15:01
Lawrence Mandel is currently offline Lawrence MandelFriend
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

>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.
> pg
>In the next link, you see the result of doing an Execute All with the
>error displayed as there being no database selected.
> 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
Previous Topic:Re: DTP: Why SQL statements die saying "no database selected"
Next Topic:ODA with POJOs
Goto Forum:

Current Time: Mon May 17 22:29:42 GMT 2021

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

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

Back to the top