untitled - PDF Free Download

A Leader of Enterprise e-business Solution FORCS Co., LTD 1

OZ Enterprise Server Administrator's Guide (for Java) 2 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 3

OZ Enterprise Server Administrator's Guide (for Java)..,,... Shell Command Shell Command. 4 FORCS Co., LTD

A Leader of Enterprise e-business Solution,. Manual Getting Started Getting Started WAS API Description......... API, UDS, USL, API API.. FORCS Co., LTD 5

OZ Enterprise Server Administrator's Guide (for Java) 6 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 7

OZ Enterprise Server Administrator's Guide (for Java).. JAVA/XML JDBC/ODBC JVM (Java Virtual Machine) WAS one-point 8 FORCS Co., LTD

A Leader of Enterprise e-business Solution,,. DB Pooling,,,, /. (Concurrent Mode),. CGI, Non-DB UDS(User Data Store). : UDS(User Data Store) JDBC ODBC Non-DB UDS(User Data Store). UDS XML, EJB, Legacy Data. FORCS Co., LTD 9

OZ Enterprise Server Administrator's Guide (for Java) /,.. 10 FORCS Co., LTD

A Leader of Enterprise e-business Solution. UDS JDBC/ODBC Document Manager Data Manager Monitor User Access Manager Schedule Manager Cache Manager Log Manager Repository Manager UDS Non-database Source JDBC/ODBC /, NT Event Unix Syslog FORCS Co., LTD 11

OZ Enterprise Server Administrator's Guide (for Java) 12 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 13

OZ Enterprise Server Administrator's Guide (for Java) JRE(Java Runtime Environment) 1.1.X (Windows NT/2000, Linux, HP-UX, Solaris, AIX, Unixware, Mainframe ) Web Server Web Server (Microsoft IIS(Internet Information Server), Apache, NCSE, CERN, Netscape Enterprise Server ) Web Application Server (WebLogic, WebSphere, Oracle ias(internet Application Server), Fujitsu Interstage, NEC WebOTX J2EE WAS) DBMS Oracle, Informix, Sybase, MS-SQL Server, DB2 ODBC/JDBC DBMS : JRE JRE 1.1.X JDBC 1.0 BLOB, CLOB Type, XML-DTD Store JRE 1.2 JDBC. JDBC 1.0, JDBC 1.0. JRE 1.2. ~ JRE 1.3.X, 1.1.X JDBC. JDBC 2.0, JDBC 2.0. JRE 1.4 JRE 1.4 API(URL Type, Update Methods). JRE 1.4 14 FORCS Co., LTD

A Leader of Enterprise e-business Solution JDBC, JDBC. JDBC 3.0, JDBC 2.0. FORCS Co., LTD 15

OZ Enterprise Server Administrator's Guide (for Java) ( ) ozlicense.xml, License.,,.. ozcntrl.bat / ozcntrl.sh ozcntrl.bat/ozcntrl.sh JRE. Windows JVM, UNIX ozcntrl.sh JRE Path. : "MAX_MEMORY/MIN_MEMORY" JVM /, JAVA_OPTION. JAVA_OPTION. ozcntrl.bat @echo off rem ----------------------------------------------------- rem rem OZ Contorl(OZA SHELL) rem rem rem This script file written and tested under Windows 2000 rem rem User should set following variables: rem rem JAVA_HOME - Determines the version of Java used to start rem OZ Server. This variable must point to the 16 FORCS Co., LTD

A Leader of Enterprise e-business Solution rem root directory of a JDK or JRE installation. rem for an up-to-date list of supported JVMs your platform. rem USER_CLASSPATH - Use this variable to append jar files or directories to rem the OZLIB. rem MAX_MEMORY - Maximum memory used by OZ Server. (The unit is mega-byte.) rem MIN_MEMORY - Minimum memory used by OZ Server. (The unit is mega-byte.) rem rem ----------------------------------------------------- rem ----------------------------------- rem Set user-defined variables rem ----------------------------------- set JAVA_HOME=..\..\JRE set MAX_MEMORY=256 set MIN_MEMORY=128 set JAVA_OPTION= set OZSERVER_HOME=.. set USER_CLASSPATH=%OZSERVER_HOME%\uds\ set OZLIBALL=%OZSERVER_HOME%\lib set OZJLIBALL=%OZSERVER_HOME%\UniversalDriver rem ----------------------------------- rem OZ Main Class rem ----------------------------------- set OZLIB=%OZLIBALL%\ozsfw40.jar;%OZSERVER_HOME%\conf\ set OZLIB=%OZLIB%;%OZLIBALL%\ozusl.jar rem ----------------------------------- rem for Servlet rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\servlet.jar rem ----------------------------------------------------- rem HTTPS/SSL Module rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\jcert.jar set OZLIB=%OZLIB%;%OZLIBALL%\jnet.jar set OZLIB=%OZLIB%;%OZLIBALL%\jsse.jar rem ----------------------------------- rem Library for Logging rem ----------------------------------- FORCS Co., LTD 17

OZ Enterprise Server Administrator's Guide (for Java) set OZLIB=%OZLIB%;%OZLIBALL%\log4j.jar rem ----------------------------------- rem Library for XML rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\parser.jar set OZLIB=%OZLIB%;%OZLIBALL%\xerces.jar set OZLIB=%OZLIB%;%OZLIBALL%\crimson.jar rem ----------------------------------- rem Library for XML Store rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\dtdparser12.jar rem ----------------------------------- rem Repository File Sysgtem DB rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\hsqldb.jar rem ----------------------------------- rem USL Jar for USL rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\OZUSLServerSession.jar set OZLIB=%OZLIB%;%OZLIBALL%\OZUSLServerDES128.jar rem ----------------------------------- rem JDBC Driver for Oracle rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\classes12.zip rem ----------------------------------- rem JDBC Driver for Mysql (3.0.14) rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\mysql.jar rem If your version of oracle is 7 and rem its character set is DBCS, rem then delete 'rem' of next line rem set OZLIB=%OZLIB%;%OZLIBALL%\ijava.jar rem ----------------------------------- rem JDBC Driver for Informix rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\ifxjdbc.jar 18 FORCS Co., LTD

A Leader of Enterprise e-business Solution rem ----------------------------------- rem JDBC Driver for Syabse rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\jconn2.jar rem ----------------------------------- rem JDBC Driver for MSSQL rem ----------------------------------- rem set OZLIB=%OZLIB%;%OZLIBALL%\jkjdbc2.jar set OZLIB=%OZLIB%;%OZJLIBALL%\msbase.jar set OZLIB=%OZLIB%;%OZJLIBALL%\msutil.jar set OZLIB=%OZLIB%;%OZJLIBALL%\mssqlserver.jar rem ----------------------------------- rem JDBC Driver for IBM DB2 rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\db2java.zip set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc.jar set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cisuz.jar set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cu.jar rem ----------------------------------- rem JDBC Driver for Uni-SQL rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\unisqljdbc10.jar rem ----------------------------------- rem JDBC Driver for SAP rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\sapjco.jar rem ----------------------------------- rem USER_CLASSPATH rem ----------------------------------- set OZLIB=%OZLIB%;%USER_CLASSPATH% set JAVA_OPTION= if not "%1" == "-start" goto notstart set JAVA_OPTION= %JAVA_OPTION% -Xms%MIN_MEMORY%m -Xmx%MAX_MEMORY%m :notstart %JAVA_HOME%\bin\java %JAVA_OPTION% -cp %OZLIB% FORCS Co., LTD 19

OZ Enterprise Server Administrator's Guide (for Java) oz.admin.shell.server.ozashell %1 %2 %3 %4 %5 %6 %7 %8 %9 ozcntrl.sh #!/bin/sh #----------------------------------------------------- # # OZ Contorl. # # This script file written and tested under HP-UX # # User should set following variables: # # JAVA_HOME - Determines the version of Java used to start # OZ Server. This variable must point to the # root directory of a JDK or JRE installation. # for an up-to-date list of supported JVMs your platform. # USER_CLASSPATH - Use this variable to append jar files or directories to # the OZLIB. # MAX_MEMORY - Maximum memory used by OZ Server. (The unit is mega-byte.) # MIN_MEMORY - Minimum memory used by OZ Server. (The unit is mega-byte.) # JAVA_OPTIONS - On some platforms, certain java command-line options are # recommanded when running OZ Server. # #----------------------------------------------------- # ----------------------------------- # Set user-defined variables # ----------------------------------- JAVA_HOME=../../jre USER_CLASSPATH= MAX_MEMORY=256 MIN_MEMORY=128 JAVA_OPTION=-hotspot OZSERVER_HOME=.. OZLIB=.:$OZSERVER_HOME/conf OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozsfw40.jar # ----------------------------------- # for User Data Set classes # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozusl.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/hsqldb.jar 20 FORCS Co., LTD

A Leader of Enterprise e-business Solution OZLIB=$OZLIB:$OZSERVER_HOME/lib/servlet.jar # ----------------------------------- # for User Data Set classes # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/uds # ----------------------------------- # Library for Logging # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/log4j.jar # ----------------------------------- # Library for XML # ----------------------------------- #OZLIB=$OZLIB:$OZSERVER_HOME/lib/jaxp.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/parser.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/crimson.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/xerces.jar # ----------------------------------- # USL Jar for USL # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/OZUSLServerSession.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/OZUSLServerDES128.jar # ----------------------------------- # JDBC Driver for MSSQL # ----------------------------------- #OZLIB=$OZLIB:$OZSERVER_HOME/lib/jkjdbc.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/msbase.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/msutil.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/mssqlserver.jar # ----------------------------------- # JDBC Driver for Oracle # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/classes12.zip # If your version of oracle is 7 and # its character set is KOREAN(KSC5601), # then delete '#' of next line # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/ijava.jar FORCS Co., LTD 21

OZ Enterprise Server Administrator's Guide (for Java) # ----------------------------------- # JDBC Driver for Informix # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/ifxjdbc.jar # ----------------------------------- # JDBC Driver for Syabse # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/jconn2.jar # ----------------------------------- # JDBC Driver for IBM DB2 # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/db2java.zip # ----------------------------------- # JDBC Driver for Uni-SQL # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/unisqljdbc10.jar # ----------------------------------- # JDBC Driver for SAP # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/sapjco.jar # ----------------------------------- # HTTPS/SSL Module # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/jcert.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jnet.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jsse.jar # ----------------------------------- # USER CLASSPAATH # ----------------------------------- if [ "$USER_CLASSPATH"!= "" ]; then OZLIB=$OZLIB:$USER_CLASSPATH fi if [ "$1"!= "-start" ]; then JAVA_OPTION= else JAVA_OPTION="$JAVA_OPTION -ms$min_memory"m 22 FORCS Co., LTD

A Leader of Enterprise e-business Solution JAVA_OPTION="$JAVA_OPTION -mx$max_memory"m fi echo "" echo $OZLIB echo "" $JAVA_HOME/bin/java $JAVA_OPTION -classpath $OZLIB oz.admin.shell.server.ozashell $1 $2 $3 $4 $5 $6 $7 $8 $9 ozcntrl " ". ozcntrl.bat/ozcntrl.sh. ozcntrl.bat/ozcntrl.sh " Shell Command". FORCS Co., LTD 23

OZ Enterprise Server Administrator's Guide (for Java).,. JRE SUN JRE 1.3.1. bin chk_version.bat chk_version.sh OZServerInstallService.bat ozcntrl.bat ozcntrl.sh ozencrypted.bat OZServiceSV.exe ozstart.bat ozstart.sh ozstop.bat ozstop.sh Profile.exe server.ico OZServerUninstallService. bat user.cif (.bat) (.sh) NT (.bat) (.sh) ID (.bat) (.sh) (.bat) (.sh) NT None ( ) 24 FORCS Co., LTD

A Leader of Enterprise e-business Solution cache cache_dm conf cachemngr.properties clientlist.xml databind.properties db.properties dbconfig.xml dbconfig.xsd log.properties monitor.properties ozserver.properties repository.properties sap.properties spmgr.properties srmngr.properties (MAC Address, IP Address, HDD Serial) DB DBMS JDBC Monitor SAP uslmngr.properties (, PKI ) xml.properties XML conf/ sample db.properties.datasource db.properties.db2 db.properties.informix db.properties.mssql db.properties.odbc db.properties.oracle db.properties.sybase db.properties.unisql db.properties.user db.properties DBMS repository.properties.odbc repository.properties repository.properties.oracl DBMS e expand OZMBAServer.dll ASP lib crimson.jar dtdparser120.jar XML XML FORCS Co., LTD 25

OZ Enterprise Server Administrator's Guide (for Java) hsqldb.jar jazzlib.jar jcert.jar jnet.jar jsse.jar js.jar log4j.jar NTEventLogAppender.dll ozsfw40.jar OZUSLServerDES128.jar OZUSLServerSession.jar servlet.jar parser.jar xerces.jar Builtin J2EE (HTTP/SSL ) JRE 1.3.X Java Script Windows NT DLL USL USL J2EE XML xalan.jar xercesimpl.jar XML XPath xml-apis.jar sjsxp.jar jsr173_api.jar UDSTestPackage.jar OZServiceBootstrap.jar HTTP XML UDS NT license ozlicense.xml logs monitor.log server.log Monitor repository_files db_file.data db_file.properties db_file.script query.log Builtin Builtin 26 FORCS Co., LTD

A Leader of Enterprise e-business Solution scheduled_data UniversalDriver classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_ cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar sapjco.jar sapjcorfc.dll unisqljdbc10.jar unsqljdbc205.zip Oracle 8i, 9i JDBC Driver IBM DB2 JDBC Driver IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Driver Oracle 7i JDBC Driver Sybase ASE JDBC Driver MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC SAP UniSQL JDBC : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. FORCS Co., LTD 27

OZ Enterprise Server Administrator's Guide (for Java) bin cache chk_version.bat chk_version.sh ozcntrl.bat ozcntrl.sh ozencrypted.bat user.cif (.bat) (.sh) (.bat) (.sh) ID None ( ) cache_dm conf cachemngr.properties clientlist.xml databind.properties db.properties dbconfig.xml dbconfig.xsd log.properties monitor.properties ozservice.properties repository.properties sap.properties spmgr.properties srmngr.properties (MAC Address, IP Address, HDD Serial) DB DBMS JDBC Monitor SAP uslmngr.properties (, PKI ) conf/ sample xml.properties db.properties.datasource db.properties.db2 db.properties.informix db.properties.mssql db.properties.odbc XML db.properties DBMS 28 FORCS Co., LTD

A Leader of Enterprise e-business Solution db.properties.oracle db.properties.sybase db.properties.unisql db.properties.user repository.properties.odbc repository.properties.oracle repository.properties DBMS license ozlicense.xml logs monitor.log server.log Monitor repository_files SilverStream UniversalDriver db_file.data db_file.properties db_file.script query.log servlet.java servlet.xml classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_ cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar Builtin Builtin SilverStream (WAS ) Oracle 8i, 9i JDBC Driver IBM DB2 JDBC Driver IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Driver Oracle 7i JDBC Driver Sybase ASE JDBC Driver MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC FORCS Co., LTD 29

OZ Enterprise Server Administrator's Guide (for Java) WEB-INF sapjco.jar sapjcorfc.dll unisqljdbc10.jar unsqljdbc205.zip web.xml SAP UniSQL JDBC URL WEB_INF/ HelloWorld.class classes ozserver.properties WEB_INF/ lib crimson.jar dtdparser120.jar hsqldb.jar jazzlib.jar jcert.jar jnet.jar jsse.jar js.jar log4j.jar NTEventLogAppender.dll ozsfw40.jar OZUSLServerDES128.jar OZUSLServerSession.jar servlet.jar parser.jar xerces.jar xalan.jar xercesimpl.jar xml-apis.jar sjsxp.jar jsr173_api.jar soap2_3_1.jar XML XML Builtin J2EE (HTTP/SSL ) JRE 1.3.X Java Script Windows NT DLL USL USL J2EE XML XML XPath HTTP XML 30 FORCS Co., LTD

A Leader of Enterprise e-business Solution mail.jar activation.jar UDSTestPackage.jar UDS : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. FORCS Co., LTD 31

OZ Enterprise Server Administrator's Guide (for Java) bin ozstart.bat, ozstop.bat. UNIX bin ozstart.sh, ozstop.sh. ozstart.bat / ozstart.sh ozstart.bat ozstart.sh UNIX. ozcntrl.bat ozcntrl.sh. ozstart.bat @echo off rem ----------------------------------------------------- rem OZ Server Start-up File rem rem This batch file written and tested under Windows 2000 rem check your path indicate <JAVA_HOME>\bin rem ----------------------------------------------------- ozcntrl.bat -start %1 ozstart.sh # ----------------------------------------------------- # OZ Server Start-up File # # This batch file written and tested under UNIX(HP-UX) System # check your path indicate <JAVA_HOME>/bin # -----------------------------------------------------./ozcntrl.sh -start 32 FORCS Co., LTD

A Leader of Enterprise e-business Solution.. : 64 JAVA CLASSPATH. NT { }\bin\ozserverinstallservice.bat { }\bin\ozserveruninstallservice.bat. OZServerInstallService.bat @echo off rem ----------------------------------------------------- rem OZServer Service Install Register Batch File rem ----------------------------------------------------- rem ----------------------------------------------------- rem JRE PATH rem rem ex) set JRE_PATH=C:\Program Files\Forcs\OZ XStudio\jre1.4.2\bin\client\jvm.dll rem -------------------------------------------------- set JRE_PATH= rem -------------------------------------------------- rem OZ Server Home FORCS Co., LTD 33

OZ Enterprise Server Administrator's Guide (for Java) rem rem ex) set OZSCHEDULER_HOME_BIN=C:\Program Files\Forcs\OZ XStudio\OZServer 4.0\bin rem -------------------------------------------------- set OZSERVER_HOME=.. set OZSERVER_HOME_BIN= rem JAVA option delemter is # or ; set JAVA_OPTION= set MAX_MEMORY=256 set MIN_MEMORY=128 if not "%OZSERVER_HOME%" == "" goto start echo Unable to determine the value of OZSERVER_HOME. goto eof if not "%OZSERVER_HOME_BIN%" == "" goto start echo Unable to determine the absolute path value of OZSERVER_HOME_BIN. goto eof if not "%JRE_PATH%" == "" goto start echo Unable to determine the absolute path value of JRE_PATH goto eof :start set USER_CLASSPATH=%OZSERVER_HOME%\uds\ set OZLIBALL=%OZSERVER_HOME%\lib set OZJLIBALL=%OZSERVER_HOME%\UniversalDriver rem ----------------------------------------------------- rem OZ Main Class rem ----------------------------------------------------- set OZLIB=%OZLIBALL%\ozsfw40.jar;%OZSERVER_HOME%\conf\ set OZLIB=%OZLIB%;%OZLIBALL%\ozusl.jar rem ----------------------------------------------------- rem OZ Service BootStrap rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\OZServiceBootstrap.jar rem ----------------------------------------------------- 34 FORCS Co., LTD

A Leader of Enterprise e-business Solution rem for Servlet rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\servlet.jar rem ----------------------------------------------------- rem HTTPS/SSL Module rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\jcert.jar set OZLIB=%OZLIB%;%OZLIBALL%\jnet.jar set OZLIB=%OZLIB%;%OZLIBALL%\jsse.jar rem ----------------------------------------------------- rem Library for Logging, ZIP rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\log4j.jar set OZLIB=%OZLIB%;%OZLIBALL%\jazzlib.jar rem ----------------------------------------------------- rem Library for XML rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\xalan.jar set OZLIB=%OZLIB%;%OZLIBALL%\xercesImpl.jar set OZLIB=%OZLIB%;%OZLIBALL%\xml-apis.jar set OZLIB=%OZLIB%;%OZLIBALL%\parser.jar set OZLIB=%OZLIB%;%OZLIBALL%\xerces.jar set OZLIB=%OZLIB%;%OZLIBALL%\crimson.jar set OZLIB=%OZLIB%;%OZLIBALL%\sjsxp.jar set OZLIB=%OZLIB%;%OZLIBALL%\jsr173_api.jar rem ----------------------------------------------------- rem Library for JavaScript rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\js.jar rem ----------------------------------------------------- rem Library for XML Store rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\dtdparser12.jar rem ----------------------------------------------------- rem Repository File Sysgtem DB rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\hsqldb.jar FORCS Co., LTD 35

OZ Enterprise Server Administrator's Guide (for Java) rem ----------------------------------------------------- rem USL Jar for USL rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\OZUSLServerSession.jar set OZLIB=%OZLIB%;%OZLIBALL%\OZUSLServerDES128.jar rem ----------------------------------------------------- rem JDBC Driver for Oracle rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\classes12.zip rem ----------------------------------------------------- rem JDBC Driver for Mysql (3.0.14) rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\mysql.jar rem If your version of oracle is 7 and rem its character set is DBCS, rem then delete 'rem' of next line rem set OZLIB=%OZLIB%;%OZLIBALL%\ijava.jar rem ----------------------------------------------------- rem JDBC Driver for Informix rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\ifxjdbc.jar rem ----------------------------------------------------- rem JDBC Driver for Syabse rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\jconn2.jar rem ----------------------------------------------------- rem JDBC Driver for MSSQL rem ----------------------------------------------------- rem set OZLIB=%OZLIB%;%OZLIBALL%\jkjdbc2.jar set OZLIB=%OZLIB%;%OZJLIBALL%\msbase.jar set OZLIB=%OZLIB%;%OZJLIBALL%\msutil.jar set OZLIB=%OZLIB%;%OZJLIBALL%\mssqlserver.jar rem ----------------------------------------------------- rem JDBC Driver for IBM DB2 rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\db2java.zip set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc.jar 36 FORCS Co., LTD

A Leader of Enterprise e-business Solution set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cisuz.jar set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cu.jar rem ----------------------------------------------------- rem JDBC Driver for Uni-SQL rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\unisqljdbc10.jar rem ----------------------------------------------------- rem JDBC Driver for SAP rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%\sapjco.jar rem ----------------------------------------------------- rem USER_CLASSPATH rem ----------------------------------------------------- set OZLIB=%OZLIB%;%USER_CLASSPATH% rem --------------------------------- rem WebService added rem ---------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%\activation.jar set OZLIB=%OZLIB%;%OZLIBALL%\mail.jar set OZLIB=%OZLIB%;%OZLIBALL%\soap2_3_1.jar rem ------------------------------ rem NT rem ------------------------------ rem %1 (A-Z 0-9 (,), (.) ) rem-------------------------------------------------------------------- rem OZServiceSV.exe //DS//%1 -OptionName="OptionValue" OZServiceSV.exe //IS//%1 --DisplayName="OZServer" -- Description="OZServer" --StartPath="%OZSERVER_HOME_BIN%" -- StopPath="%OZSERVER_HOME_BIN%" --Classpath="%OZLIB%" --Jvm="%JRE_PATH%" --JavaOptions="%JAVA_OPTION%" --JvmMs="%MIN_MEMORY%" -- JvmMx="%MAX_MEMORY%" --StartMode=jvm --StopMode=jvm -- StartClass=oz.server.OZServiceBootstrap --StartParams=OZServerStart -- StopClass=oz.server.OZServiceBootstrap --StopParams=OZServerStop -- LogPath="%OZSERVER_HOME_BIN%" --LogLevel=DEBUG :eof FORCS Co., LTD 37

