5 Replies Latest reply: Oct 12, 2012 10:10 AM by Samdani Gulam RSS

    Data Base Interaction

    966835
      Hi
      i wolud like to interact with oracle database in atg so i created one ds file that is xml file after creation of ds file where i have to register that ds file in order to interact with data base in atg
        • 1. Re: Data Base Interaction
          RMishra
          Suppose you have student.xml file. then you have to create StudentAdapterRepository.properties file like

          StudentAdapterRepository.properties
          class=atg.adapter.gsa.GSARepository
          dataSource=JTDataSource
          definitionFiles=student.xml

          in JTDataSource.properties file you will have:
          dataSource=FakeXADataSource

          In FakeXADataSource.properties you will have:
          class=FakeXADataSource
          URL=....................
          user=yourdatabaseusername
          password=yourdatabasepass

          check document for proper sentence.

          Hope it helps.
          -RMishra

          Edited by: RMishra on Oct 12, 2012 4:53 PM
          • 2. Re: Data Base Interaction
            966835
            how it identify my dssource.xml file
            • 3. Re: Data Base Interaction
              RMishra
              In StudentAdapterRepository we are giving property as definitionFiles=student.xml, so in place of student.xml you can put your xml definiton file with full path relative to config folder. suppose your .xml file is in config/student/student.xml so use
              definitionFiles=/student/student.xml
              -RMishra
              • 4. Re: Data Base Interaction
                Nitin Khare
                I believe you are referring to datasource xml. If you are on Weblogic you need to define the datasource from Weblogic console and it will create the corresponding xml in your domain's config/jdbc. If you are on JBoss you can create the datasource xml using an existing datasource xml which are already provided both in ATG and JBoss. Change the datasource name, driver, jdbc url and other parameters as per your setup and copy this datasource xml to your JBoss server's deploy directory. It will be loaded when you start that JBoss server. Then on ATG side, you will have to update /atg/dynamo/service/jdbc/JTDataSource component to provide it the same JNDI name that you specified in your datasource xml.
                • 5. Re: Data Base Interaction
                  Samdani Gulam
                  for instance take an example of Jboss , in the deploy folder of the application you place the datasource xml file in which you will give the jndi name of the source
                  While defiining the Repository you will give the datasource pointing to DirectJTDataSource which will have JNDI name.
                  From the jndi name it will pick the database connections.

                  For more information please refer to http://docs.oracle.com/cd/E23095_01/Platform.93/ATGInstallGuide/html/s0406configuringdatasourcesforjboss01.html

                  Hope this helps