I use what is below to quickly compare two Oracle database schema’s tables. It would be trivial to add indexes to the mix. import java.sql.*; import java.util.*; public class schemaDiffer { public static void main(String args[]) { try { Class.forName(“oracle.jdbc.driver.OracleDriver”);…
Month: November 2012
Print HTTP headers in ATG
ATG provides a class named InsertableServletImpl, which can do pretty much what it sounds like. You insert the servlet to be run in the ATG servlet pipeline where you dictate. This allows us to inject behavior into our application at…
How is the ATG CONFIGPATH built?
The CONFIGPATH in ATG is not an operating system variable. In other words, you don’t issue something like the following… export CONFIGPATH=/directory_a /directory_B /directory_B start_app.sh The CONFIGPATH is pretty much what it sounds like. If you have done any work…
Simple dbca command line creation
dbca -silent \ -createDatabase -templateName “General_Purpose.dbc” \ -nodelist “expressdb1,expressdb2” \ -gdbName express.home \ -sid express \ -sysPassword ExpressCMH1 \ -systemPassword ExpressCMH1 \ -emConfiguration NONE \ -datafileDestination +DATA \ -redoLogFileSize 50 \ -storageType ASM \ -asmsnmpPassword ExpressCMH1 \ -characterSet AL32UTF8 \…
Tracing SQL across the wire
This can be really useful in place of database tracing, especially when you want to see the action the *application* takes, and not just what it does in the database. [user@************** common]# tcpdump -A -nn port 1521 | \ >…
What does ATG liveconfig actually do?
liveconfig is essentially a switch to runAssembler that creates a properties file to override default ATG Nucleus behavior. It optimizes the configuration for a “live” production site. Specifically, it overrides the following properties. configurationCheckMilliseconds=10000 -to- configurationCheckMilliseconds=-1 checkFileNameCase=false -to- checkFileNameCase=false (yes,…
ATG scheduler job example
ATG supplies a scheduler of sorts that can be used to run tasks that are supposed to run on a recurring basis. First, cd to your ATG installation directory, and set your CLASSPATH so that the compiler can find the…