OZ Enterprise Server Administrator's Guide (for Java) --Description --DisplayName --Startup ( 1024.) ( : ServiceName) :. Manual Auto. (). --Jvm "jvm.dll" :. ) --Jvm="C:\j2sdk1.4.2_12\jre\bin\ client\jvm.dll" --JvmOptions Jvm ( : -Xrs) --Classpath --JvmMs Initial Memory ( : MB) --JvmMx ( : MB) --JvmSs ( : KB) --StartPath --StartClass --StartParams :. ) --StartPath="C:/OZServer 4.0/bin" oz.server.ozservice Bootstrap OZServerStart ) StartParams= OZServerStart --StartMode jvm Jvm 38 FORCS Co., LTD

A Leader of Enterprise e-business Solution --StopPath --StopClass :. ) --StopPath="C:/OZServer 4.0/bin" OZServerStop ) --StopParams= OZServerStop --StopParams OZServerStop ) --StopParams= OZServerStop --LogPath --LogPrefix --LogLevel :. ) --LogPath="C:/OZServer 4.0/bin" ( : OZService) ) "OZ" "OZ_yyyyMMdd.log". ERROR WARN INFO DEBUG log level, log "ERROR" level log log. "ERROR" level log log () "ERROR", "INFO" level log log --StdOutput --StdError )--StdOutput="stdout.log" )--StdOutput="stderr.log" FORCS Co., LTD 39

OZ Enterprise Server Administrator's Guide (for Java) OZServerUninstallService.bat @echo off rem ------------------------------------------------------------------- rem rem ------------------------------------------------------------------- rem %1 - (A-Z 0-9 (,), (.) ) rem ------------------------------------------------------------------- rem OZServiceSV.exe //DS//%1 OZServiceSV.exe //DS//OZServer { }\conf\ozserver.properties path.oz.server.home. { }\bin\ozserverinstallservice.bat { }\bin\ozserveruninstallservice.bat OZServiceSV.exe. { }\bin\ozserverinstallservice.bat. { }\bin\ozserveruninstallservice.bat.. OZServer " ". OZServer " " "". 40 FORCS Co., LTD

A Leader of Enterprise e-business Solution OZServer " ". : NT. NT ozstart.bat. FORCS Co., LTD 41

OZ Enterprise Server Administrator's Guide (for Java) WAS. WAS WAS " WAS ". WAS. 42 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 43

OZ Enterprise Server Administrator's Guide (for Java) Daemon/Servlet {OZ_HOME}\conf\cachemngr.propeties.. cachemngr.properties ### ### Configuraion of Cache Manager ### CACHE_FILE_PATH = %OZ_HOME%/cache/ CACHE_DM_FILE_PATH = %OZ_HOME%/dm_cache/ repository.active=false repository.memorycachevalidtime=1200 repository.diskcachevalidtime=0 repository.freememorypercentage=0 datamodule.report.active=false datamodule.report.memorycachevalidtime=1200 datamodule.report.diskcachevalidtime=0 datamodule.report.freememorypercentage=0 datamodule.application.active=false datamodule.application.memorycachevalidtime=1200 datamodule.application.diskcachevalidtime=0 44 FORCS Co., LTD

A Leader of Enterprise e-business Solution datamodule.application.freememorypercentage=0 cachemngr.properties CACHE_FILE_PATH CACHE_ DM_FILE_PATH //.active //.memorycachevalidtime //.freememorypercentage //.diskcachevalidtime... "true", "false"... (:). cachemngr.properties. "//" Repository,. repository.active = true ( '/sales/car' ) repository.[/sales/car].active = true ( 'dept1.ozr' ) repository.[/sales/car].[dept1.ozr].active = true Data Module FORCS Co., LTD 45

OZ Enterprise Server Administrator's Guide (for Java)., ODI,..,, ODI '[ ]'. datamodule.report.active = true datamodule.application.active = true ( '/sales/car' ) datamodule.report.[/sales/car].active = true datamodule.application.[/sales/car].active = true ( 'dept1.odi' ) datamodule.report.[/sales/car].[dept1.odi].active = true datamodule.application.[/sales/car].[dept1.odi].activ e = true ( 'Code', Fetch 'DM_BATCH_FETCH', 'A001' ) datamodule.report.[/sales/car].[dept1.odi].[dm_bat CH_FETCH].[Code=A001].active = true datamodule.application.[/sales/car].[dept1.odi].[dm _BATCH_FETCH].[Code=A001].active = true ( 'Code', Fetch 'DM_CONCURRENT_FETCH', 'A001' ) datamodule.report.[/sales/car].[dept1.odi].[dm_co NCURRENT_FETCH].[Code=A001].active = true datamodule.application.[/sales/car].[dept1.odi].[dm _CONCURRENT_FETCH].[Code=A001].active = true 46 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\clientlist.xml OZA, OZR Mac Address, IP Address, HDD Serial. : clientlist.xml. clientlist.xml <ClientList use='true'>  <Client checkall='true'> <MACAddress checkall='true'> <Item>00-34-25-f1-61-45</Item> <Item>00-14-85-f1-68-22</Item> </MACAddress> <IPAddress checkall='true'> <Item>127.0.0.1</Item> <Item>127.0.0.2</Item> </IPAddress> <HDDSerial checkall='true'> <Item>S07HJ1LL200778</Item> <Item>L623471</Item> </HDDSerial> </Client>  FORCS Co., LTD 47

OZ Enterprise Server Administrator's Guide (for Java) <Client checkall='true'>... </Client> </ClientList> cientlist.xml ClientList (MAC Address, IP Address, HDD Serial). true use false () MAC Address, IP Address, HDD Serial. Client checkall true false MAC Address, IP Address, HDD Serial MAC Address, IP Address, HDD Serial () MAC Address MAC Address. MACAddress checkall true false MAC Address MAC Address MAC Address MAC Address () IP Address IP Address. IPAddress checkall true false IP Address IP Address IP Address IP Address () HDDSerial HDD Serial HDD Serial. 48 FORCS Co., LTD

A Leader of Enterprise e-business Solution checkall true false HDD Serial HDD Serial HDD Serial HDD Serial ()., "HDDSerial" "HddSerial". clientlist.xml. clientlist.xml <ClientList use='true'> <Client checkall='true'> <MACAddress checkall='false'> <Item>00-34-25-f1-61-45</Item> <Item>00-14-85-f1-68-22</Item> </MACAddress> <IPAddress checkall='false'> <Item>127.0.0.1</Item> <Item>127.0.0.2</Item> </IPAddress> <HDDSerial checkall='false'> <Item>S07HJ1LL200778</Item> <Item>L623471</Item> </HDDSerial> </Client> <Client checkall='false'> <MACAddress checkall='false'> <Item>00-0f-ea-fy-9a-6a</Item> </MACAddress> <IPAddress checkall='true'> <Item>127.0.0.3</Item> <Item>127.0.0.4</Item> </IPAddress> FORCS Co., LTD 49

OZ Enterprise Server Administrator's Guide (for Java) <HDDSerial checkall='false'> <Item>S0AFJ10Y7064418</Item> <Item>5JT3G3KT</Item> </HDDSerial> </Client> </ClientList> 50 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\databind.propeties. databind.properties # unit : byte, default : 4096 byte, min : 256 byte ConcurrentFetchSize=256 # unit : count, default : 0 ConcurrentFirstRow=0 databind.properties ConcurrentFetchSize ConcurrentFirstRow FetchType "Concurrent" Stream. byte, 4096, 256. :,. FetchType "Concurrent"., 0. : 0. FORCS Co., LTD 51

OZ Enterprise Server Administrator's Guide (for Java) Daemon/Servlet {OZ_HOME}\conf\db.properties. DB Connection Pool, DB Connection Pool.. aliasename.fieldname = value aliasename fieldname db.properties vendor driver url props DBMS. (odbc, oracle, informix, sybase. ms-sql ) JDBC. JDBC URL. JDBC Connection Property String. (User/Password ) 52 FORCS Co., LTD

A Leader of Enterprise e-business Solution dsn serveraddress portno sid servername dbname user password maxconns initconns timeout sessionquery doconnectioncheck testquerystring ODBC... Oracle SID..... DB Connnection. DB Connection. Maxconns Connnection. (:) monitor log session id. "monitor.properties". ConnectionPool connection connection. doconnectioncheck true. : db.properties user, password ozencrypted.bat. " ". DBMS db.properties Oracle oracle_example.vendor=oracle oracle_example.serveraddress=127.0.0.1 oracle_example.portno=1521 oracle_example.sid=orcl oracle_example.user=oz oracle_example.password=oz FORCS Co., LTD 53

OZ Enterprise Server Administrator's Guide (for Java) oracle_example.maxconns=20 oracle_example.initconns=5 oracle_example.timeout=5 Informix informix_example.vendor=informix informix_example.serveraddress=127.0.0.1 informix_example portno=1526 informix_example.servername=ozserver informix_example.dbname=sysutils informix_example.user=informix informix_example.password=informix informix_example.maxconns=20 informix_example.initconns=5 informix_example.timeout=5 MS-SQL mssql_example.vendor=mssql mssql_example.serveraddress=127.0.0.1 mssql_example.portno=1433 mssql_example.dbname=newintra mssql_example.user=sa mssql_example.password= mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 ODBC odbc_example.vendor=odbc odbc_example.dsn=odbc_example odbc_example.user= odbc_example.password= odbc_example.maxconns=5 odbc_example.initconns=2 odbc_example.timeout=5 : NT ODBC DNS ODBC DNS. db2 db2_example.vendor=db2 db2_example.serveraddress=127.0.0.1 54 FORCS Co., LTD

A Leader of Enterprise e-business Solution db2_example.portno=1344 db2_example.dbname=db2 db2_example.user=db2admin db2_example.maxconns=20 db2_example.initconns=5 db2_example.timeout=5 sybase Sybase_example.vendor=sybase Sybase_example.serverAddress=127.0.0.1 Sybase_example.dbName=master Sybase_example.portNo=2343 Sybase_example.user=sa Sybase_example.password=sybase Sybase_example.maxconns=20 Sybase_example.initconns=5 Sybase_example.timeout=5 unisql unisql_example.vendor=unisql unisql_example.serveraddress=127.0.0.1 unisql_example.dbname=demodb unisql_example.portno=44300 unisql_example.user= unisql_example.password= unisql_example.maxconns=20 unisql_example.initconns=5 unisql_example.timeout=5 User Custom DBMS user_example1.vendor=user user_example1.driver=org.gjt.mm.mysql.driver user_example1.url=jdbc:mysql://ip/test user_example1.props=user=oz;password=oz user_example1.user=oz user_example1.maxconns=20 user_example1.initconns=5 user_example1.timeout=5 Data Source JNDI ds_example.vendor=oracle ds_example.serveraddress=127.0.0.1 FORCS Co., LTD 55

OZ Enterprise Server Administrator's Guide (for Java) ds_example.portno=1521 ds_example.sid=forcs815 ds_example.user=scott ds_example.password=tiger ds_example.maxconns=5 ds_example.initconns=0 ds_example.timeout=5 # # Set JDBC Driver using JNDI. # com.forcs.jdbc.jndijdbcdriver is provided by FORCS # in order to use DataSource. # ds_example.driver=com.forcs.jdbc.jndijdbcdriver # # URL Naming Rule # forcs:<jndi_context_factory_name>:<user>:<password>:<jndi_source_name> # forcs:<jndi_context_factory_name>:<jndi_source_name> # # DataSource of WebLogic ds_example.url=forcs:weblogic.jndi.wlinitialcontextfactory:<datasource Name> # DataSource of WebSphere ds_example.url=forcs:com.ibm.websphere.naming.wsninitialcontextfactory:<datasou rce Name> # DataSource of Jeus ds_example.url=forcs:jeus.jndi.jeuscontextfactory:<datasource Name> # DataSource of iplanet # Notice : DataSource Name include "jdbc/" in case of iplanet # ex) jdbc/ecfcds ds_example.url=forcs:com.netscape.server.jndi.rootcontextfactory::<datasource Name> # DataSource of JRUN ds_example.url=forcs:jrun.naming.jruncontextfactory:<datasource Name> 56 FORCS Co., LTD

A Leader of Enterprise e-business Solution {OZ_HOME}\conf\dbconfig.xml {OZ_HOME}\conf\dbconfig.xsd DBMS JDBC.. dbconfig.xml DBMS JDBC. <?xml version="1.0" encoding="utf-8"?> <DBCONNECTION_INFORMATION xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:nonamespaceschemalocation="dbconfig.xsd"> <VENDOR NAME="ORACLE"> <DISPLAYNAME> <LABEL LANG="en_us">ORACLE</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>oracle.jdbc.driver.OracleDriver</JAVA> <NET>System.Data.OracleClient.OracleConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> FORCS Co., LTD 57

OZ Enterprise Server Administrator's Guide (for Java) <JAVA>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST={serverAddress})(PROTOCOL=t cp)(port={portno}))(connect_data=(sid={sid})))</java> <NET>Data Source={sid};User ID={user};Password={password};</NET> </URL> <HANDLER> <JAVA>com.forcs.db.OZGeneralHandler</JAVA> <NET>com.forcs.db.OZOracleHandler</NET> </HANDLER> <PARAMETER_FLAG> <JAVA>?</JAVA> <NET>:</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="sid"> <LABEL LANG="en_us">SID</LABEL> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">SID</LABEL> </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATE</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">TO_DATE('@YYYY/@MM/@DD @hh:@mm:@ss', 'YYYY/MM/DD hh24:mi:ss')</info> <INFO KEY="LIKE_QUERY">like</INFO> <INFO KEY="LIKE_DELEMETER">%</INFO> </INFOS> </ADDITIONAL> </VENDOR> 58 FORCS Co., LTD

A Leader of Enterprise e-business Solution <VENDOR NAME="MS-SQL"> <DISPLAYNAME> <LABEL LANG="en_us">MS-SQL</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.microsoft.jdbc.sqlserver.SQLServerDriver</JAVA> <NET>System.Data.SqlClient.SqlConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:microsoft:sqlserver://{serverAddress}:{portNo};DatabaseName={dbName} </JAVA> <NET>Network Library=DBMSSOCN;Data Source={serverAddress},{portNo};Initial Catalog={dbName};User ID={user};Password={password};</NET> </URL> <HANDLER> <JAVA>com.forcs.db.OZMSSQLHandler</JAVA> <NET>com.forcs.db.OZMssqlHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET>@</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database name</label> FORCS Co., LTD 59

OZ Enterprise Server Administrator's Guide (for Java) </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATETIME</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">CAST('@YYYY.@MM.@DD @hh:@mm:@ss' AS DATETIME)</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="IBM-DB2"> <DISPLAYNAME> <LABEL LANG="en_us">IBM-DB2</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>COM.ibm.db2.jdbc.net.DB2Driver</JAVA> <NET>IBM.Data.DB2.DB2Connection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:db2://{serverAddress}:{portNo}/{dbName}</JAVA> <NET>Server={serverAddress}:{portNo};Database={dbName};User ID={user};Password={password};</NET> </URL> <HANDLER>  <NET>com.forcs.db.OZDb2Handler</NET> </HANDLER> <PARAMETER_FLAG> <NET>@</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> 60 FORCS Co., LTD

A Leader of Enterprise e-business Solution <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database name</label> </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">TIMESTAMP</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">TO_DATE('@YYYY-@MM-@DD @hh:@mm:@ss', 'YYYY-MM-DD HH24:MI:SS')</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="ODBC"> <DISPLAYNAME> <LABEL LANG="en_us">ODBC</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>sun.jdbc.odbc.JdbcOdbcDriver</JAVA> <NET>System.Data.Odbc.OdbcConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:odbc:{dsn}</JAVA> <NET>Dsn={dsn};Uid={user};Pwd={password}</NET> </URL> <HANDLER> <NET>com.forcs.db.OZGeneralHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET>@</NET> FORCS Co., LTD 61

OZ Enterprise Server Administrator's Guide (for Java) </PARAMETER_FLAG> <ITEMS> <ITEM KEY="dsn"> <LABEL LANG="en_us">Data Source Name</LABEL> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Data Source Name</LABEL> </ITEM> </ITEMS> </VENDOR> <VENDOR NAME="INFORMIX"> <DISPLAYNAME> <LABEL LANG="en_us">INFORMIX</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.informix.jdbc.IfxDriver</JAVA> <NET>IBM.Data.Informix.IfxConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:Informixsqli://{serverAddress}:{portNo}/{dbName}:informixserver={serverName}</JAVA> <NET>Host={serverAddress};Service={portNo};Server={serverName};Database={dbName };User ID={user};Password={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZInformixHandler</NET> </HANDLER> <ITEMS> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> 62 FORCS Co., LTD

