Eclipse Community Forums: DTP » How to view tables, stored procedure etc in DTP

Search

Help

Login

Home » Eclipse Projects » DTP » How to view tables, stored procedure etc in DTP (Installed Mysql and plugin into eclipse successfuly but can't see tables, stored procedures etc in DTP)

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

How to view tables, stored procedure etc in DTP [message #490096]

Wed, 07 October 2009 10:15

No real name is currently offline

Friend

Messages: 8
Registered: September 2009

Junior Member

Hi Guys,

I have installed eclipse galileo 3.5 for j2ee. I have installed and configure mysql database in eclipse too. I pinged the database and connected successfuly.

I can create database and create tables etc in sql scrapbook, but in database development prespective when go under the schemas then try to expand the folders for tables, user defined function, procedures etc found nothing.I can't see the tables I created under table folder.

I have took the screen shot and uploaded - Where you can see i can't expand the nodes of folder, procedure etc to see my tables etc.

Please tell me what I am doing wrong or missing some thing.

Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #490200 is a reply to message #490096]

Wed, 07 October 2009 19:03

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Can you tell us what database you're using, what profile wizard you used
(i.e. generic JDBC, or something else), and what JDBC driver you're using?
--Fitz

virkjay@hotmail.co.uk wrote:
> Hi Guys,
>
> I have installed eclipse galileo 3.5 for j2ee. I have installed and
> configure mysql database in eclipse too. I pinged the database and
> connected successfuly.
> I can create database and create tables etc in sql scrapbook, but in
> database development prespective when go under the schemas then try to
> expand the folders for tables, user defined function, procedures etc
> found nothing.I can't see the tables I created under table folder.
> I have took the screen shot and uploaded - Where you can see i can't
> expand the nodes of folder, procedure etc to see my tables etc.
>
> Please tell me what I am doing wrong or missing some thing.
>
> Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #490527 is a reply to message #490096]

Fri, 09 October 2009 01:17

No real name is currently offline

Friend

Messages: 8
Registered: September 2009

Junior Member

Hi,

I am using Mysql 5.1 and plugin with Connector J with following jar file - mysql-connector-java 5.1.10 bin.jar.

Driver type used is - MySQL JDBC Driver 5.1

I had gone into (eclipse) window - prefrence, under driver definition added the Mysqljdbc driver 5.1 and mysql-connector-java 5.1.10 bin.jar.

Under database development added new connection configure the connection and connect it and pinged successful but tables are not showing.

Please tell me where I am going wrong or what to do this work properly.

Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #490576 is a reply to message #490200]

Fri, 09 October 2009 09:13

No real name is currently offline

Friend

Messages: 8
Registered: September 2009

Junior Member

Hi,

I am using Mysql 5.1 and plugin with Connector J with following jar file - mysql-connector-java 5.1.10 bin.jar.

Driver type used is - MySQL JDBC Driver 5.1

I had gone into (eclipse) window - prefrence, under driver definition added the Mysqljdbc driver 5.1 and mysql-connector-java 5.1.10 bin.jar.

Under database development added new connection configure the connection and connect it and pinged successful but tables are not showing.

Please tell me where I am going wrong or what to do this work properly.

Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #491498 is a reply to message #490576]

Wed, 14 October 2009 19:37

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Hi...

We currently have some issues with the MySQL support in Galileo that I
have not been able to reproduce in a sample MySQL database. Any
specifics you can provide as to how your database is configured or how I
can create a sample database that duplicates your issues would be
greatly appreciated.

--Fitz

virkjay@hotmail.co.uk wrote:
> Hi,
>
> I am using Mysql 5.1 and plugin with Connector J with following jar file
> - mysql-connector-java 5.1.10 bin.jar.
>
> Driver type used is - MySQL JDBC Driver 5.1
>
> I had gone into (eclipse) window - prefrence, under driver definition
> added the Mysqljdbc driver 5.1 and mysql-connector-java 5.1.10 bin.jar.
>
> Under database development added new connection configure the connection
> and connect it and pinged successful but tables are not showing.
>
> Please tell me where I am going wrong or what to do this work properly.
>
> Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #493124 is a reply to message #491498]

Fri, 23 October 2009 09:58

Jerry Merfeld is currently offline

Friend

Messages: 2
Registered: October 2009

Junior Member

I am also having some difficulties with DTP 1.7.

Model Name: MacBook
Processor Name: Intel Core Duo
JDK: soylatte16-i386-1.0.3
Eclipse: Galileo Java EE IDE for Web Developers Build id: 20090920-1017
MySQL engine: 5.4.3-beta
MySQL 5.1 JDBC Driver: mysql-connector-java-5.1.10-bin.jar

No Real Name - After executing your sql script from the scrapbook, did you refresh the schema from your Data Source Explorer? I was able to see my newly created table after executing the script below.

CREATE TABLE newtable (
id INT NOT NULL,
column2 VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);

Fitz - I was hoping I could generate sql by editing the contents of my "scrapbook" from the SQL Query Builder but SELECT, INSERT, UPDATE, and DELETE are the only statement types available.

I'm connected to the database as 'root'. Is CREATE not an option?

Thanks!!! Smile

Smile

- Jerry

[Updated on: Fri, 23 October 2009 09:59]

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #532715 is a reply to message #493124]

Tue, 11 May 2010 00:18

No real name is currently offline

Friend

Messages: 2
Registered: May 2010

Junior Member

I have the same issue.

I can also ping/connect to database but no tables are shown.

Here's my setup:

- galileo 3.5 32-bit
- mysql 5.1.46 32-bit
- jdbc jar is mysql-connector-java 5.1.12-bin.jar
- windows 7 64-bit

Has this issue been taken care of? It's been a long time since anyone has commented.

Thanks in advance. Cool

Cool

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #532966 is a reply to message #532715]

Tue, 11 May 2010 17:14

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Someone is looking into the MySQL issue and we'll hopefully get the fix
into Helios.

c.emmons@gmail.com wrote:
> I have the same issue.
>
> I can also ping/connect to database but no tables are shown.
>
> Here's my setup:
>
> - galileo 3.5 32-bit
> - mysql 5.1.46 32-bit
> - jdbc jar is mysql-connector-java 5.1.12-bin.jar
> - windows 7 64-bit
>
> Has this issue been taken care of? It's been a long time since anyone
> has commented.
>
> Thanks in advance. 8)

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #596621 is a reply to message #490200]

Fri, 09 October 2009 09:13

No real name is currently offline

Friend

Messages: 8
Registered: September 2009

Junior Member

Hi,

I am using Mysql 5.1 and plugin with Connector J with following jar file - mysql-connector-java 5.1.10 bin.jar.

Driver type used is - MySQL JDBC Driver 5.1

I had gone into (eclipse) window - prefrence, under driver definition added the Mysqljdbc driver 5.1 and mysql-connector-java 5.1.10 bin.jar.

Under database development added new connection configure the connection and connect it and pinged successful but tables are not showing.

Please tell me where I am going wrong or what to do this work properly.

Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #596660 is a reply to message #596621]

Wed, 14 October 2009 19:37

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Hi...

We currently have some issues with the MySQL support in Galileo that I
have not been able to reproduce in a sample MySQL database. Any
specifics you can provide as to how your database is configured or how I
can create a sample database that duplicates your issues would be
greatly appreciated.

--Fitz

virkjay@hotmail.co.uk wrote:
> Hi,
>
> I am using Mysql 5.1 and plugin with Connector J with following jar file
> - mysql-connector-java 5.1.10 bin.jar.
>
> Driver type used is - MySQL JDBC Driver 5.1
>
> I had gone into (eclipse) window - prefrence, under driver definition
> added the Mysqljdbc driver 5.1 and mysql-connector-java 5.1.10 bin.jar.
>
> Under database development added new connection configure the connection
> and connect it and pinged successful but tables are not showing.
>
> Please tell me where I am going wrong or what to do this work properly.
>
> Thanks

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #596741 is a reply to message #491498]

Fri, 23 October 2009 09:58

Jerry Merfeld is currently offline

Friend

Messages: 2
Registered: October 2009

Junior Member

I am also having some difficulties with DTP 1.7.

Model Name: MacBook
Processor Name: Intel Core Duo
JDK: soylatte16-i386-1.0.3
Eclipse: Galileo Java EE IDE for Web Developers Build id: 20090920-1017
MySQL engine: 5.4.3-beta
MySQL 5.1 JDBC Driver: mysql-connector-java-5.1.10-bin.jar

No Real Name - After executing your sql script from the scrapbook, did you refresh the schema from your Data Source Explorer? I was able to see my newly created table after executing the script below.

CREATE TABLE newtable (
id INT NOT NULL,
column2 VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);

Fitz - I was hoping I could generate sql by editing the contents of my "scrapbook" from the SQL Query Builder but SELECT, INSERT, UPDATE, and DELETE are the only statement types available.

I'm connected to the database as 'root'. Is CREATE not an option?

Thanks!!! :)
- Jerryv

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #597477 is a reply to message #596741]

