The IBM JACL implementation does not pick up the TCL_CLASSPATH variable.

For example; adding the Derby java database jars.

lappend x C:/IBM/Cloudscape_10.1/lib/derby.jar
lappend x C:/IBM/Cloudscape_10.1/lib/derbyclient.jar
lappend x C:/IBM/Cloudscape_10.1/lib/derbynet.jar
lappend x C:/IBM/Cloudscape_10.1/lib/derbytools.jar

set env(TCL_CLASSPATH) $x

The jacl command "java::import org.apache.derby.jdbc.EmbeddedDriver"

generates

WASX7017E: Exception received while running file
"c:\scripts\websphere\jacl\getJ
VMINFO.tcl"; exception information: com.ibm.bsf.BSFException: error while
eval'i
ng Jacl expression: can not import class
"org.apache.derby.jdbc.EmbeddedDriver",
it does not exist

The work around is to add the required jar files to the WAS_CLASSPATH in
the WSADMIN bat file.

....................
....................
:runcmd

set WAS_CLASSPATH=C:\IBM\Cloudscape_10.1\lib\derby.jar;%WAS_CLASSPATH%

"%JAVA_HOME%\bin\java" %javaoption% %CONSOLE_ENCODING% %DEBUG%
"%CLIENTSOAP%" "%CLIENTSAS%"
"-Dcom.ibm.ws.scripting.wsadminprops=%WSADMIN_PROPERTIES%"
-Dcom.ibm.ws.management.standalone=true
"-Duser.install.root=%USER_INSTALL_ROOT%" "-Dwas.install.root=%WAS_HOME%"
"-Dwas.repository.root=%CONFIG_ROOT%" "-Dserver.root=%WAS_HOME%"
"-Dlocal.cell=%WAS_CELL%" "-Dlocal.node=%WAS_NODE%"
"-Dcom.ibm.itp.location=%WAS_HOME%\bin" "-classpath"
"%WAS_CLASSPATH%;%WAS_HOME%\lib\jython.jar" "-Dws.ext.dirs=%WAS_EXT_DIRS%"
com.ibm.ws.bootstrap.WSLauncher com.ibm.ws.scripting.WasxShell %*
...............
...............

This allows use of the Derby database for WAS performance data logging.


Regards.


PATRICK FINNEGAN.
WebSphere Consultant.

===================================================
HBF Health Funds Inc. a registered organisation under the National Health Act
HBF Insurance Pty Ltd ACN  009 268 277
This email is a confidential communication intended only for the named Addressee(s).
If you are not that person any disclosure, copying, distribution or use of this email
or the information in it is prohibited. Please notify us immediately by
telephone, (+61) 08 9265 6111 or return email and delete this email.
The views in this email may be personal to the author and not those of HBF.

_______________________________________________
ActiveTcl mailing list
ActiveTcl@list...
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs