Hide Forgot
++ This bug is a clone of bug 780806 ++ project_key: SOA 1. Create a simple physical model in a JBDS Teiid Model Project 2. Create a VDB 3. Execute the VDB 4. The tables are not viewable in the database explorer This is probably an environment issue and not related to the project. I'm using 64 bit JBDS and a 64 bit jdk. I will try the 32 bit combination and write back. I will attach the simple project.
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