| Summary: | EDS - unable to browse the VDB tables using the 'Data Source Explorer' | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Gary Lamperillo <glamperi> | ||||||||
| Component: | unspecified | Assignee: | Van Halbert <vhalbert> | ||||||||
| Status: | CLOSED NEXTRELEASE | QA Contact: | |||||||||
| Severity: | high | Docs Contact: | |||||||||
| Priority: | high | ||||||||||
| Version: | unspecified | CC: | glamperi, vhalbert | ||||||||
| Target Milestone: | --- | ||||||||||
| Target Release: | --- | ||||||||||
| Hardware: | Unspecified | ||||||||||
| OS: | Unspecified | ||||||||||
| URL: | http://jira.jboss.org/jira/browse/SOA-3252 | ||||||||||
| Whiteboard: | |||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||
| Doc Text: | Story Points: | --- | |||||||||
| Clone Of: | SOA-3252 | Environment: |
RHEl 6.1 JBoss Developer Studio 4.0.0 Stand Alone linux-gtk x86_64 Binary 64 bit JDK - Both Sun and OpenJDK
|
||||||||
| Last Closed: | 2011-08-12 15:47:46 UTC | Type: | Bug | ||||||||
| Regression: | --- | Mount Type: | --- | ||||||||
| Documentation: | --- | CRM: | |||||||||
| Verified Versions: | Category: | --- | |||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||
| Attachments: |
|
||||||||||
|
Description
Gary Lamperillo
2011-08-09 03:14:37 UTC
Attachment: Added: eds_test.tar.gz I have downloaded the 32 bit JBDS and repeated the same test case. The results are the same. So, it does not appear to be related to JBDS 64/32 bit or the JDK version. Also, the 64 bit JBDS was patched for the new teiid plugins, and the JBDS 32 bit was not patched. Before I test your project set, wanted to make sure the process works. I did the following: - imported a few tables from a SQL Server database to create the physical model - created the vdb (Test2) - right mouse click on physical model to create the data source on the server - had to manually deploy the vdb to the server, because the there's a AS5 issue when running on a mac. Otherwise, you can deploy it from designer. - Opened up Data Source Explorer, created a Database Connection to teiid server. - doubled clicked the connection and proceeded to traverse the tree to view the tables (see attachment). Hm, it worked for me. Image displaying the ability to view the tables from a Teiid Connection using Database Explorer. Attachment: Added: datasource_explorer.tiff I duplicated your issue. For some reason (TBD), the way that designer is creating the database connection versus manually creating the database connection (from Data Source Explorer) are different. I'm not sure yet, but if Designer creates it, you cannot view the tables. I have manually created the connection and I have the same issue. 1. go to Database explorer 2. Connection Profiles -> select Teiid (the name of the VDB is preset to PREVIEW_3a26f9f7-06a2-4456-b0a1-34c19f3f3b9a_brokerinfo_project) 3. enter your user and password, connection test works (ping is fine) 4. under catalogs the vdb name is listed as PREVIEW_3a26f9f7-06a2-4456-b0a1-34c19f3f3b9a_brokerinfo_project 5. I can not go below schemas. I found if I changed the driver to be a new (different) Teiid driver, instead of the one created for preview, mine worked. The vdb name shouldn't have "PREVIEW..." in the name. It should be there name of the vdb that you deployed. At the moment, I can't find (after several other eyes looking on) how to remove all my drivers (6 of them) and start fresh to see how Designer is creating the drivers. I think its reusing "Teiid Preview Driver" (in my case) instead of creating one that uses the actual vdb name. Attachment: Added: teiid-client.jar Hi Van, The new Teiid Driver works! Thanks! Gary |