[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
Renat Eskenin (Jira)
issues at jboss.org
Thu Nov 14 06:07:00 EST 2019
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13812973#comment-13812973 ]
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 at mm://localhost:31000
or
jdbc:teiid:vertica at 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)
More information about the teiid-issues
mailing list