A Leader of Enterprise e-business Solution <ITEM KEY="serverName"> <LABEL LANG="en_us">Database server name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server name</label> </ITEM> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database name</label> </ITEM> </ITEMS> </VENDOR> <VENDOR NAME="SYBASE"> <DISPLAYNAME> <LABEL LANG="en_us">SYBASE</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.sybase.jdbc2.jdbc.SybDriver</JAVA> <NET>Sybase.Data.AseClient.AseConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:sybase:{dsn}:{serverAddress}:{portNo}/{dbName}</JAVA> <NET>Network Library=DBMSSOCN;Data Source={serverAddress},{portNo};Initial Catalog={dbName};User ID={user};Password={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZSybaseHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET>@</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="dsn" DEFAULT="Tds"> <LABEL LANG="en_us">Data source name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Data source name</label> FORCS Co., LTD 63

OZ Enterprise Server Administrator's Guide (for Java) </ITEM> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database name</label> </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATETIME</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">CONVERT(DATETIME, '@YYYY.@MM.@DD @hh:@mm:@ss')</info> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="UNI-SQL"> <DISPLAYNAME> <LABEL LANG="en_us">UNI-SQL</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>unisql.jdbc.driver.UniSQLDriver</JAVA> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:unisql:{serverAddress}:{portNo}:{dbName}:::</JAVA> </URL> <HANDLER/> 64 FORCS Co., LTD

A Leader of Enterprise e-business Solution <ITEMS> <ITEM KEY="serverAddress"> <LABEL LANG="en_us">Database server IP Address</LABEL> <LABEL LANG="ko_kr"> IP </LABEL> <LABEL LANG="ja_jp">Database server IP Address</LABEL> </ITEM> <ITEM KEY="portNo"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> <LABEL LANG="ja_jp">Database name</label> </ITEM> </ITEMS> </VENDOR> <VENDOR NAME="User-Defined"> <DISPLAYNAME> <LABEL LANG="en_us">User-Defined</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>{driver}</JAVA> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>{url}</JAVA> </URL> <ITEMS> <ITEM KEY="driver"> <LABEL LANG="en_us">Driver Class Name</LABEL> <LABEL LANG="ko_kr">JDBC </LABEL> <LABEL LANG="ja_jp">Driver Class Name</LABEL> </ITEM> <ITEM KEY="url"> <LABEL LANG="en_us">Connection URL</LABEL> <LABEL LANG="ko_kr">JDBC URL</LABEL> <LABEL LANG="ja_jp">Connection URL</LABEL> FORCS Co., LTD 65

OZ Enterprise Server Administrator's Guide (for Java) </ITEM> </ITEMS> </VENDOR> </DBCONNECTION_INFORMATION> OZ dbconfig.xml. VENDOR. ( VENDOR.) DB "user" "password" ITEM. (ITEM.) <ITEM> KEY /. <ITEM> KEY.,, (~,!, @, #, $, %, ^, *, (), _, +,, \, =, -, {}, [], :, ;,.,,, /,?) <ITEM> KEY. "alias", "vendor", "key", "user", "password", "initconns", "maxconns", "timeout", "initsqls", "closesqls", "doautocommit", "doconnectioncheck", "testquerystring", "sessionquery", "_encrypted", "NAME", "INCLUDE", "VENDOR", "USERNAME", "ENCYPW", "PASSWORD", "USEALIAS", "POOLALIAS", "ALIASFILENAME", "AUTOCOMMIT", "ENCODECHARSET", "DECODECHARSET", "TIMEFORMAT", "DATEFORMAT", "TIMESTAMPFORMAT" RDB DB Vendor <ADDITIONAL> DATE_EXPRESSION. (, DB Vendor.) Vendor DATE type DATE_EXPRESSION ORACLE MSSQL DATE DATETIME TO_DATE('@YYYY/@MM/@DD @hh:@mm:@ss', 'YYYY/MM/DD hh24:mi:ss') CAST('@YYYY.@MM.@DD @hh:@mm:@ss' AS DATETIME) DB2 TIMESTAMP TO_DATE('@YYYY-@MM-@DD @hh:@mm:@ss', 'YYYY-MM-DD HH24:MI:SS') SYBASE DATETIME CONVERT(DATETIME, '@YYYY.@MM.@DD 66 FORCS Co., LTD

A Leader of Enterprise e-business Solution DATE @hh:@mm:@ss') TO_DATE('@YYYY/@MM/@DD @hh:@mm:@ss', 'YYYY/MM/DD hh24:mi:ss') dbconfig.xsd dbconfig.xml xsd. dbconfig.xml. <?xml version="1.0" encoding="utf-8"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/xmlschema"> <xsd:complextype name="t_label"> <xsd:simplecontent> <xsd:extension base="xsd:string"> <xsd:attribute name="lang" type="xsd:string" /> </xsd:extension> </xsd:simplecontent> </xsd:complextype> <xsd:complextype name="t_displayname"> <xsd:sequence> <xsd:element name="label" type="t_label" minoccurs="1" maxoccurs="unbounded" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_driver"> <xsd:sequence> <xsd:element name="displayname" type="t_displayname" /> <xsd:element name="java" type="xsd:string" minoccurs="0" maxoccurs="1" /> <xsd:element name="net" type="xsd:string" minoccurs="0" maxoccurs="1" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_handler"> <xsd:sequence> <xsd:element name="java" type="xsd:string" minoccurs="0" maxoccurs="1" /> <xsd:element name="net" type="xsd:string" minoccurs="0" maxoccurs="1" /> FORCS Co., LTD 67

OZ Enterprise Server Administrator's Guide (for Java) </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_parameterflag"> <xsd:sequence> <xsd:element name="java" type="xsd:string" minoccurs="0" maxoccurs="1" /> <xsd:element name="net" type="xsd:string" minoccurs="0" maxoccurs="1" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_item"> <xsd:sequence> <xsd:element name="label" type="t_label" minoccurs="1" maxoccurs="unbounded" /> </xsd:sequence> <xsd:attribute name="key" type="xsd:string" use="required" /> <xsd:attribute name="use_property" type="xsd:string" use="optional" /> <xsd:attribute name="default" type="xsd:string" use="optional"/> </xsd:complextype> <xsd:complextype name="t_items"> <xsd:sequence> <xsd:element name="item" type="t_item" minoccurs="0" maxoccurs="unbounded" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_fieldtype"> <xsd:simplecontent> <xsd:extension base="xsd:string"> <xsd:attribute name="name" type="xsd:string" /> </xsd:extension> </xsd:simplecontent> </xsd:complextype> <xsd:complextype name="t_fieldtypes"> <xsd:sequence> <xsd:element name="fieldtype" type="t_fieldtype" minoccurs="0" maxoccurs="unbounded" /> </xsd:sequence> </xsd:complextype> 68 FORCS Co., LTD

A Leader of Enterprise e-business Solution <xsd:complextype name="t_info"> <xsd:simplecontent> <xsd:extension base="xsd:string"> <xsd:attribute name="key" type="xsd:string" /> </xsd:extension> </xsd:simplecontent> </xsd:complextype> <xsd:complextype name="t_infos"> <xsd:sequence> <xsd:element name="info" type="t_info" minoccurs="0" maxoccurs="unbounded" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_additional"> <xsd:sequence> <xsd:element name="fieldtypes" type="t_fieldtypes" minoccurs="0" maxoccurs="1" /> <xsd:element name="infos" type="t_infos" minoccurs="0" maxoccurs="1" /> </xsd:sequence> </xsd:complextype> <xsd:complextype name="t_vendor"> <xsd:sequence> <xsd:element name="displayname" type="t_displayname" /> <xsd:element name="driver" type="t_driver"/> <xsd:element name="url" type="t_driver"/> <xsd:element name="handler" type="t_handler" minoccurs="0" maxoccurs="1" /> <xsd:element name="parameter_flag" type="t_parameterflag" minoccurs="0" maxoccurs="1" /> <xsd:element name="items" type="t_items" minoccurs="0" maxoccurs="1" /> <xsd:element name="additional" type="t_additional" minoccurs="0" maxoccurs="1" /> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" use="required" /> </xsd:complextype> <xsd:element name="vendor" type="t_vendor" /> FORCS Co., LTD 69

OZ Enterprise Server Administrator's Guide (for Java) <xsd:element name="dbconnection_information"> <xsd:complextype> <xsd:sequence> <xsd:element ref="vendor" minoccurs="0" maxoccurs="unbounded" /> </xsd:sequence> </xsd:complextype> </xsd:element> </xsd:schema> 70 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\log.properties. log 'LOG4OZ' 'LOG4J', CONSOLE(), FILE, NT Event, UNIX Syslog. 'LOG4OZ' "BUILTIN_LOGGING_CONSOLE", "BUILTIN_LOGGING_FILE", 'LOG4J' "Set Prioritylog Level", "Appender CONSOLE", "Appender ROLLING_FILE", "Appender NT Event", "Appender syslog". HTTP. log.properties #----------------------------------------------------------- # configuraion of OZ logging system (LOG4OZ) #----------------------------------------------------------- # #USE_BUILTIN_LOGGING_ENGINE=true #BUILTIN_LOGGING_CONSOLE=true #BUILTIN_LOGGING_CONSOLE.CharSet= #BUILTIN_LOGGING_FILE=true #BUILTIN_LOGGING_FILE.TYPE=RollingFile # ---- ---------------------------- #BUILTIN_LOGGING_FILE.TYPE=DailyRollingFile #BUILTIN_LOGGING_FILE.DatePattern=yyyy-MM-dd # ---------------------------------------------------------- #BUILTIN_LOGGING_FILE.CharSet= FORCS Co., LTD 71

OZ Enterprise Server Administrator's Guide (for Java) #BUILTIN_LOGGING_FILE.LOCATI`ON=%OZ_HOME%/logs/server_oz.log #BUILTIN_LOGGING_FILE.APPEND=true #BUILTIN_LOGGING_FILE.MaxBackupIndex=5 #BUILTIN_LOGGING_FILE.MaxFileSize=1MB #BUILTIN_LOGGING_FILE.ImmediateFlush=true #----------------------------------------------------------- # configuraion of OZ logging system (LOG4J) #----------------------------------------------------------- # # Set Prioritylog level # # DEBUG, INFO, WARN, ERROR Priority=DEBUG # # appender CONSOLE # Console. # CONSOLE.Type=Stdout CONSOLE.Layout=%r [%t] %p %c{1} %x - %m%n CONSOLE.Async=false # # appender ROLLING_FILE # File. # MaxFileSize. # #. # MaxBackupIndex. # # Layout : # Append : # ImmediateFlush : # false #. # CharSet :. # ROLLING_FILE.Type=RollingFile ROLLING_FILE.Layout=%d{ISO8601} [%t] %-5p %c{1} %x - %m%n ROLLING_FILE.File=%OZ_HOME%/logs/server.log # ---- ------------------------- # ROLLING_FILE.Type=DailyRollingFile // # ROLLING_FILE.DatePattern=yyyy-MM-dd # -------------------------------------------------------- 72 FORCS Co., LTD

A Leader of Enterprise e-business Solution ROLLING_FILE.Append=true ROLLING_FILE.MaxBackupIndex=5 ROLLING_FILE.MaxFileSize=1MB ROLLING_FILE.ImmediateFlush=true # # appender NT Event # NT. # #NT_EVENT.Type=NTEvent #NT_EVENT.Layout=%r %p %c{1} - %m%n #NT_EVENT.Threshold=ERROR # # appender syslog # Unix syslog. # #SYSLOG.Type=Syslog #SYSLOG.Layout=[OZ] %r %p %c{1} - %m #SYSLOG.Threshold=ERROR #SYSLOG.SyslogHost=127.0.0.1 #SYSLOG.Facility=USER #SYSLOG.FacilityPrinting=false #------------------------------------------------ # configuraion of HTTPStore Logging #------------------------------------------------ #HTTPSTORE_LOG_FILE=MANUAL (AUTO/MANUAL/NONE) # HTTPSTORE_LOG_FILE.LOCATION=%OZ_HOME%/logs (Directory Name) #------------------------------------------------------ # Instance ( ) #------------------------------------------------------ #MultiInstance=false #WASName= #WASVersion= LOG4OZ LOG4OZ. USE_BUILTIN_LOGGING_ ENGINE true false LOG4OZ LOG4OZ, LOG4J BUILTIN_LOGGING_CON Console. FORCS Co., LTD 73

OZ Enterprise Server Administrator's Guide (for Java) SOLE true false Console Console BUILTIN_LOGGING_CON SOLE.CharSet BUILTIN_LOGGING_FILE Console (IBM 'CP500' ).. 'BUILTIN_LOGGING_FILE.LOCATION'. Rolling. BUILTIN_LOGGING_FILE. TYPE RollingFile DailyRollingFile ex) server.log, server.log.1, server.log.2,... (DatePattern) BUILTIN_LOGGING_FILE. CharSet BUILTIN_LOGGING_FILE. DatePattern BUILTIN_LOGGING_FILE. LOCATION BUILTIN_LOGGING_FILE. APPEND BUILTIN_LOGGING_FILE. MaxBackupIndex BUILTIN_LOGGING_FILE. MaxFileSize BUILTIN_LOGGING_FILE. ImmediateFlush (IBM 'CP500' )... "DatePattern"... Backup.... LOG4J Set Prioritylog priority. 74 FORCS Co., LTD

A Leader of Enterprise e-business Solution level ERROR WARN INFO DEBUG, "ERROR" "ERROR" "ERROR", "INFO" appender CONSOLE CONSOLE.T ype CONSOLE.L ayout Appender., 'stdout'.., "Log Layout".. CONSOLE.A sync true false ( ) appender ROLLING_ FILE ROLLING_F ILE.Type ROLLING_F ILE.DatePat tern ROLLING_F ILE.Layout ROLLING_F ILE.File ROLLING_F ILE.Append Rolling File. RollingFile ex) server.log, server.log.1, server.log.2,... DailyRollingFile (DatePattern). "DatePattern".. "Log Layout"... FORCS Co., LTD 75

OZ Enterprise Server Administrator's Guide (for Java) true false apender NT Event apender syslog ROLLING_F ILE.MaxBac kupindex ROLLING_F ILE.MaxFile size ROLLING_F ILE.Immedi ateflush NT_Event.T ype NT_Event.L ayout NT_Event.T hreshold SYSLOG.Ty pe SYSLOG.La yout SYSLOG.Thr eshold SYSLOG.Sy sloghost SYSLOG.Fac ility Backup.... NT Event "NTEvent". : Windows NT Lib NTEventLog Appender.dll WINNT\SYSTEM32.. "Log Layout"... Unix 'Syslog'.. "Log Layout"... Syslog Unix IP. Syslog. 'KERN', 'USER', 'MAIL', 'DAEMON', 'AUTH', 'SYSLOG', 'LPR', 'NEWS', 'UUCP', 'CRON', 'AUTHPRIV', 'FTP', 'LOCAL1', 'LOCAL2', 'LOCAL3', 'LOCAL4', 'LOCAL5', 'LOCAL6', 'LOCAL7' 76 FORCS Co., LTD

A Leader of Enterprise e-business Solution SYSLOG.Fac ilityprinting Facility. true false HTTP HTTP HTTP ODI, ODI HTTP,. HTTP. HTTPSTORE_LOG_FILE MANUAL AUTO NONE HTTP. ( ) HTTP. HTTP. HTTPSTORE_LOG_FILE.L OCATION,., '%OZ_HOME%/logs'.. HTTP,, HTTP. HTTP "HTTP ". 'HTTPSTORE_LOG_FILE=AUTO' HTTP. 'OZ_HTTPSTATMENT.LOG.#' '#' FORCS Co., LTD 77

OZ Enterprise Server Administrator's Guide (for Java) 1. DatePattern Pattern Rollover schedule yyyy-mm yyyy-ww yyyy-mm-dd yyyy-mm-dd-hh ( ) () 6 12 server.log server.log.2005-06 server.log., 1 12 server.log server.log.2005-01 server.log. 7 1 server.log server.log.2005-07-01 server.log. 7 1 10 server.log server.log.2005-07-01-09 server.log. Log4j Pattern. Pattern yyyy-mm yyyy-ww 1~59. (log4j ) 1~59. (log4j ) 12 1. (jdk: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id =4808661) 2006.12.31 2006-53 or 2007-01 2006-01. 78 FORCS Co., LTD

A Leader of Enterprise e-business Solution DatePattern. DatePattern = yyyy-mm-dd 2005.01.17 2005.01.18 server.log.2005-01-17, 2005.01.19 17 18 server.log.2005-01-18., DatePattern. Log Layout Character c d m n OZServer module Category Name. Category name %c{2}. ) %c oz.server.servlet %c{1} servlet %c{2} server.servlet. Log4j (ABSOLUTE, DATE, ISO8601). Log4j. ) [ %d{dd MM yyyy HH:mm:ss,SSS} ] [ 18 04 2001 18:39:29,777 ] main INFO ozserver - OZServer... ) [ %d{iso8601} ] [ 2001-04-18 18:39:29,777 ]main INFO ozserver - OZServer... message OZServer. ) %d{iso8601} [%t] %-5p %c{1} %x-%m 2002-08-16 09:56:23,203[Handler 1] INFO MessageHandler C "\n". New Line. FORCS Co., LTD 79

