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

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)

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

Wed, 07 October 2009 06:15

Eclipse User

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

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

Wed, 07 October 2009 15:03

Eclipse User

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

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

Thu, 08 October 2009 21:17

Eclipse User

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

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

Fri, 09 October 2009 05:13

Eclipse User

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

Wed, 14 October 2009 15:37

Eclipse User

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

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

Fri, 23 October 2009 05:58

Eclipse User

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

- Jerry

[Updated on: Fri, 23 October 2009 05:59] by Moderator

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

Mon, 10 May 2010 20:18

Eclipse User

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

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

Tue, 11 May 2010 13:14

Eclipse User

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)

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

Fri, 09 October 2009 05:13

Eclipse User

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

Wed, 14 October 2009 15:37

Eclipse User

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

Fri, 23 October 2009 05:58

Eclipse User

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

Mon, 10 May 2010 20:18

Eclipse User

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

Tue, 11 May 2010 13:14

Eclipse User

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

Sun, 31 October 2010 09:05

Eclipse User

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?

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

Wed, 03 November 2010 14:17

Eclipse User

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?

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

Mon, 30 May 2011 10:40

Eclipse User

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!

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

Wed, 01 June 2011 15:21

Eclipse User

Thanks Tom for the suggestion!

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

Thu, 28 March 2013 06:50

Eclipse User

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 1045 times)

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

Fri, 29 March 2013 14:01

Eclipse User

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..........

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

Tue, 13 August 2013 02:22

Eclipse User

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

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

Fri, 01 April 2016 18:38

Eclipse User

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

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

Wed, 27 July 2016 09:28

Eclipse User

Thanks . My url wasn't completed

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

Mon, 21 November 2016 09:11

Eclipse User

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.

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 [=-

Current Time: Sat Jul 12 00:39:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter