5 Replies Latest reply: Oct 19, 2012 10:42 AM by Obed Murillo RSS

    Data Base Schema

    967909
      Hi
      What is Data base schema in atg?
      explain me in details
        • 1. Re: Data Base Schema
          Nooruddin Shaik
          Database schema is not related to ATG but related to database.
          Its the database user where we create the table and store the table.
          ATG uses this database schema to work interact with database like any other application.

          Peace
          Shaik
          • 2. Re: Data Base Schema
            967909
            Hi
            how can i interact with multipule data bases at a time in my project?
            • 3. Re: Data Base Schema
              RMishra
              When you are creating XXXRepository.properties, you are passing:
              dataSource=/atg/dynamo/service/jdbc/JTDataSource

              JTDataSource.properties:
              $class=atg.service.jdbc.WatcherDataSource
              dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource

              DirectJTDataSource.properties:
              $class=atg.nucleus.JNDIReference
              JNDIName=java:/somejndiname

              So you can create more than one XXXRepository files with difference values of JNDIName properties. each XXXRepotitory file will contain info. about difference datasource. So you can have multiple datasource with your application.
              In your server, datasource xml file have these JNDI names registered with all mantatory entries like (username, password, url etc).

              If someone have better idea. please share.
              -RMishra
              • 4. Re: Data Base Schema
                RMishra
                Example:
                MySQLRepository.properties:
                $class=GSARepository
                dataSource=dataSource=/atg/dynamo/service/jdbc/JTDataSource1
                ......................................
                .....................................

                MyOracleRepository.properties:
                $class=GSARepository
                dataSource=dataSource=/atg/dynamo/service/jdbc/JTDataSource2
                ......................................
                .....................................


                JTDataSource1.properties:
                $class=atg.service.jdbc.WatcherDataSource
                dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource1


                JTDataSource2.properties:
                $class=atg.service.jdbc.WatcherDataSource
                dataSource=/atg/dynamo/service/jdbc/DirectJTDataSource2


                DirectJTDataSource1.properties:
                $class=atg.nucleus.JNDIReference
                JNDIName=java:/SQLDS


                DirectJTDataSource2.properties:
                $class=atg.nucleus.JNDIReference
                JNDIName=java:/OracleDS

                for more information about above SQLDS and OracleDS refer to below links:

                JNDI

                DataSource Configuration

                I have not implemented but I think it should work if we use MySQLRepository and DirectJTDataSource1 in same application.
                -RMishra
                • 5. Re: Data Base Schema
                  Obed Murillo
                  Hi 964906,

                  You can learn in here http://docs.oracle.com/cd/E23095_01/Platform.93/RepositoryGuide/html/index.html the repository guide will tallk you about the different schemas that atg uses for catalog, commerce and merchindising, and It does have informatio about how you manipulate the database from atg stand point.

                  Regards,
                  Obed