Bug 1056974

Summary: Designer should not add connection-jndi-name attribute in VDB.xml when no jndi is being referenced
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Lucie Fabrikova <lfabriko>
Component: ToolingAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: asmigala, atangrin, dlesage, fnguyen, lfabriko, vhalbert
Target Milestone: ER2   
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Teiid Designer was adding a connection-jndi-name attribute to the VDB.xml file even when no JNDI was being referenced. This caused an undesired response when running queries against the virtual database. This happened because, when the user blanks out the JNDIreference or it contained space(s), the Designer was incorrectly the connection-jndi-name attribute to the vdb.xml. This behaviour has now been corrected.
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-17 18:05:13 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:
Embargoed:

Description Lucie Fabrikova 2014-01-23 09:32:08 UTC
Description of problem:


Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
The steps are taken from E2eYahooUDF testscript.

1. Setup DV 6 CR2 server:
    unzip yahoo.zip to modules/org/jboss/teiid/translator
    add line <translator name="yahoo" module="org.jboss.teiid.translator.yahoo"/> to standalone.xml
    2. Import metadata model from teiid designer text file YahooStocksXML.xml (MarketData.xml)
    3. Create new vdb with MarketData.xmi. In the source binding tab, select translator "yahoo", and JNDI name "java:jboss/datasources/ExampleDS" (if the JNDI name was empty, I couldn't deploy this vdb)
    4. Execute vdb:
    select * from MarketData.Stock WHERE Symbol = 'RHT'


Actual results:
TEIID30504 MarketData: org.jboss.jca.adapters.jdbc.WrapperDataSource is was not a ConnectionFactory implementation

Expected results:


Additional info:

Comment 2 Van Halbert 2014-01-23 13:35:58 UTC
You can't just leave the jndi-name blank, cause it will fail (it's a known issue, with a fix targeted to first roll-up).   The work-around is to put a space in the jndi name.   This is a use case that will rarely come up because the Yahoo translator is not in the product, and the only other translator where no JNDI would be valid is when using loopback (and that's for testing only).

Comment 3 JBoss JIRA Server 2014-05-07 21:06:44 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2024 to Closed