Eclipse Community Forums: DTP » MySQL schema not shown in 'data source explorer' view

Help

Home

Home » Eclipse Projects » DTP » MySQL schema not shown in 'data source explorer' view - Helios

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

MySQL schema not shown in 'data source explorer' view - Helios [message #656318]

Fri, 25 February 2011 05:51

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,

Report message to a moderator

Re: MySQL schema not shown in 'data source explorer' view - Helios [message #656422 is a reply to message #656318]

Fri, 25 February 2011 14:50

Brian Vosburgh

Messages: 137
Registered: July 2009

Senior Member

This might be related to bug 279726[1].

[1] https://bugs.eclipse.org/bugs/show_bug.cgi?id=279726

Report message to a moderator

Re: MySQL schema not shown in 'data source explorer' view - Helios [message #656657 is a reply to message #656422]

Mon, 28 February 2011 00:33

Ani

Messages: 37
Registered: November 2010

Member

Thanks for the pointer. Yes, i had a look on that.
So is there any alternate approach for editing the schema and tables as such?
Or else can we expect a fix for this Smile

I am building a plug-in where i need to edit the tables (column names, properties, cell values etc...) from eclipse.
Is this anyway possible using DTP (MySQL, SQLServer)?

Thanks,

Report message to a moderator

Re: MySQL schema not shown in 'data source explorer' view - Helios [message #656663 is a reply to message #656657]

Mon, 28 February 2011 02:35

Ani

Messages: 37
Registered: November 2010

Member

To be more precise...

I'm able to do the alteration by executing queries.
But i want to do the same from 'data source explorer' view. (something like right click --> edit data / edit table or schema property).

Please let me know if there are alternates available currently.

Thanks,

Report message to a moderator

Previous Topic:	Is it possible to use DTP to connect to server running SSL
Next Topic:	Using the SQL Query Builder UI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 20 14:41:08 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter