[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5848:
---------------------------------------
For a source view to be visible over odata it needs to have a unique/primary key - is there one indicated by vertica?
> How i can create connection?
The log message indicates that this is before ENTESB-11662 which should try to bind to localhost by default. After that change it will bind to 0.0.0.0 by default - which should be the preferred interface. Is it possible to test against a later version as you are also able to explicitly set the host name that way.
> A try another way and get this error.
That is effectively trying to make an embedded connection. That will not work from a separate vm. In the same spring vm you should use autowiring of the main datasource to get an embedded connection to Teiid.
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5848 at 11/14/19 6:06 AM:
----------------------------------------------------------------
I try to use teiid.jdbc-enable=true
Server started
[2019-11-14 13:57:02,976 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: Starting Teiid Server.
[2019-11-14 13:57:03,366 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: JDBC Port is opened on :31000
[2019-11-14 13:57:03,501 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40118 VDB spring.1.0.0 added to the repository
[2019-11-14 13:57:03,505 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40003 VDB spring.1.0.0 is set to ACTIVE
[2019-11-14 13:57:03,596 MSK] INFO [vertica-odata-facade,,,] o.s.jdbc.datasource.embedded.EmbeddedDatabaseFactory [restartedMain]: Starting embedded database: url='jdbc:teiid:spring;PassthroughAuthentication=true;useCallingThread=true;autoFailover=true;waitForLoad=5000;autoCommitTxn=OFF;disableLocalTxn=true', username='null'
[2019-11-14 13:57:03,731 MSK] INFO [vertica-odata-facade,,,] org.hibernate.jpa.internal.util.LogHelper [restartedMain]: HHH000204: Processing PersistenceUnitInfo [
but i get connection refused
from jdbc urls
jdbc:teiid:spring@mm://localhost:31000
or
jdbc:teiid:vertica@mm://localhost:31000
Used driver org.teiid.jdbc.TeiidDriver
How i can create connection?
was (Author: i3draven):
I try to use teiid.jdbc-enable=true
Server started
[2019-11-14 13:57:02,976 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: Starting Teiid Server.
[2019-11-14 13:57:03,366 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: JDBC Port is opened on :31000
[2019-11-14 13:57:03,501 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40118 VDB spring.1.0.0 added to the repository
[2019-11-14 13:57:03,505 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40003 VDB spring.1.0.0 is set to ACTIVE
[2019-11-14 13:57:03,596 MSK] INFO [vertica-odata-facade,,,] o.s.jdbc.datasource.embedded.EmbeddedDatabaseFactory [restartedMain]: Starting embedded database: url='jdbc:teiid:spring;PassthroughAuthentication=true;useCallingThread=true;autoFailover=true;waitForLoad=5000;autoCommitTxn=OFF;disableLocalTxn=true', username='null'
[2019-11-14 13:57:03,731 MSK] INFO [vertica-odata-facade,,,] org.hibernate.jpa.internal.util.LogHelper [restartedMain]: HHH000204: Processing PersistenceUnitInfo [
but i get connection refused
from jdbc urls
jdbc:teiid:spring@mm://localhost:31000
or
jdbc:teiid:vertica@mm://localhost:31000
Used driver org.teiid.jdbc.TeiidDriver
What i can create connection?
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5848:
--------------------------------------
I try to use teiid.jdbc-enable=true
Server started
[2019-11-14 13:57:02,976 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: Starting Teiid Server.
[2019-11-14 13:57:03,366 MSK] INFO [vertica-odata-facade,,,] org.teiid.spring.autoconfigure.TeiidAutoConfiguration [restartedMain]: JDBC Port is opened on :31000
[2019-11-14 13:57:03,501 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40118 VDB spring.1.0.0 added to the repository
[2019-11-14 13:57:03,505 MSK] INFO [vertica-odata-facade,,,] org.teiid.RUNTIME.VDBLifeCycleListener [restartedMain]: TEIID40003 VDB spring.1.0.0 is set to ACTIVE
[2019-11-14 13:57:03,596 MSK] INFO [vertica-odata-facade,,,] o.s.jdbc.datasource.embedded.EmbeddedDatabaseFactory [restartedMain]: Starting embedded database: url='jdbc:teiid:spring;PassthroughAuthentication=true;useCallingThread=true;autoFailover=true;waitForLoad=5000;autoCommitTxn=OFF;disableLocalTxn=true', username='null'
[2019-11-14 13:57:03,731 MSK] INFO [vertica-odata-facade,,,] org.hibernate.jpa.internal.util.LogHelper [restartedMain]: HHH000204: Processing PersistenceUnitInfo [
but i get connection refused
from jdbc urls
jdbc:teiid:spring@mm://localhost:31000
or
jdbc:teiid:vertica@mm://localhost:31000
Used driver org.teiid.jdbc.TeiidDriver
What i can create connection?
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5798?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5798:
-------------------------------------
my vote is to be consistent with other vendors, even though it is breaking change. Since we are placing this data security gateway I would prefer we go this route.
> Mixed PERMISSION GRANTS
> -----------------------
>
> Key: TEIID-5798
> URL: https://issues.jboss.org/browse/TEIID-5798
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
> Original Estimate: 6 hours
> Remaining Estimate: 6 hours
>
> Hello,
> I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT.
> However, it seems that conditioned and unconditioned GRANT statements do not work together.
> {code}
> GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata;
> GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata;
> REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata;
> {code}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5848:
-------------------------------------
https://github.com/teiid/teiid-documents/blob/master/client-dev/Driver_Co...
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5848:
--------------------------------------
Please send me url to doc. And i will try to use teiid.jdbc-enable=true and try ti connect (on mu localhost i can start project).
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5848:
-------------------------------------
Not sure how you are running above, if it is just local VM, add a property `teiid.jdbc-enable=true" then it will open up a JDBC port on 31000. The you can use Teiid JDBC driver to connect to the VDB. See docs for the URL etc.
If the View is showing there not in OData that means there is no PK or Unique key on the View this it can not be exposed
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5848 at 11/14/19 5:19 AM:
----------------------------------------------------------------
I do not tested this behavior with jdbc client, sorry. I call
https://staging.com/vertica-odata-facade/odata/vertica/funnel_leads?%24to...
And got error.
How to fast add jdbc interface to this project?|
Or you mean i need to call simple select from app?
was (Author: i3draven):
I do not tested this behavior with jdbc client, sorry. I call
https://staging.com/vertica-odata-facade/odata/vertica/funnel_leads?%24to...
And got error.
How to fast add jdbc interface to this project?
> 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)
5 years, 1 month
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5848:
--------------------------------------
I do not tested this behavior with jdbc client, sorry. I call
https://staging.com/vertica-odata-facade/odata/vertica/funnel_leads?%24to...
And got error.
How to fast add jdbc interface to this project?
> 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)
5 years, 1 month