[teiid-issues] [JBoss JIRA] (TEIID-5848) views in vertica not found by teiid

[Renat Eskenin (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)