UNIX for Dummies Questions & Answers

Hi all,

This is my first shell script, so I'm hoping the problem is that I'm just missing something, and not something bigger. I have a Java application that I wrote in WSAD that reads data from an Excel file and inserts values into a DB2 database. I'm able to run it successfully in WSAD. I am trying to write a Bourne shell script to call the main method so that I can have a cron job that runs the app at a specific time. It seems to be failing once I add the rt.jar in the classpath. Thanks in advance for looking.

This is my script:

#!/bin/sh
cd /usr/local/xmlMQ2smtp2

JAVA_COMPILER=off
export JAVA_COMPILER
JAVA_HOME= /usr/jdk_base

CLASSPATH=.
CLASSPATH=$CLASSPATH:migrationApplication.jar
CLASSPATH=$CLASSPATH:/usr/jdk_base/lib/classes.zip
CLASSPATH=$CLASSPATH:/usr/local/classes/jxl.jar
CLASSPATH=$CLASSPATH:/usr/local/classes/log4j.jar
#CLASSPATH=$CLASSPATH:/usr/local/classes/db2java.zip
#CLASSPATH=$CLASSPATH:/usr/local/classes/j2ee.jar
CLASSPATH=$CLASSPATH:/usr/java131/jre/lib/rt.jar

export CLASSPATH

java -classpath $CLASSPATH com.form.migrationapplication.Migrate

java.lang.UnsatisfiedLinkError: registerNatives
at
at java.util.HashMap.rehash(HashMap.java:301)
at java.util.HashMap.put(HashMap.java:362)
at jxl.biff.FormattingRecords.addFormat(FormattingRecords.java:143)
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:328)
at jxl.Workbook.getWorkbook(Workbook.java:167)
at com.form.migrationapplication.ReadExcelFile.read(Read
ExcelFile.java:89)
at com.form.migrationapplication.Migrate.main(Migrate.ja
va:28)

The errors you are getting have nothing to do with shell scripting. They're obviously java errors. Since I have no idea what com.form.migrationapplication.Migrate calls, I couldn't tell you what you need to add. Obviously, running something inside WebSphere is very different to running something in the command line. I'm guessing that com.form.migrationapplication.Migrate is looking for something that WebSphere loads when it runs.
The one pointer I will give you, you can specify your CLASSPATH in one line.

Actually that means that a native implementation (native binary) could not be found for a method defined as native, so you may need to look not only at classpatch but also the LD_LIBRARY_PATH.

Looks like you are missing the shared object 'registerNatives'.

unsatisfied link error occurs with DB2 when the profile is not sourced while using it with websphere.

stop WAS and source the db2 profile which will be under /home/<db_instance>/sqllib/db2profile.

restart the was.

test the database connection from WAS console navigate to JDBC providers and the db drivers.

regards,

Guru