Works fine! Thanks, Marek.
Cheers, Krishna -----Original Message----- From: Marek Lange [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 9:16 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Multiple database connections > Does anybody have a sample Oracle-Service.xml for configuring multiple > databases as seperate datasources? This is for 3.2 (I think there was a minor change in the order (<attribute name="JndiName">) compared to the 3.0)): <server> <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=YourFirstDS"> <attribute name="JndiName">YourFirstDS</attribute> <depends optional-attribute-name="ManagedConnectionFactoryName"> <!--embedded mbean--> <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=YourFirstDS"> <attribute name="ManagedConnectionFactoryProperties"> <properties> <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@host:db</config-property> <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property> <config-property name="UserName" type="java.lang.String">username</config-property> <config-property name="Password" type="java.lang.String">password</config-property> </properties> </attribute> <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,n ame=JBoss LocalTransaction JDBC Wrapper</depends> </mbean> </depends> <depends optional-attribute-name="ManagedConnectionPool"> <!--embedded mbean--> <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=YourFirstDS"> <attribute name="MinSize">0</attribute> <attribute name="MaxSize">50</attribute> <attribute name="BlockingTimeoutMillis">5000</attribute> <attribute name="IdleTimeoutMinutes">15</attribute> <attribute name="Criteria">ByContainer</attribute> </mbean> </depends> <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedCo nnectionManager</depends> <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service= JaasSecurityManager</depends> <attribute name="TransactionManager">java:/TransactionManager</attribute> <depends>jboss.jca:service=RARDeployer</depends> </mbean> <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=YourSecondDS"> <attribute name="JndiName">YourSecondDS</attribute> <depends optional-attribute-name="ManagedConnectionFactoryName"> <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=YourSecondDS"> <attribute name="ManagedConnectionFactoryProperties"> <properties> <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@host:db</config-property> <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property> <config-property name="UserName" type="java.lang.String">username</config-property> <config-property name="Password" type="java.lang.String">password</config-property> </properties> </attribute> <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,n ame=JBoss LocalTransaction JDBC Wrapper</depends> </mbean> </depends> <depends optional-attribute-name="ManagedConnectionPool"> <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=YourSecondDS"> <attribute name="MinSize">0</attribute> <attribute name="MaxSize">50</attribute> <attribute name="BlockingTimeoutMillis">5000</attribute> <attribute name="IdleTimeoutMinutes">15</attribute> <attribute name="Criteria">ByContainer</attribute> </mbean> </depends> <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedCo nnectionManager</depends> <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service= JaasSecurityManager</depends> <attribute name="TransactionManager">java:/TransactionManager</attribute> <depends>jboss.jca:service=RARDeployer</depends> </mbean> </server> -marek ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
