You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tuscany.apache.org by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org> on 2007/09/14 09:10:34 UTC

[jira] Created: (TUSCANY-1698) Changes in DAS Config to support authenticated connection using data source

Changes in DAS Config to support authenticated connection using data source
---------------------------------------------------------------------------

                 Key: TUSCANY-1698
                 URL: https://issues.apache.org/jira/browse/TUSCANY-1698
             Project: Tuscany
          Issue Type: Improvement
          Components: Java DAS RDB
    Affects Versions: Java-DAS-Next
            Reporter: Amita Vadhavkar
            Assignee: Amita Vadhavkar
             Fix For: Java-DAS-Next


 in RDB-DAS, when we use external DataSource, we do not  pass  userName, password. But MySQL (which with InnoDB supports Txn and works well  with JOTM) does need id, pwd in ds.getConnection(). This can be case with  other DBs as well. 

 So, it looks like DAS config.xsd needs to allow passing userName, password  in ConnectionInfo too ( and not just for ConnectionProperties).

 Thus below will be the changed DAS config portion:-
    <xsd:complexType name="ConnectionInfo">
       <xsd:sequence>
         <xsd:element  maxOccurs="1" minOccurs="0"  name="ConnectionProperties" type="config:ConnectionProperties"/>
       </xsd:sequence>
       <xsd:attribute name="dataSource" type="xsd:string"/>
       <xsd:attribute name="managedtx" type="xsd:boolean" default="true"/>
       <xsd:attribute name="userName" type="xsd:string" default=""/>
       <xsd:attribute name="password" type="xsd:string" default=""/>
    </xsd:complexType>

    <xsd:complexType name="ConnectionProperties">
          <xsd:attribute name="driverClass" type="xsd:string"/>
          <xsd:attribute name="databaseURL" type="xsd:string"/>
          <xsd:attribute name="loginTimeout" type="xsd:int"  default="0"/>
    </xsd:complexType>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Reopened: (TUSCANY-1698) Changes in DAS Config to support authenticated connection using data source

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/TUSCANY-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amita Vadhavkar reopened TUSCANY-1698:
--------------------------------------


changing database, JNDI provider.



> Changes in DAS Config to support authenticated connection using data source
> ---------------------------------------------------------------------------
>
>                 Key: TUSCANY-1698
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1698
>             Project: Tuscany
>          Issue Type: Improvement
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-Next
>            Reporter: Amita Vadhavkar
>            Assignee: Amita Vadhavkar
>             Fix For: Java-DAS-Next
>
>         Attachments: 1698.patch
>
>
>  in RDB-DAS, when we use external DataSource, we do not  pass  userName, password. But MySQL (which with InnoDB supports Txn and works well  with JOTM) does need id, pwd in ds.getConnection(). This can be case with  other DBs as well. 
>  So, it looks like DAS config.xsd needs to allow passing userName, password  in ConnectionInfo too ( and not just for ConnectionProperties).
>  Thus below will be the changed DAS config portion:-
>     <xsd:complexType name="ConnectionInfo">
>        <xsd:sequence>
>          <xsd:element  maxOccurs="1" minOccurs="0"  name="ConnectionProperties" type="config:ConnectionProperties"/>
>        </xsd:sequence>
>        <xsd:attribute name="dataSource" type="xsd:string"/>
>        <xsd:attribute name="managedtx" type="xsd:boolean" default="true"/>
>        <xsd:attribute name="userName" type="xsd:string" default=""/>
>        <xsd:attribute name="password" type="xsd:string" default=""/>
>     </xsd:complexType>
>     <xsd:complexType name="ConnectionProperties">
>           <xsd:attribute name="driverClass" type="xsd:string"/>
>           <xsd:attribute name="databaseURL" type="xsd:string"/>
>           <xsd:attribute name="loginTimeout" type="xsd:int"  default="0"/>
>     </xsd:complexType>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Updated: (TUSCANY-1698) Changes in DAS Config to support authenticated connection using data source

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/TUSCANY-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amita Vadhavkar updated TUSCANY-1698:
-------------------------------------

    Attachment: 1698.patch

Changed files:-

*rdb/pom.xml

*distribution/binary/pom.xml
*distribution/binary/src/main/assembly/das.xml
*rdb/src/test/java/org/apache/tuscany/das/rdb/test/ConnectionTests.java

*rdb/src/test/resources/connectionInfoDataSourceAuth.xml

*samples/pom.xml
*samples/Readme.htm 
*samples/dbconfig/readm.htm

*deleted - sample-dataSource

> Changes in DAS Config to support authenticated connection using data source
> ---------------------------------------------------------------------------
>
>                 Key: TUSCANY-1698
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1698
>             Project: Tuscany
>          Issue Type: Improvement
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-Next
>            Reporter: Amita Vadhavkar
>            Assignee: Amita Vadhavkar
>             Fix For: Java-DAS-Next
>
>         Attachments: 1698.patch
>
>
>  in RDB-DAS, when we use external DataSource, we do not  pass  userName, password. But MySQL (which with InnoDB supports Txn and works well  with JOTM) does need id, pwd in ds.getConnection(). This can be case with  other DBs as well. 
>  So, it looks like DAS config.xsd needs to allow passing userName, password  in ConnectionInfo too ( and not just for ConnectionProperties).
>  Thus below will be the changed DAS config portion:-
>     <xsd:complexType name="ConnectionInfo">
>        <xsd:sequence>
>          <xsd:element  maxOccurs="1" minOccurs="0"  name="ConnectionProperties" type="config:ConnectionProperties"/>
>        </xsd:sequence>
>        <xsd:attribute name="dataSource" type="xsd:string"/>
>        <xsd:attribute name="managedtx" type="xsd:boolean" default="true"/>
>        <xsd:attribute name="userName" type="xsd:string" default=""/>
>        <xsd:attribute name="password" type="xsd:string" default=""/>
>     </xsd:complexType>
>     <xsd:complexType name="ConnectionProperties">
>           <xsd:attribute name="driverClass" type="xsd:string"/>
>           <xsd:attribute name="databaseURL" type="xsd:string"/>
>           <xsd:attribute name="loginTimeout" type="xsd:int"  default="0"/>
>     </xsd:complexType>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Resolved: (TUSCANY-1698) Changes in DAS Config to support authenticated connection using data source

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/TUSCANY-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amita Vadhavkar resolved TUSCANY-1698.
--------------------------------------

    Resolution: Fixed

