Bug 780117 (SOA-2486)

Summary: Data Source Explorer in JBDS does not show content of JDBC accessed ModeShape
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jiri Pechanec <jpechane>
Component: ToolingAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2486
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 780118 (view as bug list) Environment:
Last Closed: 2011-12-06 22:01:37 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 Flags
Screenshot-1.png none

Description Jiri Pechanec 2010-10-27 13:49:43 UTC 
project_key: SOA

Data Explorer does not show the contents of ModeShape. Data Explorer seems to be using path -> Catalog -> Schema -> View -> ModeShape elements.

It seems that ModeShape JDBC driver does not support call of getSchema.

See attached screenshot for differences between ModeShape exploring and PostgreSQL exploring
Comment 1 Jiri Pechanec 2010-10-27 13:50:25 UTC 
Attachment: Added: Screenshot-1.png
Comment 2 Van Halbert 2010-10-27 14:25:18 UTC 
We have a usability issue regarding its usage in the first release.   The driver, in JBDS, is only usable when importing metadata to build a Teiid Model that will be deployed to EDS.    Outside of that, it's not usable.      

There are similar limitations of other connection profiles (i.e.,  webservices, salesforce).   

With that said, the driver could be fixed to at least support the methods to show the metadata in the data explorer, but it will still not support querying the data from a remote client.
Comment 3 Ken Johnson 2010-10-27 20:02:58 UTC 
 Right. Users are not expected to be able to query ModeShape directly through the modeshape connection profile. To query ModeShape from Data Tools or any out-of-process client, you need to go through Teiid. MS supports remote metadata calls but data calls must be in-process. Therefore Teiid running in the same VM as ModeShape can act as a proxy and provide a remote JDBC/ODBC interface to MS via a VDB. 

In the future MS will support direct remote JDBC connections. In the meantime this behavior is expected and should be documented.
Comment 4 Van Halbert 2010-10-28 02:48:14 UTC 
Changed status to Future as this will part of a scheduled enhancement
Comment 5 Van Halbert 2011-09-12 18:05:02 UTC 
Link: Added: This issue depends MODE-872