[
https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin...
]
Renat Eskenin updated TEIID-5848:
---------------------------------
Steps to Reproduce:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite
otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
View not found in teiid odata
was:
Project properties
spring.datasource.vertica.jdbc-url=jdbc:vertica://vertica:5433/db?SearchPath=bi
spring.datasource.vertica.username=
spring.datasource.vertica.password=
spring.datasource.vertica.driver-class-name=com.vertica.jdbc.Driver
spring.datasource.vertica.platform=vertica
spring.datasource.vertica.importer.SchemaName=bi
spring.datasource.vertica.importer.DatabaseTimeZone=UTC
spring.datasource.vertica.importer.UseFullSchemaName=false
spring.teiid.model.package=com.model
#when init scripts are defined below property is needed as Hibernate will overwrite
otherwise
spring.jpa.hibernate.ddl-auto=none
logging.level.org.teiid=INFO
spring.main.allow-bean-definition-overriding=true
Datasource
{code:java}
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.teiid.spring.autoconfigure.MultiDataSourceTransactionManagement;
@Configuration
public class DataSources extends MultiDataSourceTransactionManagement {
@ConfigurationProperties(prefix = "spring.datasource.vertica")
@Bean
public DataSource vertica() {
return DataSourceBuilder.create().build();
}
}
{code}
used dependencies
spring-odata
teiid-spring-boot-starter
vertica-jdbc
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}
--
This message was sent by Atlassian Jira
(v7.13.8#713008)