This discussion is archived
2 Replies Latest reply: Nov 20, 2012 4:30 AM by RohanDekate RSS

ATG

967909 Explorer
Currently Being Moderated
Hi frnds

what is the main difference between FakeXaDataSource and XaDataSource in atg
  • 1. Re: ATG
    samdani.gulam Journeyer
    Currently Being Moderated
    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
    RohanDekate Newbie
    Currently Being Moderated
    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 :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points