With all the discussion under [DAS] DAS Samples, it is decided to remove sample dataSource and any test cases which can add
dependencies on jars having licensing issues. Instead explain the feature in detail in user guide.

Code changes for this are checked in under revision 595223 for this.

> Changes in DAS Config to support authenticated connection using data source
> ---------------------------------------------------------------------------
>
>                 Key: TUSCANY-1698
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1698
>             Project: Tuscany
>          Issue Type: Improvement
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-Next
>            Reporter: Amita Vadhavkar
>            Assignee: Amita Vadhavkar
>             Fix For: Java-DAS-Next
>
>         Attachments: 1698.patch
>
>
>  in RDB-DAS, when we use external DataSource, we do not  pass  userName, password. But MySQL (which with InnoDB supports Txn and works well  with JOTM) does need id, pwd in ds.getConnection(). This can be case with  other DBs as well. 
>  So, it looks like DAS config.xsd needs to allow passing userName, password  in ConnectionInfo too ( and not just for ConnectionProperties).
>  Thus below will be the changed DAS config portion:-
>     <xsd:complexType name="ConnectionInfo">
>        <xsd:sequence>
>          <xsd:element  maxOccurs="1" minOccurs="0"  name="ConnectionProperties" type="config:ConnectionProperties"/>
>        </xsd:sequence>
>        <xsd:attribute name="dataSource" type="xsd:string"/>
>        <xsd:attribute name="managedtx" type="xsd:boolean" default="true"/>
>        <xsd:attribute name="userName" type="xsd:string" default=""/>
>        <xsd:attribute name="password" type="xsd:string" default=""/>
>     </xsd:complexType>
>     <xsd:complexType name="ConnectionProperties">
>           <xsd:attribute name="driverClass" type="xsd:string"/>
>           <xsd:attribute name="databaseURL" type="xsd:string"/>
>           <xsd:attribute name="loginTimeout" type="xsd:int"  default="0"/>
>     </xsd:complexType>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Resolved: (TUSCANY-1698) Changes in DAS Config to support authenticated connection using data source

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/TUSCANY-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amita Vadhavkar resolved TUSCANY-1698.
--------------------------------------

    Resolution: Fixed

ML thread - http://www.mail-archive.com/tuscany-dev@ws.apache.org/msg25244.html

Files changes under revision - 591886 -
distribution/binary/pom.xml
distribution/binary/src/main/assembly/das.xml
rdb/src/main/java/org/apache/tuscany/das/rdb/impl/DASImpl.java
rdb/src/test/java/org/apache/tuscany/das/rdb/test/ConnectionTests.java
rdb/src/test/java/org/apache/tuscany/das/rdb/test/GraphMergeTests.java
rdb/src/test/java/org/apache/tuscany/das/rdb/test/suites/AllCommonTests.java
rdb/src/test/resources/connectionInfoDriverManagerAuth.xml
rdb/src/test/resources/connectionInfoDriverManagerNoAuth.xml
samples/dataSource
samples/dataSource/build.xml
samples/dataSource/pom.xml
samples/dataSource/readme.htm
samples/dbconfig/src/main/java/org/apache/tuscany/das/rdb/dbconfig/DBConnectionHelper.java
samples/dbconfig/src/main/java/org/apache/tuscany/das/rdb/dbconfig/DBHelper.java
samples/pom.xml
samples/Readme.htm


> Changes in DAS Config to support authenticated connection using data source
> ---------------------------------------------------------------------------
>
>                 Key: TUSCANY-1698
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1698
>             Project: Tuscany
>          Issue Type: Improvement
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-Next
>            Reporter: Amita Vadhavkar
>            Assignee: Amita Vadhavkar
>             Fix For: Java-DAS-Next
>
>
>  in RDB-DAS, when we use external DataSource, we do not  pass  userName, password. But MySQL (which with InnoDB supports Txn and works well  with JOTM) does need id, pwd in ds.getConnection(). This can be case with  other DBs as well. 
>  So, it looks like DAS config.xsd needs to allow passing userName, password  in ConnectionInfo too ( and not just for ConnectionProperties).
>  Thus below will be the changed DAS config portion:-
>     <xsd:complexType name="ConnectionInfo">
>        <xsd:sequence>
>          <xsd:element  maxOccurs="1" minOccurs="0"  name="ConnectionProperties" type="config:ConnectionProperties"/>
>        </xsd:sequence>
>        <xsd:attribute name="dataSource" type="xsd:string"/>
>        <xsd:attribute name="managedtx" type="xsd:boolean" default="true"/>
>        <xsd:attribute name="userName" type="xsd:string" default=""/>
>        <xsd:attribute name="password" type="xsd:string" default=""/>
>     </xsd:complexType>
>     <xsd:complexType name="ConnectionProperties">
>           <xsd:attribute name="driverClass" type="xsd:string"/>
>           <xsd:attribute name="databaseURL" type="xsd:string"/>
>           <xsd:attribute name="loginTimeout" type="xsd:int"  default="0"/>
>     </xsd:complexType>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org