Bug 780354 (SOA-2764)

Summary: ODBC connection fails if the TeiidDriver is not registered.
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Ramesh Reddy <rareddy>
Component: EDSAssignee: Ramesh Reddy <rareddy>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER6CC: vhalbert
Target Milestone: ---   
Target Release: 5.1.0.ER7   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2764
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-04 20:06:25 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:

Description Ramesh Reddy 2011-01-11 19:21:19 UTC 
Complexity: Low
Workaround Description: configure a data source for Teiid, and invoke it so that it registers the driver.
project_key: SOA

When the ODBC connection is made to the Teiid Server, it uses the JDBC connection using "local" mode. To make this connection it uses the DriverManager. However, if the Teiid Driver is not already registered with the VM, then the ODBC client will see the below error.

$iodbctest DSN=test
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0709.0909
1: SQLDriverConnect = ERROR: No suitable driver found for jdbc:teiid:TransactionsRevisited;ApplicationName=ODBC
org.teiid.jdbc.TeiidSQLException: No suitable driver found for jdbc:teiid:TransactionsRevisited;ApplicationName=ODBC (210) SQLSTATE=08001
Comment 1 Van Halbert 2011-01-11 19:21:20 UTC 
Link: Added: This issue Cloned from TEIID-1428
Comment 2 Van Halbert 2011-01-11 19:21:51 UTC 
Security: Added: Public