2 Replies Latest reply: Nov 20, 2012 6:30 AM by Rohan Dekate RSS

    ATG

    967909
      Hi frnds

      what is the main difference between FakeXaDataSource and XaDataSource in atg
        • 1. Re: ATG
          Samdani Gulam
          you might want to see the API docs of FakeXADataSource.
          http://docs.oracle.com/cd/E26180_01/Platform.94/apidoc/atg/service/jdbc/FakeXADataSource.html

          And here is the documentation for configuration
          http://docs.oracle.com/cd/E23507_01/Service.20073/ATGServiceInstallGuide/html/s0506configuringfakexadatasourcefiles01.html


          FakeXADataSource is OOTB in which you can give all the credentials and configuration for the properties like url or hostname. While XADatasource is provided by Java API for the DataSource which will be registed to the service in JNDI, for an instance using jboss as an application server and using the XADataSource you can configure in the atg-ds.xml file. refer to this link
          http://docs.oracle.com/cd/E23507_01/Platform.20073/ATGInstallGuide/html/s0408configuringdatasourcesforjboss01.html

          And some useful links for reference
          http://www.techfaq360.com/tutorial/jdbc/datasource.jsp
          http://world-of-atg.blogspot.com/#!/2012/07/using-startsqlrepository-beginners-iv.html
          • 2. Re: ATG
            Rohan Dekate
            Hi 964906,
            Samdani Gulam is absolutely right about the question .

            To add In more simple words XADatasource is use when you have to deal with 2 or more database or when you have to do Distributed Transaction.
            FakeXaDatasource is use when you are dealing with single database or when you are not using distributed transaction. Two-phase commits are NOT supported in FakeXaDatasource
            SO What contain in XADatasource..properties and fakeXADatasource.properties file
            If you check the definition of datasource it says Datasource is a name given to the connection set up to a database from a server. So in .properties file we give the details to connect the database .
            FakeXadatasource.properties file

            driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

            URL=jdbc:sqlserver://mymachinename;
            databaseName=atg10core;
            sendStringParametersAsUnicode=false;
            user=atg
            password=******

            So because of these details we say ATG Repository API is DataAnyWhere architecture.
            Hope it helps :)