[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
Renat Eskenin (Jira)
issues at jboss.org
Thu Nov 14 07:55:00 EST 2019
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13813042#comment-13813042 ]
Renat Eskenin commented on TEIID-5848:
--------------------------------------
A try another way and get this error.
org.teiid.jdbc.TeiidSQLException: Teiid Embedded mode Driver failed to load. You must only create this type of connection in the same VM as the Teiid Server. Use following driver fragment xml inside the JBoss AS configuration file<drivers><driver name="teiid-local" module="org.jboss.teiid"><driver-class>org.teiid.jdbc.TeiidDriver</driver-class><xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class></driver> </drivers>
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName("spring");
try {
Connection connection = ds.getConnection();
Statement statement = connection.createStatement();
ResultSet results = statement.executeQuery("SELECT * FROM funnel_leads LIMIT 1");
results.close();
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
> views in vertica not found by teiid
> -----------------------------------
>
> Key: TEIID-5848
> URL: https://issues.jboss.org/browse/TEIID-5848
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> We created view in vertica DB
> Example project with vertica translator+odata not found this view
> {code}
> src 1 Varchar 4 [NULL] true false false [NULL] false [NULL]
> src_id 2 Varchar 18 [NULL] true false false [NULL] false [NULL]
> src_name 3 Varchar 363 [NULL] true false false [NULL] false [NULL]
> account_id 4 Varchar 18 [NULL] true false false [NULL] false [NULL]
> name 5 Varchar 765 [NULL] true false false [NULL] false [NULL]
> billing_country 6 Varchar 240 [NULL] true false false [NULL] false [NULL]
> root_domain 7 Varchar 192 [NULL] true false false [NULL] false [NULL]
> sales_team 8 Varchar 240 [NULL] true false false [NULL] false [NULL]
> {code}
> {
> "error": {
> "code": null,
> "message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'funnel_leads'."
> }
> }
> But regular tables works properly
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list