Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 10:15 Go to next message
No real name is currently offline No real name
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
Re: How to view tables, stored procedure etc in DTP [message #490200 is a reply to message #490096] Wed, 07 October 2009 19:03 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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
Re: How to view tables, stored procedure etc in DTP [message #490527 is a reply to message #490096] Fri, 09 October 2009 01:17 Go to previous messageGo to next message
No real name is currently offline No real name
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
Re: How to view tables, stored procedure etc in DTP [message #490576 is a reply to message #490200] Fri, 09 October 2009 09:13 Go to previous messageGo to next message
No real name is currently offline No real name
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
Re: How to view tables, stored procedure etc in DTP [message #491498 is a reply to message #490576] Wed, 14 October 2009 19:37 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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
Re: How to view tables, stored procedure etc in DTP [message #493124 is a reply to message #491498] Fri, 23 October 2009 09:58 Go to previous messageGo to next message
Jerry Merfeld is currently offline Jerry Merfeld
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
- 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 Go to previous messageGo to next message
No real name is currently offline No real name
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
Re: How to view tables, stored procedure etc in DTP [message #532966 is a reply to message #532715] Tue, 11 May 2010 17:14 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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)
Re: How to view tables, stored procedure etc in DTP [message #596621 is a reply to message #490200] Fri, 09 October 2009 09:13 Go to previous messageGo to next message
No real name is currently offline No real name
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
Re: How to view tables, stored procedure etc in DTP [message #596660 is a reply to message #596621] Wed, 14 October 2009 19:37 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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
Re: How to view tables, stored procedure etc in DTP [message #596741 is a reply to message #491498] Fri, 23 October 2009 09:58 Go to previous messageGo to next message
Jerry Merfeld is currently offline Jerry Merfeld
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
Re: How to view tables, stored procedure etc in DTP [message #597477 is a reply to message #596741] Tue, 11 May 2010 00:18 Go to previous messageGo to next message
No real name is currently offline No real name
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)
Re: How to view tables, stored procedure etc in DTP [message #597485 is a reply to message #597477] Tue, 11 May 2010 17:14 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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)
Re: How to view tables, stored procedure etc in DTP [message #636362 is a reply to message #597485] Sun, 31 October 2010 13:05 Go to previous messageGo to next message
Shawn Ashe is currently offline Shawn Ashe
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?
Re: How to view tables, stored procedure etc in DTP [message #637010 is a reply to message #636362] Wed, 03 November 2010 18:17 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
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?
Re: How to view tables, stored procedure etc in DTP [message #675194 is a reply to message #637010] Mon, 30 May 2011 14:40 Go to previous messageGo to next message
Tom Adam is currently offline Tom Adam
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!
Re: How to view tables, stored procedure etc in DTP [message #675878 is a reply to message #675194] Wed, 01 June 2011 19:21 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Thanks Tom for the suggestion!
icon6.gif  Re: How to view tables, stored procedure etc in DTP [message #1028507 is a reply to message #490096] Thu, 28 March 2013 10:50 Go to previous messageGo to next message
sumit mondal is currently offline sumit mondal
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
Re: How to view tables, stored procedure etc in DTP [message #1029446 is a reply to message #1028507] Fri, 29 March 2013 18:01 Go to previous messageGo to next message
sumit mondal is currently offline sumit mondal
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..........
Re: How to view tables, stored procedure etc in DTP [message #1085625 is a reply to message #490096] Tue, 13 August 2013 06:22 Go to previous message
gourav jain is currently offline gourav jain
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
Previous Topic:Freeze in DB Development perspective
Next Topic:Ldap Integration
Goto Forum:
  


Current Time: Sat Oct 25 08:44:53 GMT 2014

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

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