[jboss-user] [JCA] - Re: Datasource Failover Notification

[mayankmit2002]

  | 
  | <datasources>
  | 	<ha-xa-datasource>
  | 	    <jndi-name>PostgresDS</jndi-name>
  | 	      <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
  | 	      <xa-datasource-property name="ServerName">${data.source}</xa-datasource-property>
  | 	      <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
  | 	      <xa-datasource-property name="DatabaseName">smd</xa-datasource-property>
  | 	      <!--xa-datasource-property name="Ssl">false</xa-datasource-property-->
  | 	      <xa-datasource-property name="User">systemmgr</xa-datasource-property>
  | 	      <xa-datasource-property name="Password">cms10</xa-datasource-property>
  | 	      <url-property>ServerName</url-property>       
  | 	      <url-delimiter>,</url-delimiter> 
  | 	      
  | 	      <track-connection-by-tx/>
  | 	
  | 	      <metadata>
  | 	         <type-mapping>PostgreSQL 8.0</type-mapping>
  | 	      </metadata>
  | 	
  | 	      <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 	      <min-pool-size>5</min-pool-size>
  | 	      <max-pool-size>20</max-pool-size>
  | 	      <max-idle-timeout>0</max-idle-timeout> 
  | 	      <blocking-timeout-millis>30000</blocking-timeout-millis>
  | 	      <idle-timeout-minutes>0</idle-timeout-minutes> 
  | 	      <track-statements>true</track-statements>
  | 	      <check-valid-connection-sql>select version()</check-valid-connection-sql>
  | 	</ha-xa-datasource>
  | 	
  | 	<ha-xa-datasource>
  | 	    <jndi-name>ArgusDS</jndi-name>
  | 	      <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
  | 	      <xa-datasource-property name="ServerName">${data.source}</xa-datasource-property>
  | 	      <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
  | 	      <xa-datasource-property name="DatabaseName">smd</xa-datasource-property>
  | 	      <!--xa-datasource-property name="Ssl">false</xa-datasource-property-->
  | 	      <xa-datasource-property name="User">systemmgr</xa-datasource-property>
  | 	      <xa-datasource-property name="Password">cms10</xa-datasource-property>
  | 	      <url-property>ServerName</url-property>   
  | 	      <url-delimiter>,</url-delimiter>
  | 	      
  | 	      <track-connection-by-tx/>
  | 	
  | 	      <metadata>
  | 	         <type-mapping>PostgreSQL 8.0</type-mapping>
  | 	      </metadata>
  | 	
  | 	      <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 	      <min-pool-size>5</min-pool-size>
  | 	      <max-pool-size>20</max-pool-size>
  | 	      <max-idle-timeout>0</max-idle-timeout> 
  | 	      <blocking-timeout-millis>30000</blocking-timeout-millis>
  | 	      <idle-timeout-minutes>0</idle-timeout-minutes> 
  | 	      <track-statements>true</track-statements>
  |               <check-valid-connection-sql>select version()</check-valid-connection-sql>
  | 	</ha-xa-datasource>
  | 	
  | 	<ha-xa-datasource>
  | 	    <jndi-name>DefaultDS</jndi-name>
  | 	      <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
  | 	      <xa-datasource-property name="ServerName">${data.source}</xa-datasource-property>
  | 	      <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
  | 	      <xa-datasource-property name="DatabaseName">jms</xa-datasource-property>
  | 	      <!--xa-datasource-property name="Ssl">false</xa-datasource-property-->
  | 	      <xa-datasource-property name="User">systemmgr</xa-datasource-property>
  | 	      <xa-datasource-property name="Password">cms10</xa-datasource-property>
  | 	      <url-property>ServerName</url-property>   
  | 	      <url-delimiter>,</url-delimiter>
  | 
  | 	      <track-connection-by-tx/>
  | 	
  | 	      <metadata>
  | 	         <type-mapping>PostgreSQL 8.0</type-mapping>
  | 	      </metadata>
  | 	
  | 	      <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 	      <min-pool-size>5</min-pool-size>
  | 	      <max-pool-size>20</max-pool-size>
  | 	      <max-idle-timeout>0</max-idle-timeout> 
  | 	      <blocking-timeout-millis>30000</blocking-timeout-millis>
  | 	      <idle-timeout-minutes>0</idle-timeout-minutes> 
  | 	      <track-statements>true</track-statements>
  |               <check-valid-connection-sql>select version()</check-valid-connection-sql>
  | 	</ha-xa-datasource>
  | 	
  |         <ha-xa-datasource>
  | 	    <jndi-name>BMSDS</jndi-name>
  | 	      <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
  | 	      <xa-datasource-property name="ServerName">${data.source}</xa-datasource-property>
  | 	      <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
  | 	      <xa-datasource-property name="DatabaseName">bms</xa-datasource-property>
  | 	      <xa-datasource-property name="User">systemmgr</xa-datasource-property>
  | 	      <xa-datasource-property name="Password">cms10</xa-datasource-property>
  | 	      <url-property>ServerName</url-property>   
  | 	      <url-delimiter>,</url-delimiter>
  | 
  | 	      <track-connection-by-tx/>
  | 	
  | 	      <metadata>
  | 	         <type-mapping>PostgreSQL 8.0</type-mapping>
  | 	      </metadata>
  | 	
  | 	      <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 	      <min-pool-size>5</min-pool-size>
  | 	      <max-pool-size>20</max-pool-size>
  | 	      <max-idle-timeout>0</max-idle-timeout> 
  | 	      <blocking-timeout-millis>30000</blocking-timeout-millis>
  | 	      <idle-timeout-minutes>0</idle-timeout-minutes> 
  | 	      <track-statements>true</track-statements>
  |               <check-valid-connection-sql>select version()</check-valid-connection-sql>
  | 	</ha-xa-datasource>
  | 	
  | </datasources>
  | 
  | 
  | 

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262395#4262395

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4262395