[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
[
https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin...
]
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)