Crontab Related problem

Shell Programming and Scripting
1

Hi

Following is the script which runs from command prompt....... but when I schedule it in crontab , its showing some error ( mentioned after this piece of code)

#!/bin/ksh

PATH=/usr/bin:/usr/ucb:/etc:.
export PATH

JAVA_HOME=/opt/bea/jdk131; export JAVA_HOME
ANT_HOME=/opt/bea/ant
_ANT_HOME=$ANT_HOME; export _ANT_HOME

 _ANT_JAR=$_ANT_HOME/lib/ant.jar; export _ANT_JAR
_XML_APIS_JAR=$_ANT_HOME/lib/xml-apis.jar

_CLASSPATH=$CLASSPATH:$JAVA_HOME/lib/tools.jar
_CLASSPATH=$_CLASSPATH:$JAVA_HOME/lib/classes.zip
_CLASSPATH=$_ANT_JAR:$_XML_APIS_JAR:$_PARSER_JAR:$_CLASSPATH; export _CLASSPATH


java -mx64m -Dant.home=$ANT_HOME -classpath $_CLASSPATH org.apache.tools.ant.Main -verbose -buildfile /opt/bea/wls61/config/d
ev05/batch_automation/MBPSBatch/scripts/build.xml   > /opt/bea/wls61/config/dev05/batch_automation/MassTransfer/logs/ant.log
2>&1

grep -i "BUILD FAILED" /opt/bea/wls61/config/dev05/batch_automation/MassTransfer/logs/ant.log  2>/dev/null
rcode=$? ############save the return code here if Failed found it would be 0
echo "$rcode"
if [ $rcode -ne 0 ]
then
echo "No failed found run the script abc.sh"
. /opt/bea/wls61/config/dev05/batch_automation/MassTransfer/startMassTransfer.sh
else
echo "Failed encounter ..."
mailx -s "[`date`] Failure: Error in script" edhfjh@dsjg.com < /opt/bea/wls61/config/dev05/batch_automation/Mass
Transfer/logs/ant.log
echo "Error was encountered in your script" | mailx -s "ALERT!!" dshfgg@gmail.com
fi


**********************
Following is the error that is encountered when it is run using crontab.


Claims_schema:
      [sql] connecting to jdbc:oracle:thin:@114.14.15.125:1521:PLMDEV
      [sql] Loading oracle.jdbc.driver.OracleDriver using system loader.

BUILD FAILED
file:/opt/bea/wls61/config/dev05/batch_automation/MBPSBatch/scripts/build.xml:40
: Class Not Found: JDBC driver oracle.jdbc.driver.OracleDriver could not be loaded
        at org.apache.tools.ant.taskdefs.JDBCTask.getDriver(JDBCTask.java:403)
        at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:342)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:358)
        at org.apache.tools.ant.Task.perform(Task.java:319)
        at org.apache.tools.ant.Target.execute(Target.java:309)
        at org.apache.tools.ant.Target.performTasks(Target.java:336)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1250)
        at org.apache.tools.ant.Main.runBuild(Main.java:610)
        at org.apache.tools.ant.Main.start(Main.java:196)
        at org.apache.tools.ant.Main.main(Main.java:235)

Total time: 1 second

Please suggest needful

Thanks

Pankaj

2

Your main problem is:

: Class Not Found: JDBC driver oracle.jdbc.driver.OracleDriver could not be loaded

You need to make sure that this is referenced in the environmental variables, at the moment it cannot find it and thus cannot build it.