ggate_java_changes.txt

# log in as ggate
su - ggate


cp /vagrant/hr/dirprm/hr-cgga.properties /opt/oracle/ggate_java/dirprm/hr-cgga.properties
cp /vagrant/hr/dirprm/hr-oggq.properties /opt/oracle/ggate_java/dirprm/hr-oggq.properties

cp /vagrant/hr/dirdef/hr.def /opt/oracle/ggate_java/dirdef/hr.def

# change to ggate home 
cd /opt/oracle/ggate_java


export JAVA_HOME=/usr/java/jdk1.7.0_45
export PATH=${JAVA_HOME}/bin:${PATH}
export LD_LIBRARY_PATH=${JAVA_HOME}/jre/lib/amd64/server:${LD_LIBRARY_PATH}


./ggsci

CREATE SUBDIRS

# mgr
status mgr
stop mgr

EDIT PARAMS MGR
-----
PORT 16100
DYNAMICPORTLIST 16110-16120, 16130
AUTOSTART ER *
AUTORESTART ER *, RETRIES 4, WAITMINUTES 4
----

start mgr
status mgr

EDIT PARAMS HR-CGGA
----
EXTRACT HR-CGGA
SETENV ( GGS_USEREXIT_CONF     = "dirprm/hr-cgga.properties" )
SETENV ( GGS_JAVAUSEREXIT_CONF = "dirprm/hr-cgga.properties")
SOURCEDEFS dirdef/hr.def
CUserExit libggjava_ue.so CUSEREXIT PassThru IncludeUpdateBefores
GETUPDATEBEFORES
NoTcpSourceTimer
Table hr.*;
----

DELETE EXTRACT HR-CGGA
ADD EXTRACT HR-CGGA, EXTTRAILSOURCE dirdat/jj


#./extract pf dirprm/hr-cgga.prm


# publish to a JMS Queue 

EDIT PARAMS HR-OGGQ
----
EXTRACT HR-OGGQ
SOURCEDEFS dirdef/hr.def
CUserExit libggjava_ue.so CUSEREXIT PassThru IncludeUpdateBefores
GETUPDATEBEFORES
Table hr.*;
----

DELETE EXTRACT HR-OGGQ
ADD EXTRACT HR-OGGQ, EXTTRAILSOURCE dirdat/jj

./extract pf dirprm/hr-oggq.prm