Neccessary files
1. libsapjco3.so
2. sapjco3.jar
3. /oracle/PRD/102_64/jdbc/lib/nls_charset12.jar
4. /oracle/PRD/102_64/jdbc/lib/ojdbc14.jar
Step to step :
1. Check JAVA VM (if Java Connector 3 up will run on JAVA 1.5 up)
SAP-SERVER:oraprd 46% java -version
java version "1.5.0_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
2. Cretae SAPJco folder and put require files on folder
SAP-SERVER:oraprd 50% pwd
/oracle/PRD/SAPJco
SAP-SERVER:oraprd 49% ls -al
total 13608
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 .
drwxr-xr-x 23 oraprd dba 1536 Feb 12 16:06 ..
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 jco_server
-rw-r--r-- 1 oraprd dba 5784736 Feb 12 17:47 libsapjco3.so
-rw-r--r-- 1 oraprd dba 1149431 Feb 12 17:47 sapjco3.jar
3. Create folder for application (jco_server) and put source files (.java) in here
SAP-SERVER:oraprd 58% pwd
/oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r--r-- 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
4. modify JCO_SERVER.java connect to other host
Example :
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST,"SAP-SERVER");
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "03");
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "900");
connectProperties.setProperty(DestinationDataProvider.JCO_USER, "inf01");
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "sapcpic");
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "th");
connectProperties.setProperty(DestinationDataProvider.JCO_POOL_CAPACITY, "3");
connectProperties.setProperty(DestinationDataProvider.JCO_PEAK_LIMIT, "10");
createDataFile(DESTINATION_NAME2, "jcoDestination", connectProperties);
Properties servertProperties = new Properties();
servertProperties.setProperty(ServerDataProvider.JCO_GWHOST,"SAP-SERVER");
servertProperties.setProperty(ServerDataProvider.JCO_CONNECTION_COUNT, "2");
servertProperties.setProperty(ServerDataProvider.JCO_GWSERV, "sapgw00");
servertProperties.setProperty(ServerDataProvider.JCO_PROGID, "JCO_SERVER");
servertProperties.setProperty(ServerDataProvider.JCO_REP_DEST, "ABAP_AS_WITH_POOL");
createDataFile(SERVER_NAME1, "jcoServer", servertProperties);
String url = "jdbc:oracle:thin:@EXTERNAL-SERVER:1521:PROD";
String userName = "user";
String password = "passwd";
5. Check environment
SAP-SERVER:oraprd 72% env
HOME=/oracle/PRD
PATH=/oracle/PRD/102_64/bin:/oracle/PRD:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb
LOGNAME=oraprd
HZ=
TERM=vt100
SHELL=/bin/csh
MAIL=/var/mail/oraprd
TZ=Asia/Bangkok
PWD=/oracle/PRD/SAPJco/jco_server
USER=oraprd
SAPSYSTEMNAME=PRD
DIR_LIBRARY=/usr/sap/PRD/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/102_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=PRD
dbs_ora_schema=SAPSR3
ORACLE_SID=PRD
DB_SID=PRD
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/PRD/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/PRD
6. Add CLASSPATH and LD_LIBRARY_PATH
set environment CLASS_PATH (for c shell)
% setenv CLASSPATH .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:/oracle/PRD/102_64/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server
add JCO path to LD_LIBRARY_PATH
% setenv LD_LIBRARY_PATH /oracle/PRD/SAPJco:$LD_LIBRARY_PATH
Tips : unset environment
unsetenv CLASSPATH
!!! Set this environment to logon environment too
7. Compile sorce code
SAP-SERVER:oraprd 64% cd /oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r--r-- 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
SAP-SERVER:oraprd 66% javac -classpath .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:/oracle/PRD/102_64/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server JCO_SERVER.java
SAP-SERVER:oraprd 69% ls -al
total 42
drwxr-xr-x 2 oraprd dba 512 Feb 13 10:58 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r--r-- 1 oraprd dba 538 Feb 13 10:58 JCO_SERVER$MyStateChangedListener.class
-rw-r--r-- 1 oraprd dba 769 Feb 13 10:58 JCO_SERVER$MyThrowableListener.class
-rw-r--r-- 1 oraprd dba 2695 Feb 13 10:58 JCO_SERVER$StfcConnectionHandler.class
-rw-r--r-- 1 oraprd dba 3772 Feb 13 10:58 JCO_SERVER.class
-rw-r--r-- 1 oraprd dba 9650 Feb 12 18:01 JCO_SERVER.java
8. run application
$ java -d64 JCO_SERVER &
or
$ nohup java -d64 JCO_SERVER &
