[teiid-issues] [JBoss JIRA] Commented: (TEIID-701) Provide a single JDBC driver for "embedded" and "server" configurations

[Ramesh Reddy (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12475824#action_12475824 ] 

Ramesh Reddy commented on TEIID-701:
------------------------------------

TeiidDriver has been modified to support the embedded's URL format. 

Now based on the incoming URL format from the user in the Teiid connect string, the Teiid JDBC protocol can be invoked to connect to a server though socket connection or in a embedded mode.

The both support forms of URL are  

Server --> jdbc:teiid:<vdb>@mm://<host>:<port>;user=<user>;password=<password>
Embedded --> jdbc:teiid:<vdb>@<path-to>/deploy.properties;user=<user>;password=<password>

Also, the TeiidDataSource is now also supports the connections to "embedded" runtime. "setEmbeddedBootStrapFile" and "getEmbeddedBootStrapFile" methods have been added on the data source class, which will supply the location of the "deploy.properties". When value for this property is set on the datasource then this data source will try to invoke the "embedded" connection, otherwise it will try to invoke the connection through socket.

> Provide a single JDBC driver for "embedded" and "server" configurations
> -----------------------------------------------------------------------
>
>                 Key: TEIID-701
>                 URL: https://jira.jboss.org/jira/browse/TEIID-701
>             Project: Teiid
>          Issue Type: Task
>          Components: JDBC Driver
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 6.2.0
>
>
> Currently there are separate JDBC drivers for
> Embedded --> com.metamatrix.jdbc.EmbeddedDriver
> Server --> org.teiid.jdbc.TeiidDriver
> Combine the EmbeddedDriver functionality into TeiidDriver. Based on its URL format differentiate which runtime user wants to use. The URLs for runtimes are as follows
> Embedded ---> jdbc:metamatrix:<vdb-name>@<path-to>/deploy.properties;<additional-properties>
> Server         ---> jdbc:teiid:<vdb-name>@mm://<host-name>:<port>;<additional-properties>
> 1) Deprecate EmbeddedDriver
> 2) Make  embedded URL format to work with " jdbc:teiid:<vdb-name>@<path-to>/deploy.properties;<additional-properties>" (note s/mematrix/teiid/)
> 3) Make the TeiidDriver the only driver.
> Investigate if EmbeddedDataSource and TeiidDataSource can be combined, if true follow the same path.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira