This discussion is archived
5 Replies Latest reply: Oct 19, 2012 8:42 AM by Obed Murillo RSS

Data Base Schema

967909 Explorer
Currently Being Moderated
Hi
What is Data base schema in atg?
explain me in details
  • 1. Re: Data Base Schema
    Nooruddin Shaik Expert
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    Hi
    how can i interact with multipule data bases at a time in my project?
  • 3. Re: Data Base Schema
    RMishra Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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