[TUSCANY-1698] Changes in DAS Config to support authenticated connection using data source

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Java-DAS-Next
• Fix Version/s: Java-DAS-Next
• Component/s: Java DAS RDB
• Assignee: Amita Vadhavkar
• Reporter: Amita Vadhavkar
• Created: 14/Sep/07 07:09
• Updated: 19/Sep/10 11:27
• Resolved: 15/Nov/07 13:37

Description

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>