Tue, 11 May 2010 00:18

No real name is currently offline

Friend

Messages: 2
Registered: May 2010

Junior Member

I have the same issue.

I can also ping/connect to database but no tables are shown.

Here's my setup:

- galileo 3.5 32-bit
- mysql 5.1.46 32-bit
- jdbc jar is mysql-connector-java 5.1.12-bin.jar
- windows 7 64-bit

Has this issue been taken care of? It's been a long time since anyone has commented.

Thanks in advance. 8)

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #597485 is a reply to message #597477]

Tue, 11 May 2010 17:14

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Someone is looking into the MySQL issue and we'll hopefully get the fix
into Helios.

c.emmons@gmail.com wrote:
> I have the same issue.
>
> I can also ping/connect to database but no tables are shown.
>
> Here's my setup:
>
> - galileo 3.5 32-bit
> - mysql 5.1.46 32-bit
> - jdbc jar is mysql-connector-java 5.1.12-bin.jar
> - windows 7 64-bit
>
> Has this issue been taken care of? It's been a long time since anyone
> has commented.
>
> Thanks in advance. 8)

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #636362 is a reply to message #597485]

Sun, 31 October 2010 13:05

Shawn Ashe is currently offline

Friend

Messages: 4
Registered: October 2010
Location: Dracut, MA

