Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Db Schema not shown in 'data source explorer' view - Helios
Db Schema not shown in 'data source explorer' view - Helios [message #656322] Fri, 25 February 2011 06:27 Go to next message
Ani  is currently offline Ani
Messages: 37
Registered: November 2010
Member
hello

i tried using DTP with derby, it's working perfectly fine.

but when i try using mysql 5.0/5.1 (eclipse 3.4/3.5/3.6), i'm not able to view my schemas, tables etc under the database. the only thing i see is the default database created while creating connection. I can query the db from sql editor, but schemas created by me are not visible in "data source explorer" view.

my current config details :---
eclipse helios
DTP 1.8.1
mysql 5.1 (driver - mysql-connector-java-5.1.8-bin.jar)
windows 7

am i doing something wrong!

i see few topics here discussing similar issues saying that this is an issue with eclipse.
is it fixed for the configuration i listed above?

kindly suggest me what changes i need make to get it working.

thanks,
Re: Db Schema not shown in 'data source explorer' view - Helios [message #656928 is a reply to message #656322] Tue, 01 March 2011 02:36 Go to previous messageGo to next message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
I think the problem might be the way the MySQL views schemas. Unlike
some other databases such as Oracle and DB2, in MySQL the terms
"database" and "schema" are synonymous. Notice that this is reflected
in the Data Source Explorer representation for MySQL. Let's say you
connect to the MySQL database "test". Then you see "test" as the
database name at the top of the connection tree, plus you see it again
under the node "Schemas". No other schemas are shown, since there are
no other schemas for the "test" database.

This problem could be potentially be fixed by some pretty serious
changes to the "enablement" support for MySQL. As a work-around, you can
create separate database connections for each MySQL database you want to
work with. (By the way, in the connection be sure to specify the
database name both in the "Database" field in the Connection Profile and
in the connection URL. If you leave it out of the URL, then a bug
prevents the tables from showing in the DSE.)

On 2/24/2011 10:27 PM, Ani wrote:
> hello
> i tried using DTP with derby, it's working perfectly fine.
>
> but when i try using mysql 5.0/5.1 (eclipse 3.4/3.5/3.6), i'm not able
> to view my schemas, tables etc under the database. the only thing i see
> is the default database created while creating connection. I can query
> the db from sql editor, but schemas created by me are not visible in
> "data source explorer" view.
>
> my current config details :---
> eclipse helios
> DTP 1.8.1
> mysql 5.1 (driver - mysql-connector-java-5.1.8-bin.jar)
> windows 7
>
> am i doing something wrong!
>
> i see few topics here discussing similar issues saying that this is an
> issue with eclipse.
> is it fixed for the configuration i listed above?
>
> kindly suggest me what changes i need make to get it working.
>
> thanks,
Re: Db Schema not shown in 'data source explorer' view - Helios [message #657218 is a reply to message #656928] Wed, 02 March 2011 00:29 Go to previous messageGo to next message
Ani  is currently offline Ani
Messages: 37
Registered: November 2010
Member
Hello Brian,

Thanks for the detailed response.
Yes, I observed this behaviour of MySQL.
So for now, i've to live with a single schema per one connection of MySQL and will look forward to the enablement fix Smile

Thanks again!
Re: Db Schema not shown in 'data source explorer' view - Helios [message #657761 is a reply to message #656322] Thu, 03 March 2011 21:48 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Unfortunately, you're running into a common problem we have with DTP. The MySQL support was created and at present we don't have anyone on the team who can maintain it.

You can grab the code from the Eclipse CVS repository and debug into it to see where things are failing. I'd recommend starting with the catalog loader to see what SQL it's using to retrieve lists of objects to present in the model...

Sorry I can't be more help.
Previous Topic:Displaying database package source
Next Topic:NulPointer Exception when gettingProfiles
Goto Forum:
  


Current Time: Sun Sep 21 00:07:17 GMT 2014

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

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