[
https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin...
]
Renat Eskenin commented on TEIID-5848:
--------------------------------------
In our view we have ids from background table is src_id (i wrote this view columns
before).
I try to use select to teiid embed db.
{code:java}
Connection connection = ds.getConnection();
Statement statement = connection.createStatement();
ResultSet results = statement.executeQuery("SELECT * FROM funnel_leads LIMIT
1");
while (results.next()) {
System.out.println(results.getString(1));
System.out.println(results.getString(2));
}
results.close();
statement.close();
{code}
And get the result! :) External JDBC connection with property teiid.host-name=127.0.0.1 do
not working too. But how to get this result in odata request?
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)