|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
| Brian Payton
Registered: July 2009
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:
> 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.
Powered by FUDForum
. Page generated in 0.03943 seconds