[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:comment-tabpanel&focusedCommentId=13813042#comment-13813042 ] 

Renat Eskenin commented on TEIID-5848:
--------------------------------------

A try another way and get this error.

org.teiid.jdbc.TeiidSQLException: Teiid Embedded mode Driver failed to load. You must only create this type of connection in the same VM as the Teiid Server. Use following driver fragment xml inside the JBoss AS configuration file<drivers><driver name="teiid-local" module="org.jboss.teiid"><driver-class>org.teiid.jdbc.TeiidDriver</driver-class><xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class></driver> </drivers>

TeiidDataSource ds = new TeiidDataSource();
		ds.setDatabaseName("spring");		 
		try {
			Connection connection = ds.getConnection();
			 
			Statement statement = connection.createStatement();
		        ResultSet results = statement.executeQuery("SELECT * FROM funnel_leads LIMIT 1");
		        
		        results.close();
		        statement.close();
		        
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

> 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)