#!/bin/csh
# Start up script for JDBC Adapter

# Replace the variables in the following lines with the appropriate values:
# <javaHome> is the location of the installed Java SDK.
# <webAppHome> is the location of the Info*Engine installation directory.
# <jdbcJarHome> is the location of the JDBCAdapter.jar file.
# <oracleHome> is the location of the Oracle Installation.

set JAVA_HOME=<javaHome>
set WEB_APP_HOME=<webAppHome>
set JDBC_HOME=<jdbcJarHome>
set ORACLE_HOME=<oracleHome>

# This classpath includes the JDBC driver classes.
# This is required for the Query-Objects, Query-Attributes and Delete-Objects
# webjects.
# If different on your system, change the classpath setting as appropriate
# in the next line
set CLASSPATH={$ORACLE_HOME}\jdbc\lib\ojdbc6.jar

# This classpath required to run the JDBC Adapter.
set CLASSPATH={$CLASSPATH}:{$JDBC_HOME}/JDBCAdapter.jar

# This classpath is required so that all necessary Info*Engine .jar files are
# loaded.
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase/WEB-INF/lib/ieWeb.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase/WEB-INF/lib/ie3rdpartylibs.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase/WEB_INF/lib/jmxcoreWeb.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase/WEB-INF/lib/install.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/codebase/WEB-INF/lib/mail.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/lib/servlet.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/srclib/wnc/CommonCore.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/srclib/wnc/CommonXml.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/srclib/wnc/MetaSpecCommon.jar
set CLASSPATH={$CLASSPATH}:{$WEB_APP_HOME}/srclib/wnc/WebServices.jar
set CLASSPATH={$CLASSPATH}:{$JAVA_Home}/lib/tools.jar

# If LDAP adapter entries are not used, then comment out the lines that follow
# the comments.
# If LDAP adapter entries are used, then replace the following variables with
# the appropriate values.

# <propUrl> is the location of the ie.properties file, which is in the
# codebase/WEB-INF directory where Info*Engine is installed.This file
# contains a reference to the LDAP branch that contains the Info*Engine
# and adapter properties, and contains LDAP validation information.
# If you do not have access to this file, replace this variable with
# an LDAP URL that provides the same information that is in the file.
# For additionalinformation about this file, see the Windchill
# Installation and Configuration Guide - Advanced.
# <domain> is the host domain where Info*Engine is installed.

set IEPROPFILE=<propUrl>
set IENAMINGSERVICENAME=<domain>.namingService

# log4j setup
set LOG4J_CONGIF=log4j_jdbc.properties

echo JDBC Adapter
echo Using Classpath...
echo $CLASSPATH

# The following line starts the JDBC adapter as a standalone process:
$JAVA_HOME/bin/java -classpath {$CLASSPATH} -DpropFile={"$IEPROPFILE"}
-DserviceName=jdbcAdapter -DnamingServiceName={$IENAMINGSERVICENAME}
-Djdbc.home={"$JDBC_HOME"} -Dlog4j.configuration={"$LOG4J_CONFIG"}
-Dwt.home={"$WEB_APP_HOME"} com.infoengine.jdbc.JDBCAdapter