Eclipse Community Forums: DTP » Data Source Explorer shows Informix schemas empty

Home » Eclipse Projects » DTP » Data Source Explorer shows Informix schemas empty(When browsing an Informix database no table is expanded on any schema but system ones under Informix schema)

Data Source Explorer shows Informix schemas empty [message #874976]

Mon, 21 May 2012 18:12

Eclipse User

Hello.

I can't browse tables for a given schema in Informix using Eclipse Data Source Explorer. The only tables I can browse is the catalog, the sys* ones in the Informix schema.

I'm using Eclipse v3.6 (Helios) with Data Tools Project plugin v1.9.2 for accessing an Informix 11.70 database. The driver (v10.0) and the connection configuration seem to be right as I can ping and query properly using the SQL scrap book, creating and selecting tables. In fact the applications work perfectly once deployed, but I'm unable to use Eclipse features such as JPS tools. The user has the proper access and is able to browse and operate anything from Server Studio.

I've searched Google for a few days and found some cases expriencing something alike (for instance it can happen in MySQL if you're missing the database in the URL), but found no proper answer.

Thanks in advance

P.S.: I've created a test project that illustrates the problem. Notice the "Tables" node can't be expanded. i.stack.imgur.com/F2u4w.png

Edit: typo
Edit 2: Rewrite for clarifying

[Updated on: Thu, 24 May 2012 06:52] by Moderator

Re: Data Source Explorer shows Informix schemas empty [message #899267 is a reply to message #874976]

Tue, 31 July 2012 05:19