[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
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)
1866
days inactive
1866
days old
0 comments
1 participants
tags (0)
participants (1)
-
Renat Eskenin (Jira)