Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsData Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/498812/#msg_498812
I tried whole day to get a connection from Eclispe to MS SQL Server 2008 using DTP, but without success.
My Eclispe version:
3.5.1
Build id: M20090917-0800
My DTP version:
Version: 1.7.0.v200908280400-7J8i2BWwQJOaz-Gi2C5seJM2FX2f
Build id: 1.7.1.v20090904-0500
Microsoft SQL Server 2008 on Windows Server 2003 R2, Standard x64 Edition
Java JRE 1.6
I set up connection under Data Source Explorer, using Generic JDBC and also another one using SQL Server.
I used sqljdbc4.jar.
The ping to my database server succeeded.
In Data Source Explorer I can see also the databases. But if I click the + sign to open a certain database I only see a folder called Schemas, but no tables, no views, etc..
I looked up internet to find a solution, but no success.
What I am doing wrong?
Thanks for any help!
]]>mr. burns2009-11-18T17:15:42-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/499664/#msg_499664
There are some issues with SQL Server support in Galileo at the moment.
Sounds like you're fighting this one: https://bugs.eclipse.org/bugs/show_bug.cgi?id=287587
The resources we've had working on MSSQL haven't had a chance to resolve
this in the 1.7.x maintenance stream yet, but I'm still hopeful it will
get resolved.
Our issue right now is a lack of bodies helping out on Enablement
support. We love people who provide patches to fix issues. :)
Sorry I don't have better news than that at the moment.
--Fitz
mr. burns wrote:
> Hi all,
>
> I tried whole day to get a connection from Eclispe to MS SQL Server 2008
> using DTP, but without success.
>
> My Eclispe version:
> 3.5.1
> Build id: M20090917-0800
>
> My DTP version:
> Version: 1.7.0.v200908280400-7J8i2BWwQJOaz-Gi2C5seJM2FX2f
> Build id: 1.7.1.v20090904-0500
>
> Microsoft SQL Server 2008 on Windows Server 2003 R2, Standard x64 Edition
>
>
> I set up connection under Data Source Explorer, using Generic JDBC and
> also another one using SQL Server.
> I used sqljdbc4.jar.
>
> The ping to my database server succeeded.
> In Data Source Explorer I can see also the databases. But if I click the
> + sign to open a certain database I only see a folder called Schemas,
> but no tables, no views, etc..
>
> I looked up internet to find a solution, but no success.
>
> What I am doing wrong?
>
> Thanks for any help!
>
>
>]]>Brian Fitzpatrick2009-11-23T16:15:30-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/509662/#msg_509662
The issue seems to be GUI related. I can run queries from the SQL scrapbook and get results, so it is able to access the database tables, but will not show them in the GUI.
The GUI related issues extend elsewhere:
1) I cannot see any tables in the SQL Query builder as well.
2) I cannot run anything from the SQL Query builder either, though the exact same statement runs fine from the SQL Scrapbook.
3) If I try to generate entities from database using seam, I do not see any tables in the wizard either.
Thanks,
SGP
]]>SGP 2010-01-24T13:27:27-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/597070/#msg_597070
The issue seems to be GUI related. I can run queries from the SQL scrapbook and get results, so it is able to access the database tables, but will not show them in the GUI.
The GUI related issues extend elsewhere:
1) I cannot see any tables in the SQL Query builder as well.
2) I cannot run anything from the SQL Query builder either, though the exact same statement runs fine from the SQL Scrapbook.
3) If I try to generate entities from database using seam, I do not see any tables in the wizard either.
Thanks,
SGP
8)]]>SGP 2010-01-24T13:27:30-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/597112/#msg_597112
Unfortunately, we don't have anyone with MySQL knowledge who can look
into them at this point. We welcome any help in this area.
SGP wrote:
> Is this also true of MySQL? I have the exact same behavior when trying
> to connect to a MySQL database. Both the Eclipse and MySQL are running
> on the same Ubuntu 9.10 system. I have set GDK_NATIVE_WINDOWS=true as
> suggested elsewhere on the forums to get past problems with Ubuntu 9.10.
>
> The issue seems to be GUI related. I can run queries from the SQL
> scrapbook and get results, so it is able to access the database tables,
> but will not show them in the GUI.
>
> The GUI related issues extend elsewhere:
> 1) I cannot see any tables in the SQL Query builder as well.
> 2) I cannot run anything from the SQL Query builder either, though the
> exact same statement runs fine from the SQL Scrapbook.
> 3) If I try to generate entities from database using seam, I do not see
> any tables in the wizard either.
>
> Thanks,
> SGP
> 8)]]>Brian Fitzpatrick2010-01-26T16:00:50-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/510185/#msg_510185
Unfortunately, we don't have anyone with MySQL knowledge who can look
into them at this point. We welcome any help in this area.
SGP wrote:
> Is this also true of MySQL? I have the exact same behavior when trying
> to connect to a MySQL database. Both the Eclipse and MySQL are running
> on the same Ubuntu 9.10 system. I have set GDK_NATIVE_WINDOWS=true as
> suggested elsewhere on the forums to get past problems with Ubuntu 9.10.
>
> The issue seems to be GUI related. I can run queries from the SQL
> scrapbook and get results, so it is able to access the database tables,
> but will not show them in the GUI.
>
> The GUI related issues extend elsewhere:
> 1) I cannot see any tables in the SQL Query builder as well.
> 2) I cannot run anything from the SQL Query builder either, though the
> exact same statement runs fine from the SQL Scrapbook.
> 3) If I try to generate entities from database using seam, I do not see
> any tables in the wizard either.
>
> Thanks,
> SGP
> 8)]]>Brian Fitzpatrick2010-01-26T16:00:50-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/1731918/#msg_1731918
I'm getting the same issue as the OP using fresh everything:
Microsoft SQL Server 2008 JDBC Driver
sqljdbc42.jar (or sqljdbc4.jar, sqljdbc41.jar) from Microsoft.
In the DB set up, Ping succeeds but in the DSE no schemas.
Suggestions?]]>Darryn Brooking2016-05-11T03:24:28-00:00Re: Data Soruce Explorer, No tables, only Schemas visible
https://www.eclipse.org/forums/index.php/mv/msg/158020/1735811/#msg_1735811
Shwetha Venkatesh2016-06-22T22:43:43-00:00