Generate DDL/SQL using startSQLRepository

One of the beauty of ATG is,it can generate DDL 
from a Repository Definition file.
eg: Below is a sample repository EmployeeRegistration with 4 columns in the module EmployeeRegistration.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE gsa-template SYSTEM "dynamosystemresource:/atg/dtds/gsa/gsa_1.0.dtd">
<gsa-template>
<item-descriptor name="EmployeeInfo">
  <table name="emp_info" type="primary" id-column-names="id">
    <property name="id" column-name="id" data-type="string"/>
    <property name="empId" column-name="emp_id" data-type="int"/>
    <property name="empName" column-name="emp_name" data-

    type="string"/>
    <property name="empDept" column-name="emp_dept" data-

    type="string"/>
  </table>
 </item-descriptor>
</gsa-template>

So to generate a DDL for this you need to simply execute the below line.

startSQLRepository -m EmployeeRegistration -repository
/empRegistration/repositories/EmployeeRegistrationRepository -outputSQL

You need to verify two things before executing this command

1. Your Database connector files are there in the classpath.

   You can  execute the command below to set up the 
   classpath in windows environment.This is faster.

   SET CLASSPATH=C:\ATG\ATG10.0.3\home\locallib\

   mysql-connector-java-5.X.XX-bin.jar;%CLASSPATH%

2. You have to put the  JTDatasource,fakeXADatasource components

   with appropriate connection details in the path
   C:\ATG\ATG10.0.3\home\localconfig\atg\dynamo\service\jdbc
JTDatasource.properties

The JTDatasource has to point to FaxeXADataSource.This component has to mapped to the class MonitoredDataSource.      
fakeXADatasource.properties
     $class=atg.service.jdbc.FakeXADataSource
       URL=jdbc:mysql://localhost:3306/employee
       user=atgtest
       password=atgtest
       driver=com.mysql.jdbc.Driver

See also the console output for this.


Console Output

Comments

Popular posts from this blog

BCC site status inaccessible Agent Production in error state

Weblogic Issues during EAR Deployment Exception in AppMerge flows progression

DUseSunHttpHandler=true weblogic.net.http.SOAPHttpsURLConnection Weblogic/Java HttpHandler issues