Junior Member

Has this problem been resolved?

I installed the latest eclipse (helios) this week, as well as the latest mysql server and jdbc driver (all on windows vista)

Creating a connection to the database allows me to see the schemas, but not the tables, so reversing the tables to entities in JPA is not possible.

This works in ganymede, but not on helios..

I don't see a lot of discussion online about this..so was wondering if anyone found a solution?

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #637010 is a reply to message #636362]

Wed, 03 November 2010 18:17

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Hi Shawn,

Unfortunately we don't have any MySQL folks helping out on the project
any more, so we haven't made any progress. If someone would be willing
to contribute a patch or two to fix the issue, we'd love to have the help!

--Fitz

Shawn wrote:
> Has this problem been resolved?
>
> I installed the latest eclipse (helios) this week, as well as the latest
> mysql server and jdbc driver (all on windows vista)
>
> Creating a connection to the database allows me to see the schemas, but
> not the tables, so reversing the tables to entities in JPA is not possible.
>
> This works in ganymede, but not on helios..
>
> I don't see a lot of discussion online about this..so was wondering if
> anyone found a solution?

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #675194 is a reply to message #637010]

Mon, 30 May 2011 14:40

Tom Adam is currently offline

Friend

Messages: 1
Registered: May 2011

Junior Member

Hi,

The same problem happens, if the JDBC connection string does not contain the schema name.

So, if the JDBC connection string is only like:
jdbc:mysql://[server_name]:3306/
instead of
jdbc:mysql://[server_name]:3306/[schema_name]

than Eclipse shows no tables neither in Database Explorer, nor in JPA table generation.

Hope, this could help some of U, guys!

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #675878 is a reply to message #675194]

Wed, 01 June 2011 19:21

Brian Fitzpatrick is currently offline

Brian Fitzpatrick

Friend

Messages: 500
Registered: July 2009

Senior Member

Thanks Tom for the suggestion!

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1028507 is a reply to message #490096]

Thu, 28 March 2013 10:50

sumit mondal is currently offline

Friend

Messages: 2
Registered: March 2013

Junior Member

hi,
I'm facing same kind of problem.
I'm using helios java EE IDE and DB2 version 3.0.0.3.
I'm able to connect my database server and schema. But when i expand schemas nothing is shown.
I'm new in web development and eclipse.
Please help me out.
I'm also attached a screen shot of the eclipse IDE window...
Urgent reply needed.

Thanks

Attachment: screenshot.png
(Size: 164.79KB, Downloaded 604 times)

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1029446 is a reply to message #1028507]

Fri, 29 March 2013 18:01

sumit mondal is currently offline

Friend

Messages: 2
Registered: March 2013

Junior Member

Tom Adam
Hi,

The same problem happens, if the JDBC connection string does not contain the schema name.

So, if the JDBC connection string is only like:
jdbc:mysql://[server_name]:3306/
instead of
jdbc:mysql://[server_name]:3306/[schema_name]

than Eclipse shows no tables neither in Database Explorer, nor in JPA table generation.

Hope, this could help some of U, guys!

I already tried all this thing but nothing happened.......
Please give some suggestion..........

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1085625 is a reply to message #490096]

Tue, 13 August 2013 06:22

gourav jain is currently offline

Friend

Messages: 1
Registered: August 2013

Junior Member

The problem is with the stored procedure. I created stored procedure and executed in phpmy Admin page the sql was successfully executed but on viewing it in the eclipse helios I found it under user defined function instead of stored procedure .
Please help,

eclipse helios
mysql 5.1
windows xp 32 bits

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1728320 is a reply to message #1085625]

Fri, 01 April 2016 22:38

Shwetha Venkatesh is currently offline

Shwetha Venkatesh

Friend

Messages: 15
Registered: March 2016

Junior Member

Having same problem in Postgres DB for Eclipse Luna and DTP1.12.
Any update..if this issue is fixed??

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1739086 is a reply to message #675194]

Wed, 27 July 2016 13:28

anicet Noutsua is currently offline

Friend

Messages: 1
Registered: July 2016

Junior Member

Thanks . My url wasn't completed

Report message to a moderator

Re: How to view tables, stored procedure etc in DTP [message #1748241 is a reply to message #490096]

Mon, 21 November 2016 14:11

Victor Russell is currently offline

Friend

Messages: 1
Registered: November 2016

Junior Member

I had the same problem and it resolved when I edited the Database Connection properties URL to include at the end of
jdbc:mysql://www.MyRemoteSite.com
the following :3306/myDatabaseName
So now it looks like this
jdbc:mysql://www.MyRemoteSite.com:3306/myDatabaseName.
Hope that helps you too.

Report message to a moderator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	news.eclipse.org is shutting down.
Next Topic:	Recover informations connection profil in DTP for home made plugin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 17 18:57:48 GMT 2018

Powered by FUDForum. Page generated in 0.03521 seconds

.:: Contact :: Home ::.

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

Back to the top