[
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
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}
/*
* Copyright 2012-2017 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*
http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.veeam.esb.config;
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 bu 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)