Bug 780354 (SOA-2764) - ODBC connection fails if the TeiidDriver is not registered.
Summary: ODBC connection fails if the TeiidDriver is not registered.
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2764
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER6
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0.ER7
Assignee: Ramesh Reddy
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-11 19:21 UTC by Ramesh Reddy
Modified: 2011-02-04 20:06 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-04 20:06:25 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2764 0 None None None Never

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
Note You need to log in before you can comment on or make changes to this bug.