3 Replies Latest reply: Jan 25, 2013 2:27 AM by Rajeev_R RSS

    orcle atg ds file

    967909
      Hi guys


      <?xml version="1.0" encoding="UTF-8"?>
      <datasources>
      <!-- @version $Id: //product/CIM/version/10.1.1/plugins/Base/filetemplate/jboss-open-ds.xml#1 $$Change: 690623 $-->

      <xa-datasource>
      <jndi-name>ATGProductionDS</jndi-name>
      <isSameRM-override-value>false</isSameRM-override-value>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      <xa-datasource-property name="URL">jdbc:oracle:thin:@172.21.31.15:1521:VRZNDB</xa-datasource-property>
      <xa-datasource-property name="User">VZ_DEV_CORE</xa-datasource-property>
      <xa-datasource-property name="Password">verizon</xa-datasource-property>
      <!-- Uncomment the following if you are using Oracle 9i
      <xa-datasource-property name="oracle.jdbc.V8Compatible">true</xa-datasource-property>
      -->
      <exception-sorter-class-name>
      org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
      </exception-sorter-class-name>
      </xa-datasource>
      <!-- @version $Id: //product/CIM/version/10.1.1/plugins/Base/filetemplate/jboss-oraclethin-xa-ds.xml#1 $$Change: 690623 $-->

      <xa-datasource>
      <jndi-name>ATGSwitchingDS_B</jndi-name>
      <isSameRM-override-value>false</isSameRM-override-value>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      <xa-datasource-property name="URL">jdbc:oracle:thin:@172.21.31.15:1521:VRZNDB</xa-datasource-property>
      <xa-datasource-property name="User">VZ_DEV_CAT_B</xa-datasource-property>
      <xa-datasource-property name="Password">verizon</xa-datasource-property>
      <!-- Uncomment the following if you are using Oracle 9i
      <xa-datasource-property name="oracle.jdbc.V8Compatible">true</xa-datasource-property>
      -->
      <exception-sorter-class-name>
      org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
      </exception-sorter-class-name>
      </xa-datasource>
      <!-- @version $Id: //product/CIM/version/10.1.1/plugins/Base/filetemplate/jboss-oraclethin-xa-ds.xml#1 $$Change: 690623 $-->

      <xa-datasource>
      <jndi-name>ATGSwitchingDS_A</jndi-name>
      <isSameRM-override-value>false</isSameRM-override-value>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      <xa-datasource-property name="URL">jdbc:oracle:thin:@172.21.31.15:1521:VRZNDB</xa-datasource-property>
      <xa-datasource-property name="User">VZ_DEV_CAT_A</xa-datasource-property>
      <xa-datasource-property name="Password">verizon</xa-datasource-property>
      <!-- Uncomment the following if you are using Oracle 9i
      <xa-datasource-property name="oracle.jdbc.V8Compatible">true</xa-datasource-property>
      -->
      <exception-sorter-class-name>
      org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
      </exception-sorter-class-name>
      </xa-datasource>
      <!-- @version $Id: //product/CIM/version/10.1.1/plugins/Base/filetemplate/jboss-oraclethin-xa-ds.xml#1 $$Change: 690623 $-->

      </datasources>
      <!-- @version $Id: //product/CIM/version/10.1.1/plugins/Base/filetemplate/jboss-close-ds.xml#1 $$Change: 690623 $-->


      why we need to create these many data sources how these work give me an example
        • 1. Re: orcle atg ds file
          Gautam Singh
          This is a configuration for switching datasources. ATG uses switching datasources concept where on publishing they publish the content on an offline datsource first and then switches the live datasource to point to offline datasouce and then publish on other dataasource. The benefit is, publishing can be very resource incentive at times, resulting in multiple queries and can sometime swamp databases, this way the end user won't get affected by these heavy load DB operations.
          In your configuration
          ATGProductionDS is datasource for core database. All the repository which are not managed through publishing use this datsource, like ProfileAdapterRepository
          ATGSwitchingDS_A and ATGSwitchingDS_B are 2 switch datasources.

          Refer Repository guide for details about switch datasource
          http://docs.oracle.com/cd/E26180_01/Platform.94/ATGInstallGuide/html/s0412switchingdatabases01.html
          • 2. Re: orcle atg ds file
            967909
            Why we have to use publishing ds and how these four are different

            give me clear picture and what is producton ds and switchingds 2 switchingds 1

            how these are interdependent each other
            • 3. Re: orcle atg ds file
              Rajeev_R
              Publishing DS is which your versioned repository points i.e Catalog Data, Basic CA data etc. Using BCC when you deploy these assets it will deploy to the Switching DS 1 and 2. Both these schemas are exactly same; the purpose of this was already expalined in the previous post.

              I guess here you meant by production DS is the core ds which all transactional data will remain persisted like User, order data etc.

              Hope this gives u a clear picture

              R

              Edited by: Rajeev_R on Jan 25, 2013 12:27 AM