Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1156237

Summary: "Preview Data" throws Exception, when user select jdbc driver which is not located under C dirive
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Hisao Furuichi <hfuruich>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: anmahaja, blafond, felias, mmakovy, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Windows   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
When a user creates a source model using the JDBC driver which is not located under C drive, the application throws an exception when you preview the source model. This behaviour persists in JBoss Data Virtualization 6.1.
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-17 18:07:39 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 Hisao Furuichi 2014-10-24 00:01:29 UTC
Describe the issue: 
When user select/use a jdbc driver which is not located Under C drive, "preview data" thows TEIID30504 Exception.

Environment:
- Windows 7
- Teiid Designer 8.3.4.Final-v20140912-1304-B264 (JBDSIS 7.0.3)

Reproduce steps:
1. locate a jdbc driver under E drive (Please do not store it under C drive)
2. Using "Create JDBC Connection" wizard, create a connection
3. Create a source model using the JDBC connection
4. Preview the source model

Actual Result:
Following errors are displayed on the status window in Teiid Designer
===
TEIID30504 LocalMySQL: TEIID30481 Failed to find the Connection Factory with JNDI name PREVIEW_a3d56db3-369f-43d3-8812-49e8cbf3b2ae_JDBCVDB_sources_LocalMySQL. Please check the name or deploy the Connection Factory with specified name.
===

Expected Behavior:
User can locate a jdbc driver not only C driver but also other lettered drive

Comment 1 Barry LaFond 2014-10-24 13:03:40 UTC
Can you verify in the Server view, under the Teiid Instance Configuration/Data Sources folder whether or not the PREVIEW... Data source was deployed or not?
 
You'll have to select the Teiid Instance Configuration folder and check the "Show Preview Data Sources" option.

Comment 2 Hisao Furuichi 2014-10-27 09:11:59 UTC
Hi, Barry.

I can't see any Data source named "PREVIEW...". However I do not find the option you mentioned at previous comment either:

>You'll have to select the Teiid Instance Configuration folder and check the "Show Preview Data Sources" option.

Could you explain more details about how to check the option please? I'm using JBDS 7.1.1 with JBDSIS 7.0.3.

Thx

Comment 3 Hisao Furuichi 2014-10-29 08:30:35 UTC
Hello.

I also have a question about a workaround.
Without storing a jdbc driver under C drive, is there any workaround for this issue?

Comment 4 Barry LaFond 2014-12-02 21:07:25 UTC
issue was reproduced on Windows and a fix will be applied and available on the next Designer milestone.

Comment 5 JBoss JIRA Server 2014-12-03 15:09:29 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2404 to Resolved

Comment 6 Matus Makovy 2015-02-10 08:45:44 UTC
verified TD 9.0.1.Final

Comment 7 JBoss JIRA Server 2015-02-10 08:45:54 UTC
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2404 to Closed

Comment 8 Matus Makovy 2015-03-04 11:18:37 UTC
verified TD 8.6.1.CR1