OZ Enterprise Server Administrator's Guide (for Java) p r (ERROR, WARN, INFO, DEBUG). %p -5 5. ) %d{iso8601} [%t] %-5p %c{1} %x-%m 2002-08-16 09:56:23,203[Handler 1] INFO MessageHandler millisecond. ex) [%r] [2994] main INFO oz.server - OZServer... Thread. ex) t [%t] 59485 [Thread-2] INFO oz.server - Received a message % %. Log Date Format Symbol G Era designator Text AD y Year Number 2001 M Month Text & Number May & 05 d Day Number 05 h Hour in am/pm (1~12) Number 12 H Hour in day (0~23) Number 0 m Minute Number 30 s Second Number 55 S Millisecond Number 978 E Day in week Text Tuesday D Day in year Number 189 F Day of week in month Number 2 (2nd ) w Week in year Number 27 W Week in month Number 2 a Am/pm marker Text PM k Hour in day (1~24) Number 24 K Hour in am/pm (0~11) Number 0 80 FORCS Co., LTD

A Leader of Enterprise e-business Solution z Time zone Text Pacific Standard Time ' Escape for text Delimiter " Single quote sign Literal ' "yyyy.mm.dd G 'at' hh:mm:ss z" 2001.04.24 AD at 18:25:30 PDT "EEE, MMM d, "yy" Wed, July 10, '96 "h:mm a" 12:08 PM NT Event Instance MultiInstance WASName Instance Instance true, false. ex) MultiInstance=true WAS. ex) WASName=WebLogic FORCS Co., LTD 81

OZ Enterprise Server Administrator's Guide (for Java) WASVersion WAS. ex) WASVersion=7.1 : Instance, WAS WebLogic7.x, WebLogic8.x. 82 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\monitor.properties. monitor.properties #------------------------------------------- # configuraion of OZ Trasaction Monotior log #------------------------------------------- # # OZ 4.0. #. # # # Whether log or not # MONITOR.Active=true MONITOR.File=%OZ_HOME%/logs/monitor.log MONITOR.MaxBackupIndex=5 MONITOR.MaxFileSize=1MB MONITOR.ImmediateFlush=true monitor.properties Active File.. FORCS Co., LTD 83

OZ Enterprise Server Administrator's Guide (for Java) MaxBackuplndex MaxFileSize ImmediateFlush Backup. Backup... csv.. MARK/THR_ID/TIME/F_MEM/T_MEM/S_CODE/S_STATUS/S_PARAMS/C_IP/DB_SS/E_TIME MARK. start, end THR_ID ID. (int) TIME. 1970 1 1 0 Millisecond (long), (int) F_MEM. : byte T_MEM JVM. : byte S_CODE S_STATUS S_PARAMS C_IP. " "... IP. (int) : 9001 : 9002 DB_SS DBMS ID. E_TIME. 1970 1 1 0 Millisecond (long), (int) 84 FORCS Co., LTD

A Leader of Enterprise e-business Solution sessionquery session ID DB db.properties <alias>.sessionquery ID. session ID. sessionquery. alias.sessionquery = "[DB Query]" <infomix> SELECT DBINFO(\"sessionid\") FROM SysTables WHERE TabID = 1 <mssql> select @@spid <oracle> SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid') <sybase> select @@spid,. // Repository CREATE USER = 100; DELETE USER = 101; CHECK USER PWD = 102; UPDATE USER PWD = 103; DISABLE USER LOGIN = 104; ENABLE USER LOGIN = 105; ISENABLE USER LOGIN = 106; UPDATE USER DESCRIPTION = 107; GET USER DESCRIPTION = 108; GET GROUPID USER = 109; GET USERID NAME = 110; UPDATE GROUPID USER = 111; GET USER LIST = 112; CREATE GROUP = 113; DELETE GROUP = 114; UPDATE USER GROUPADMIN = 115; IS USER GROUPADMIN = 116; UPDATE UPPER GROUPID = 117; GET USER LIST GROUP = 118; GET GROUP LIST GROUP = 119; FORCS Co., LTD 85

OZ Enterprise Server Administrator's Guide (for Java) CREATE ITEM = 120; DELETE ITEM = 121; GET ITEM = 122; GET CATEGORYID ITEM = 123; GET GROUPID ITEM = 124; UPDATE CATEGORYID ITEM = 125; UPDATE GROUPID ITEM = 126; GET ITEM LIST = 127; CREATE CATEGORY = 128; DELETE CATEGORY = 129; UPDATE UPPER CATEGORYID = 130; GET ITEM LIST CATEGORY = 131; GET CATEGORY LIST CATEGORY = 132; UPDATE ITEM USER AUTH = 133; UPDATE ITEM GROUP AUTH = 134; GET USER AUTH ITEM = 135 ; GET GROU AUTH ITEM = 136; GET ITEM LIST AUTH USER = 137; GET ITEM LIST AUTH GROUP = 138; GET USER LIST AUTH ITEM = 139; GET GROUP LIST AUTH ITEM = 140; GET ITEMID = 141; GET ITEM DATAINFO = 142; UPDATE USERNAME =143; UPDATE GROUPNAME = 144; UPDATE ITEMNAME = 145; GET ITEMPATH = 146; GET DIRECTITEM = 147; UPDATE CATEGORY USERAUTH = 148; UPDATE CATEGORY GROUPAUTH =149; GET USERAUTH CATEGORY = 150; GET GROUPAUTH CATEGORY = 151; GET CATEGORYLIST USERAUTH = 152; GET CATEGORYLIST GROUPAUTH = 153; GET USERLISTAUTH CATEGORY = 154; GET GROUPLISTAUTH CATEGORY = 155; UPDATE LOGINDEFAULT = 156; UPDATE CATEGORYNAME = 157; CREATE ITEMINDEX = 158; DELETE ITEMINDEX = 159; GET ITEMINDEX LIST = 160; FINDE ITEM ITEMINDEX = 161; 86 FORCS Co., LTD

A Leader of Enterprise e-business Solution UPDATE ITEM FILE = 162; CHECK OUT ITEM = 163; CHECK IN ITEM = 164; ROLLBACK ITEM = 165; UNDO CHECK OUT ITEM = 166; GET ITEM BYVERSION = 167; GET HISTORY LIST = 168; CLEAR HISTORY = 169; CHECK OUT USER = 170; GET CATEGORYINFO = 171; GET ITEMINFO = 172; GET USERNAME BYID = 173; HAS SPECIFIC ITEM = 174; GET ITEMCOUNT IN CATEGORY = 175; LOGIN TO SERVER = 176; LOGIN TO SERVER FROM SCHEDULER = 177; GET ODI LIST = 178; GET CATEGORYID = 179; GET ITEMID WITH PATH = 180; UPDATE DIRECT ITEM FILE = 181; GET USERINFO = 182; UPDATE ITEM DESCRIPTION = 183; GET GROUPINFO = 184; CREATE CATEGORY WITH PATH = 185; CREATE ITEM WITH NAME = 186; GET DIRECT ITEMS = 187; LOGIN USER = 188; LOGOUT USER= 189; ISLOGIN USER = 190; GET ITEMLIST WITH PERMISSION USER = 191; GET CATEGORYLIST WITH PERMISSION USER = 192; GET ITEMLIST WITH PERMISSION GROUP = 193; GET CATEGORYLIST WITH PERMISSION GROUP = 194; GET CATEGORYLIST OVER VIEW IN ROOT = 195; GET DIRECT ITEM COMPRESSED = 196; GET ITEM LIST CATEGORY NAME = 197; GET ITEMLIST WITH PERMISSION USER CNAME = 198; GET ITEMLIST WITH PERMISSION GROUP CNAME = 199; // Datamodule GET DATAMODULE = 380; GET DEFAULT PARAMETER = 381; FORCS Co., LTD 87

OZ Enterprise Server Administrator's Guide (for Java) GET USDM = 382; GET APPLICATION DM = 383; // Connection Pool API GET POOL INFO = 400; GET POOL STATUS LIST = 401; GET POOL INFO LIST = 402; ADD POOL = 403 ; REMOVE POOL = 404 ; SAVE = 405 ; // Log API GET CONFIG = 406 ; CONFIGURE PROPERTY = 407 ; CONFIGURE STRING = 408 ; GET FILE APPENDER FILE = 409 ; SET PRIORITY = 410 ; // Server Info API GET VERSIONS = 411; GARBAGE COLLECT = 412; GET MEMORYINFO = 413; GET HANDLER COUNT = 414; GET MEMORY STATUS = 415; GET CUMULATED COUNT = 416; GET CUMULATED TIMER = 417; GET DYNAMIC INFOMATION = 418; DOWN MONITOR LOG = 419; // Cache API GET CACHE CONFIG = 420; SET CACHE CONFIG = 421; LOGAGENT TEST = 422; GET REALTIME LOG = 423; GET REALTIME MONITOR LOG = 424; DELETE CACHE DATA = 1100; // STOP SERVER STOP = 500; SERVER RESTART = 501; // Application DataModule GET DATAMODULE APP = 520; 88 FORCS Co., LTD

A Leader of Enterprise e-business Solution // Scheduler API GET SCHEDULED RESULT LIST = 600 ; REMOVE SCHEDULED RESULT = 601 ; REMOVE SCHEDULED RESULT LIST = 602 ; SET USDM = 603; // Repository API GET REPOSITORY CONFIG = 700; SET REPOSITORY CONFIG = 701; RELOAD REPOSITORY = 702; // DM Version GET DM VERSION = 800; // USL GET USL = 900; USE USL = 901; FORCS Co., LTD 89

OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\ozserver.properties Servlet {OZ_HOME}\WEB-INF\classes\ozserver.properties.. ozserver.properties (Daemon Type Server) #------------------------------------------- # Main configuration of ozserver/ozservlet #------------------------------------------- server.portnumber= path.oz.server.home=../ path.license.file=%oz_home%/license/ozlicense.xml path.xml.properties.file=%oz_home%/conf/xml.properties path.log.properties.file=%oz_home%/conf/log.properties path.securitypolicy.properties.file=%oz_home%/conf/spmgr.properties path.connpool.properties.file=%oz_home%/conf/db.properties path.cache.properties.file=%oz_home%/conf/cachemngr.properties path.monitor.properties.file=%oz_home%/conf/monitor.properties path.repository.properties.file=%oz_home%/conf/repository.properties path.usl.properties.file=%oz_home%/conf/uslmngr.properties path.schedule.properties.file=%oz_home%/conf/srmngr.properties 90 FORCS Co., LTD

A Leader of Enterprise e-business Solution path.sapclient.properties.file=%oz_home%/conf/sap.properties path.databind.properties.file=%oz_home%/conf/databind.properties path.clientinfo.properties.file=%oz_home%/conf/clientlist.xml path.ozservice.properties.file=%oz_home%/conf/ozservice.properties path.ozdbconfig.properties.file=%oz_home%/conf/dbconfig.xml ozserver.properties (Servlet Type Server) #------------------------------------------- # Main configuration of ozserver/ozservlet #------------------------------------------- path.oz.server.home=%oz_running_path% path.license.file=%oz_home%/license/ozlicense.xml path.xml.properties.file=%oz_home%/conf/xml.properties path.log.properties.file=%oz_home%/conf/log.properties path.securitypolicy.properties.file=%oz_home%/conf/spmgr.properties path.connpool.properties.file=%oz_home%/conf/db.properties path.cache.properties.file=%oz_home%/conf/cachemngr.properties path.monitor.properties.file=%oz_home%/conf/monitor.properties path.repository.properties.file=%oz_home%/conf/repository.properties path.usl.properties.file=%oz_home%/conf/uslmngr.properties path.schedule.properties.file=%oz_home%/conf/srmngr.properties path.sapclient.properties.file=%oz_home%/conf/sap.properties path.databind.properties.file=%oz_home%/conf/databind.properties path.clientinfo.properties.file=%oz_home%/conf/clientlist.xml path.ozservice.properties.file=%oz_home%/conf/ozservice.properties path.ozdbconfig.properties.file=%oz_home%/conf/dbconfig.xml : %OZ_HOME% %OZ_HOME% ozserver.properties path.oz.server.home. %OZ_RUNNING_PATH% %OZ_RUNNING_PATH%. FORCS Co., LTD 91

OZ Enterprise Server Administrator's Guide (for Java) "%OZ_RUNNING_PATH%" bin "%OZ_RUNNING_PATH%/.." ozserver.properties server.portnumber path.oz.server.home path.license.file path.xml.properties.file path.log.properties.file path.securitypolicy.properties.file path.connpool.properties.file path.cache.properties.file path.monitor.properties.file path.repository.properties.file path.usl.properties.file path.schedule.properties.file path.sapclient.properties.file path.databind.properties.file path.clientinfo.properties.file path.ozservice.properties.file path.ozdbconfig.properties.file TCP/IP.. (:8003). ( ) ozlicense.xml. xml.properties. log.properties. spmgr.properties. db.properties. cachemngr.properties. monitor.properties. repository.properties. uslmngr.properties. srmngr.properties. sap.properties. databind.properties. clientlist.xml. ozservice.properties. dbconfig.xml. 92 FORCS Co., LTD

A Leader of Enterprise e-business Solution Servlet {OZ_HOME}\conf\ozservice.propeties.,. Post SOAP DataModule Post SOAP DataAction Get wsdl : " ". ozservice.properties #------------------------------------------- # Main configuration of ozservice #------------------------------------------- enable_ozserver=true enable_webservice=true ozservice.properties enable_ozserver. (:true) FORCS Co., LTD 93

OZ Enterprise Server Administrator's Guide (for Java) enable_webservice. (:true) :. 94 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\repository.propeties. repository.properties ### ### Repository Properties ### Last Modified : Wed Oct 15 13:29:05 KST 2003 ### # RDB, BUILTIN, NONE REPOSITORY_TYPE = RDB REPOSITORY_FILE_PATH = %OZ_HOME%/repository_files/ #BackUp History for None Type #REPOSITORY_NONE_BACKUP=false #REPOSITORY_NONE_BACKUP_PATH=%OZ_HOME%/repository_files_bak/ #REPOSITORY_NONE_BACKUP_ITEM_COUNT=10 #REPOSITORY_NONE_BACKUP_ITEM_VALIDDAYS=0 #Item file save number per a directory #Default value is 500 #The value must be lager than 0 REPOSITORY_ITEM_NUMBER_PER_DIRECTORY = 500 #History item's valid days ( The history item over the value of day is deleted, when check in the item ) #Default value is 30 #The 0 value is disable. FORCS Co., LTD 95

OZ Enterprise Server Administrator's Guide (for Java) REPOSITORY_HISTORY_ITEM_VALID_DAYS = 10 REPOSITORY_QUERY_MAXBACKUPINDEX = 5 REPOSITORY_QUERY_MAXFILESIZE = 1M REPOSITORY_QUERY_IMMEDIATEFLUSH = true # # DB alias in /conf/db.properties to use repository # # note: ignored if REPOSITORY_TYPE is BUILTIN # REPOSITORY_DB_ALIAS = mssql_test3 # # note: ignored if REPOSITORY_TYPE is BUILTIN and RDB repository.properties. TYPE RDB BUILTIN NONE DB DB (Hypersonic SQL DB ) FILE_PATH REPOSITORY_NONE_BACK UP REPOSITORY_NONE_BACK UP_PATH REPOSITORY_NONE_BACK UP_ITEM_COUNT REPOSITORY_NONE_BACK UP_ITEM_VALIDDAYS ITEM_NUMBER_PER_DIREC TORY HISTORY_ITEM_VALID_DA YS QUERY_MAXBACKUPINDEX QUERY_MAXFILESIZE. None. None. None. None... BUILTIN DB. BUILTIN DB. 96 FORCS Co., LTD

A Leader of Enterprise e-business Solution QUERY_IMMEDIATEFLUSH DB_ALIAS BUILTIN DB. db.properties Alias DB Repository. REPOSITORY_TYPE 'NONE', 'admin' 'guest'. Check-In Check-Out, Roll-back. OS Windows. REPOSITORY_TYPE 'RDB' db.properties 'vender=user' RDB. User. RDB MS-SQL, MS-SQL ().. FORCS Co., LTD 97

OZ Enterprise Server Administrator's Guide (for Java) Daemon/Servlet {OZ_HOME}\conf\sap.propeties SAP. SAP Connection Pool, SAP Connection Pool. : SAP UI. sap.properties ### ### Configuraion of SAP Connection Manager ### ### TYPE1 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.sysno= ### TYPE2 #<alias>.client= #<alias>.user= 98 FORCS Co., LTD

A Leader of Enterprise e-business Solution #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.r3name= #<alias>.group= ### TYPE3 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.sysno= #<alias>.gwhost= #<alias>.gwserv= ### TYPE4 #<alias>.gwhost= #<alias>.gwserv= #<alias>.tpname= ### TYPE5 #<alias>.gwhost #<alias>.gwserv #<alias>.tpname #<alias>.tphost sap.properties <alias> <alias>.client <alias>.user <alias>.password <alias>.language <alias>.host <alias>.sysno <alias>.r3name <alias>.group <alias>.gwhost SAP. SAP. SAP. SAP. SAP. SAP. SAP. SAP.. SAP. FORCS Co., LTD 99

OZ Enterprise Server Administrator's Guide (for Java) <alias>.gwserv <alias>.tpname <alias>.tphost SAP. JCO ID.. :. : sap.properties user, password ozencrypted.bat. " ". 100 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\spmgr.propeties. spmgr.properties # Secure Level [ high / middle / low ] # default : low client_message_secure_level = low user.multilogin= true #user.sessiontimeout = 10 allow_service_qd=false enable_service_repository=false allow_service_em=false allow_service_rm=false allow_service_rv=false allow_service_av=false allow_service_api=false allow_service_sh=false allow_service_ps=false spmgr.properties multilogin. FORCS Co., LTD 101

OZ Enterprise Server Administrator's Guide (for Java) sesiontimout.. : (user.multilogin 'false' ).. :. client_message_secu re_level high middle low,. Exception Name,.,. allow_service_qd enable_service_repo sitory allow_service_em allow_service_rm allow_service_rv allow_service_av allow_service_api allow_service_sh allow_service_ps ODI. :.. Enterprise Manager. Repository Manager. OZR. OZA. API. Scheduler. Push Server. : enable_service_repository. enable_service_repository=true allow_service_qd true O O 102 FORCS Co., LTD

A Leader of Enterprise e-business Solution false O X allow_service_rv allow_service_av true O O false O X true O O false O X allow_service_qd, allow_service_rv, allow_service_av false, enable_service_repository true. enable_service_repository=false allow_service_qd allow_service_rv allow_service_av true X X false X X true X X false X X true X X false X X enable_service_repository false, allow_service_qd, allow_service_rv, allow_service_av true. FORCS Co., LTD 103

OZ Enterprise Server Administrator's Guide (for Java) Daemon/Servlet {OZ_HOME}\conf\srmngr.propeties SDM SDM. srmngr.properties # default : false use_scheduled_data=true # The path that scheduled data modules are stored. # default : %OZ_HOME%/scheduled_data datamodule_path=%oz_home%/scheduled_data srmngr.properties use_scheduled_data datamodule_path SDM SDM. "true" "datamodule_path" SDM SDM., "Fetch Type" "BATCH", "Fecth Type" "CONCURRENT". SDM. 104 FORCS Co., LTD

A Leader of Enterprise e-business Solution Daemon/Servlet {OZ_HOME}\conf\uslmngr.properties User Security Logic. uslmngr.properties # oz3.0 USL configuration # # set whether use user security logic or not globaly # UseUserSecurityLogicVer30 = true OZDefault_SERVER=oz.usl.OZUSLServerSample OZDefault_CLIENT=oz.usl.OZUSLClientSample uslmngr.properties UseUSerSecurityLogicVer30 OZDefault_SERVER OZDefault_CLIENT User Security Logic. USL. USL. : User Security Logic. FORCS Co., LTD 105

OZ Enterprise Server Administrator's Guide (for Java) Daemon/Servlet {OZ_HOME}\conf\xml.propeties xml. xml.properties ----------------------------------------------- # Configuration of XML parser used by OZ Server #----------------------------------------------- #SYSTEM_DEFAULT Setting sax.parser=sun dom.parser=sun ################################################ # # parser List # - followings are able to used in SAX and DOM # ---------------------------------------------- # # SUN : parser.jar # CRIMSON : crimson.jar # XERCES : xerces.jar # SYSTEM_DEFAULT : javax.xml.parsers.documentbuilderfactory. xml.properties 106 FORCS Co., LTD

A Leader of Enterprise e-business Solution sax.parser dom.parser. SUN, CRIMSON, XERCES, SYSTEM_DEFAULT XML. SUN, CRIMSON, XERCES, SYSTEM_DEFAULT jar. SUN SUN. WAS CRIMSON, SUN CRIMSON. IBM JVM XERCES. XML XML, Entity, SUN Entity dom.parser CRIMSON XERCES. SYSTEM_DEFAULT JDK javax.xml.parsers. DocumentBuilderFactory. FORCS Co., LTD 107

OZ Enterprise Server Administrator's Guide (for Java) 108 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 109

OZ Enterprise Server Administrator's Guide (for Java) Unix Command Line.. Windows Windows <OZSERVER_HOME>\bin\ozcntrl.bat Unix Unix <OZSERVER_HOME>/bin/ozcntrl.sh ozcntrl [-command] [-arg_name:arg_value...] [-option...] Command ozcntrl -version -ip:127.0.0.1 port:8001 id:admin pwd:admin ozcntrl -testsdm ozcntrl ozcntrl. ozcntrl regsrv. ozcntrl regsrv ozashell.properties (url or ip/port, id, password)., command Line -ip, -port. 110 FORCS Co., LTD

A Leader of Enterprise e-business Solution (Command) ozcntrl -help Arguments Source Source Source A ozcntrl regsrv (ozashell.properties. ID/Password ) Source B Command argument Source C Interactive User Input Type Source Type. Type 1 Source B Source A Source C. Server Address. Type 2 Source B Source C. Server Address. ).. User Input Parameter Type 3 Source B.. ) -xml FORCS Co., LTD 111

OZ Enterprise Server Administrator's Guide (for Java) url ip port HTTP-Server (Servlet) URL TCP-Server (Daemon) Address TCP-Server (Daemon) Port -url:http://127.0.0.1:8080/oz/server 1 -ip:127.0.0.1 1 -port:8003 1 id ID -id:admin 1 pwd Password -pwd:admin 1 fn File Name -fn:d:/test.xml 2 rn Report Name -rn:/susb/report1 2 gn report Group Name -gn:/susb 2 pm ParaMeters -pm:arg1=ttt;arg2=123 -pm:default (default parameter ) 2 Commands Command. [ ] Type 1. {} Type 2. () Type 3. -help. : ozcntrl -help -regsrv.. 112 FORCS Co., LTD

A Leader of Enterprise e-business Solution : ozcntrl -regsrv -start. : ozcntrl -start {configuration_file_name} configuration_file_name. ozserver.properties. ) ozcntrl -start ozcntrl -start d:/server2.properties -stop ( ). : ozcntrl stop [SERVERLOCATION] SERVERLOCATION. ip : ip_address port:port_number ) ozcntrl stop ozcntrl stop ip:127.0.0.1 port:8003 -version.. : ozcntrl version[serverinfo] ) ozcntrl version ozcntrl version url:http://127.0.0.1:8080/oz/server ozcntrl version ip:127.0.0.1 port:8080 id:admin pwd:admin -local.version -version, ozcntrl ozsfw40.jar. : ozcntrl local.version ) FORCS Co., LTD 113

OZ Enterprise Server Administrator's Guide (for Java) ozcntrl local.version -testsdm SDM. : ozcntrl testsdm {fn:sdm_file_name} (xml) fn : sdm. xml : XML../sdmtest.xml. ) ozcntrl testsdm ozcntrl testsdm fn:/temp/report1.sdm xml Repository Manager -repository.getcfg Reository Manager. : ozcntl repository.getcfg [SERVERLOCATION] ) ozcntl rpt.getcfg ozcntl rpt.getcfg url:http://127.0.0.1:8080/oz/server -repository.dn Repository. : ozcntl repository.dn [SERVERINFO] ) ozcntl rpt.dn ozcntl rpt.dn url:http://127.0.0.1:8080/oz/server Cache Manager -cache.getcfg. : ozcntl cache.getcfg [SERVERINFO] ) ozcntl cache.getcfg ozcntl cache.getcfg url:http://127.0.0.1:8080/oz/server 114 FORCS Co., LTD

A Leader of Enterprise e-business Solution Connection Pool -cp.status. : ozcntrl cp.status [SERVERINFO] ) ozcntrl cp.status ozcntrl cp.status ip:127.0.0.1 port:8003 ozcntrl cp.status url:http://127.0.0.1:8080/oz/server Log Manager -log.getcfg. : ozcntrl log.getcfg [SERVERINFO] ) ozcntrl log.getcfg ozcntrl log.getcfg ip:127.0.0.1 port:8003 ozcntrl log.getcfg url:http://127.0.0.1:8080/oz/server -log.dn. : ozcntrl log.dn [SERVERINFO] {fn:filename} filename : ) ozcntrl -log.dn ozcntrl -log.dn -lp:info ozcntrl -log.dn -url:http://127.0.0.1:8080/oz/server Monitor -mntr.dn. : ozcntrl mntr.dn [SERVERINFO] {fn:filename} filename : ) ozcntrl -mntr.dn ozcntrl -mntr.dn -fn:d:/monitor.log FORCS Co., LTD 115

OZ Enterprise Server Administrator's Guide (for Java) ozcntrl -mntr.dn -url:http://127.0.0.1:8080/oz/server Builtin DB -builtin.repair query.log db_file.script. : ozcntrl builtin.repair [SERVERINFO] ) ozcntrl -builtin.repair ozcntrl -builtin.repair ip:127.0.0.1 port:8003 ozcntrl -builtin.repair url:http://127.0.0.1:8080/oz/server DataBind -databind.getcfg DataBind Manager. "ConcurrentFetchSize" "ConcurrentFirstRow",. : ozcntrl -databind.getcfg [SERVERINFO] filename : ) ozcntrl -databind.getcfg ozcntrl -databind.getcfg ip:127.0.0.1 port:8003 ozcntrl -databind.getcfg -url:http://127.0.0.1:8080/oz/server 116 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 117

OZ Enterprise Server Administrator's Guide (for Java) DataAction. Post SOAP DataModule Post SOAP DataAction Get wsdl HttpRequest "SOAPAction". HttpRequest "SOAPAction". URL "?wsdl" "GET" Response wsdl. URL "POST" SOAP. GET http://localhost:8080/oz40/server/odiservice?wsdl POST SOAP http://localhost:8080/oz40/server/odiservice ozservice.properties "enable_webservice" "true". #------------------------------------------- # Main configuration of ozservice #------------------------------------------- enable_ozserver=true enable_webservice=true # 118 FORCS Co., LTD

A Leader of Enterprise e-business Solution (soap2_3_1.jar, mail.jar, activation.jar) (ozsfw40.jar). license. : "TRUE".... USE-WEBSERVICE="TRUE"..... OZServlet preprocess Prototype Definition public void preprocess(javax.servlet.http.httpservletrequest request, OZAttribute[] attr) throws OZWebServiceException oz.server.ozservlet preprocess Overwrite SOAP Header. preprocess Exception SOAP Fault. Argument request FORCS Co., LTD 119

OZ Enterprise Server Administrator's Guide (for Java) Exception Attr OZWebServiceException SOAP Header OZAttribute OZAttribute getname Prototype Definition public String getname() OZAttribute. getvalue Prototype Definition public String getvalue() OZAttribute. ODIService requestdac2 Prototype Definition requestdac2(data) DataAction. : "<FAULT>". Argument data DataAction ODI DataAction. "ozservice.properties". #------------------------------------------- # Main configuration of ozservice #------------------------------------------- enable_ozserver=true enable_webservice=true 120 FORCS Co., LTD

A Leader of Enterprise e-business Solution "USE-WEBSERVICE" "TRUE" license. WAS ODIService URL ODIService. ( URL "http://127.0.0.1:8080/ozserver40/server", ODIService URL " http://127.0.0.1:8080/ozserver40/server/odiservice".) : ODIService Operation. "OZAxisDataAction2Client.java". package sample; import java.io.bytearrayoutputstream; FORCS Co., LTD 121

OZ Enterprise Server Administrator's Guide (for Java) import java.io.fileinputstream; import javax.xml.rpc.serviceexception; import javax.xml.rpc.stub; import sun.misc.base64encoder; import com.forcs.ws.odiservice; import com.forcs.ws.odiserviceservicelocator; import com.forcs.ws.meta.const_dac; import com.forcs.ws.meta.const_field; import com.forcs.ws.meta.dataactioninfo; import com.forcs.ws.meta.ozdata; import com.forcs.ws.meta.ozdataset; import com.forcs.ws.meta.param; import com.forcs.ws.meta.record; public class OZAxisDataAction2Client { public static final String _END_POINT_ADDRESS = "http://127.0.0.1:8080//oz40/server/odiservice"; public static void main(string[] args) { System.out.println("Endpoint address = " + _END_POINT_ADDRESS); try { ODIService stub = (ODIService)createProxy(); OZData data = new OZData(); data.setodiname("dactest.odi"); data.setcategory("/req/258/"); DataActionInfo[] info = new DataActionInfo[1]; info[0] = new DataActionInfo(); info[0].setsetname("dataset"); info[0].settype(const_dac.insert); Param[] sources = new Param[7]; sources[0] = new Param(); sources[0].setname("name"); sources[0].settype(const_field.varchar); sources[0].setvalue("sample1"); sources[1] = new Param(); sources[1].setname("address"); sources[1].settype(const_field.varchar); 122 FORCS Co., LTD

A Leader of Enterprise e-business Solution sources[1].setvalue("sample1"); sources[2] = new Param(); sources[2].setname("birthday"); sources[2].settype(const_field.date); sources[2].setvalue("1980-09-02"); sources[3] = new Param(); sources[3].setname("job"); sources[3].settype(const_field.varchar); sources[3].setvalue("sample1"); sources[4] = new Param(); sources[4].setname("age"); sources[4].settype(const_field.integer); sources[4].setvalue("1001"); sources[5] = new Param(); sources[5].setname("picture"); sources[5].settype(const_field.binary); ByteArrayOutputStream(); FileInputStream fis = new FileInputStream("me.jpg"); ByteArrayOutputStream baos = new byte[] buffer = new byte[2048]; int len =0; while((len=fis.read(buffer))!= -1) { baos.write(buffer, 0, len); } BASE64Encoder encoder = new BASE64Encoder(); sources[5].setvalue(encoder.encode(baos.tobytearray())); fis.close(); baos.close(); sources[6] = new Param(); sources[6].setname("picture_path"); sources[6].settype(const_field.varchar); sources[6].setvalue("image1.jpg"); info[0].setsource(sources); FORCS Co., LTD 123

OZ Enterprise Server Administrator's Guide (for Java) data.setozdataactions(info);. } //DataAction OZData result = (OZData)stub.requestDAC2(data); OZDataSet[] datas = result.getozdataresult(); for(int i=0 ; i < datas.length ; i++) { Record[] record = datas[i].getrecords(); for(int j=0 ; j < record.length ; j++) { String[] cols = record[j].getcols(); for(int k=0 ; k < cols.length ; k++) { if(cols[k].length() >100) { continue; } System.out.println(cols[k]); } System.out.println(); } } } catch (Exception ex) { ex.printstacktrace(); } } private static Stub createproxy() throws ServiceException{ ODIServiceServiceLocator impl = new ODIServiceServiceLocator(); impl.setodiserviceendpointaddress(_end_point_address); return (Stub)impl.getODIService(); } OZAxisDataAction2Client.java Eclipse. 124 FORCS Co., LTD

A Leader of Enterprise e-business Solution DataAction. FORCS Co., LTD 125

OZ Enterprise Server Administrator's Guide (for Java) 126 FORCS Co., LTD

A Leader of Enterprise e-business Solution FORCS Co., LTD 127

OZ Enterprise Server Administrator's Guide (for Java) SAP user ozencrypted.bat bin "ozencrypted.bat". ozencrypted.bat <db_alias_name> <name> <value> [<file_path>] ) DB ozcar DB user admin ozencrypted.bat ozcar user admin SAP ozencrypted.bat <sap_alias_name> <property_name> <property_value> ) SAP sap1 user user1 ozencrypted.bat sap1 user user1 ozencrypted.bat ozencrypted.bat JRE user. @echo off rem ----------------------------------------------------- rem rem OZ ENCRIPTION (OZA SHELL) rem rem This script file written and tested under Windows 2000 rem rem User should set following variables: rem rem JAVA_HOME - Determines the version of Java used to start rem OZ Server. This variable must point to the rem root directory of a JDK or JRE installation. 128 FORCS Co., LTD

A Leader of Enterprise e-business Solution rem for an up-to-date list of supported JVMs your platform. rem USER_CLASSPATH - Use this variable to append jar files or directories to rem the OZLIB. rem MAX_MEMORY - Maximum memory used by OZ Server. (The unit is mega-byte.) rem MIN_MEMORY - Minimum memory used by OZ Server. (The unit is mega-byte.) rem rem ----------------------------------------------------- rem ----------------------------------- rem Set user-defined variables rem ----------------------------------- set JAVA_HOME=..\..\JRE set MAX_MEMORY=256M set MIN_MEMORY=128M set JAVA_OPTION=-Xms%MIN_MEMORY% -Xmx%MAX_MEMORY% set OZSERVER_HOME=.. set USER_CLASSPATH=%OZSERVER_HOME%\uds\ set OZLIBALL=%OZSERVER_HOME%\lib set OZLIB=%OZLIBALL%\ozsfw40.jar;%OZSERVER_HOME%\conf\ set JAVA_OPTION= %JAVA_HOME%\bin\java %JAVA_OPTION% -cp %OZLIB% oz.framework.db.auth %1 %2 %3 db.properties user, password. db.properties user (DB ozcar DB user admin ) db.properties password (DB ozcar DB password admin ) FORCS Co., LTD 129

OZ Enterprise Server Administrator's Guide (for Java) db.properties user (DB ozcar DB user admin ) db.properties password (DB ozcar DB password admin ) SAP sap.properties user, password. user (SAP sap1 user user1 ) password (SAP sap1 password user1 ) 130 FORCS Co., LTD