Bug 999534

Summary: Can't create data provider from teiid datasource
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: Dashboard BuilderAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: atangrin, vhalbert
Target Milestone: ER1   
Target Release: 6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 999974 (view as bug list) Environment:
Last Closed: 2014-02-06 15:37:06 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:
Bug Depends On:    
Bug Blocks: 999974    

Description Filip Elias 2013-08-21 13:50:38 UTC 
Description of problem:
Can't create Data provider which uses teiid datasource. 
When I click on "Attempt data load" or "Save", validation error will appear that says "SQL cannot be null for CallableStatement or PreparedStatement".

It seems that HibernateInitializer.java doesn't support Teiid. 
Method inferDatabaseName(DataSource ds) doesn't check dbProductName for string "teiid" so it returns NULL and therefore the whole operation will fail.

Steps to Reproduce:
1. Create Teiid datasource
2. Select Data providers > Create new data provider   > Type: SQL Query
3. Select Teiid datasource
4. Add anything in the Query field
5. Click "Attempt data load" or "Save" button
Comment 5 Filip Elias 2013-11-15 09:23:12 UTC 
Verified on DV6 ER3