Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-2764

ODBC connection fails if the TeiidDriver is not registered.

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 5.1.0.ER6
    • Fix Version/s: 5.1.0.ER7
    • Component/s: EDS
    • Labels:
      None
    • Workaround Description:
      Hide

      configure a data source for Teiid, and invoke it so that it registers the driver.

      Show
      configure a data source for Teiid, and invoke it so that it registers the driver.
    • Estimated Difficulty:
      Low

      Description

      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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  rareddy Ramesh Reddy
                  Reporter:
                  rareddy Ramesh Reddy
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: