Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Postgres 8.3 Schema not expanding in Data Source Explorer
Postgres 8.3 Schema not expanding in Data Source Explorer [message #968594] Fri, 02 November 2012 15:30 Go to next message
Tony Crisera is currently offline Tony CriseraFriend
Messages: 2
Registered: November 2012
Junior Member
I've created a data source for a Postgres 8.3 database (remote server, not localhost). I figured out how to set up the connection and specify driver, successfully pinged. Then I could connect.
It shows the server, (correct version) and the database. Under Schemas I see public and expand, however if I click tables nothing happens.

I want to use this connection w/ Dali to generate JPA. I've tried different version of the driver, but nothing helped. I'm running in Helios.

I installed Toad extensions and I can connect w/ a JDBC connection using that and explore the whole db. I don't know why that would work. But it isn't going to help me w/ Dali.

Any suggestions of where to look is appreciated. Let me know what additional info I could provide. (btw, I can create a SQL Server connection and fully browse so it seems specific to Postgres)

Thanks
Re: Postgres 8.3 Schema not expanding in Data Source Explorer [message #986059 is a reply to message #968594] Sat, 17 November 2012 23:00 Go to previous messageGo to next message
Simon Arsenault is currently offline Simon ArsenaultFriend
Messages: 2
Registered: November 2012
Junior Member
I'm having the same issue except I'm using PostgreSQL 9.2 on localhost (Eclipse Juno SR1). Disappointing as I cannot use the wizard "JPA Entities from Tables".

Anyone know if this is a bug/limitation with Eclipse or the JDBC driver from PostgreSQL?
Re: Postgres 8.3 Schema not expanding in Data Source Explorer [message #987024 is a reply to message #986059] Fri, 23 November 2012 00:48 Go to previous messageGo to next message
Simon Arsenault is currently offline Simon ArsenaultFriend
Messages: 2
Registered: November 2012
Junior Member
update... it is now working, I can see the tables now. I deleted my PostgreSQL database, and recreated it again. Created the tables. That did the trick.
Re: Postgres 8.3 Schema not expanding in Data Source Explorer [message #1006228 is a reply to message #987024] Wed, 30 January 2013 14:09 Go to previous message
Tony Crisera is currently offline Tony CriseraFriend
Messages: 2
Registered: November 2012
Junior Member
Just trying again since I read the last post. Still behaving the same. The data base has been dropped and re-created since then. I am connecting to a remote PG server running on Linux. The ping works so I don't see how that can make any difference.

Thx
Previous Topic:DSE has add new connection options greyed out
Next Topic:Connect to Microsoft Access via Data Explorer in IDE
Goto Forum:
  


Current Time: Mon Nov 24 17:59:43 GMT 2014

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

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