Skip to content

Instantly share code, notes, and snippets.

@ejlp12

ejlp12/JDV_Teiid PREVIEW Data Source is not available.md

Last active October 23, 2015 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ejlp12/e275dc3c06cb19a7357e to your computer and use it in GitHub Desktop.
Save ejlp12/e275dc3c06cb19a7357e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
JDV_Teiid PREVIEW Data Source is not available.md

When trying to preview a source/view model, the data source is not created with error:

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: 
Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SOURCE_MODEL_NAME were not avaialable.  
The command could not be planned properly.

and found in the Teiid log something like:

20:49:44,159 INFO  [org.teiid.RUNTIME] (MSC service thread 1-7) Data Source PREVIEW_dbddb3d1-32c2-46c9-a88a-b433fd2fe06d_xxx_yyy_SOURCE_MODEL_NAME not accessible.

it migh be because of your jdbc driver file (JAR) is not comply with JDBC 4.0 Driver spec, which should include file META-INF/services/java.sql.Driver inside the JAR file.

So Teiid/JDV runtime does not find the driver class.

If you are using JBDS 8.1, removing Connection Profile of a Source Model and then set the Connection Profile again might not change the location of JDBC JAR file. I think this is a bug. What you need to do is to open the XMI file using text editor and change the location of JDBC JAR file manually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment