"org.teiid.jdbc.TeiidDriver cannot be cast to javax.sql.DataSource" error in WebMethod trying to connect to JBEDS

Solution Verified - Updated -

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.3.0

Issue

  • We are trying to connect to JBEDS using JDBC driver from WebMethod but we are getting the below error.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection:
org.teiid.jdbc.TeiidDriver cannot be cast to javax.sql.DataSource

Resolution

WebMethod's JDBC Connection setup is looking for a DataSource class not a driver class. In your WebMethod setup screen enter the org.teiid.jdbc.TeiidDataSource.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.