untitled

Transcription

1 FORCS Co., LTD 1

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

3 FORCS Co., LTD 3

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

5 Shell Command Shell Command.. user, RDB. FORCS Co., LTD 5

6 OZ Enterprise Server Administrator's Guide (for Java),. Manual Getting Started Getting Started API Description API, UDS, USL, API API.. 6 FORCS Co., LTD

7 FORCS Co., LTD 7

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

9 ,,. 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

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

11 . 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

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

13 JRE(Java Runtime Environment) 1.3.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 FORCS Co., LTD 13

14 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. 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 14 FORCS Co., LTD

15 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%\ozsfw51.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, ZIP rem FORCS Co., LTD 15

16 OZ Enterprise Server Administrator's Guide (for Java) 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%\dom4j jar set OZLIB=%OZLIB%;%OZLIBALL%\jaxen jar set OZLIB=%OZLIB%;%OZLIBALL%\crimson.jar set OZLIB=%OZLIB%;%OZLIBALL%\stax 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 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 FORCS Co., LTD

17 rem JDBC Driver for Mysql (5.1.5) rem set OZLIB=%OZLIB%;%OZJLIBALL%\mysql5.1.5.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 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 USER_CLASSPATH rem set OZLIB=%OZLIB%;%USER_CLASSPATH% FORCS Co., LTD 17

18 OZ Enterprise Server Administrator's Guide (for Java) 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 Service Class rem set OZLIB=%OZLIB%;%OZLIBALL%\OZServiceBootstrap.jar rem rem User Defined Log Class rem rem OZLIB=%OZLIB%;%OZLIBALL%\ozudl.jar 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% 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.) 18 FORCS Co., LTD

19 # 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=.. # # OZ Main Class # OZLIB=.:$OZSERVER_HOME/conf OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozsfw51.jar # # for User Data Set classes # OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozusl.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/hsqldb.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/servlet.jar # # for User Data Set classes # OZLIB=$OZLIB:$OZSERVER_HOME/uds # # Library for Logging, ZIP # OZLIB=$OZLIB:$OZSERVER_HOME/lib/log4j.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jazzlib.jar # FORCS Co., LTD 19

20 OZ Enterprise Server Administrator's Guide (for Java) # Library for XML # OZLIB=$OZLIB:$OZSERVER_HOME/lib/xalan.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/xercesImpl.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/xml-apis.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/parser.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/xerces.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/dom4j jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jaxen jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/crimson.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/stax jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jsr173_api.jar # # Library for JavaScript # OZLIB=$OZLIB:$OZSERVER_HOME/lib/js.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 # # JDBC Driver for Mysql (5.1.5) 20 FORCS Co., LTD

21 # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/mysql5.1.5.jar # # 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 # # HTTPS/SSL Module # OZLIB=$OZLIB:$OZSERVER_HOME/lib/jcert.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jnet.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jsse.jar # # Library for JavaScript # OZLIB=$OZLIB:$OZSERVER_HOME/lib/js.jar # # User Defined Log Class # # OZLIB=%OZLIB%;%OZLIBALL%\ozudl.jar # # WebService added # OZLIB=$OZLIB:$OZSERVER_HOME/lib/activation.jar FORCS Co., LTD 21

22 OZ Enterprise Server Administrator's Guide (for Java) OZLIB=$OZLIB:$OZSERVER_HOME/lib/mail.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/soap2_3_1.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 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". 22 FORCS Co., LTD

23 .,. JRE SUN JRE 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 server.ico OZServerUninstallService. bat BuiltinToRDBConvert.bat BuiltinToRDBConvert.sh (.bat) (.sh) NT (.bat) (.sh) ID (.bat) (.sh) (.bat) (.sh) NT RDB FORCS Co., LTD 23

24 OZ Enterprise Server Administrator's Guide (for Java) user.cif None ( ) cache cache_dm conf cachemngr.properties databind.properties datasource.properties db.properties dbconfig.xml dbconfig.xsd log.properties monitor.properties ozserver.properties repository.properties sap.properties spmgr.properties srmngr.properties DB DBMS JDBC Monitor SAP uslmngr.properties (, PKI ) ozudl.properties 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 24 FORCS Co., LTD

25 lib crimson.jar dtdparser120.jar hsqldb.jar jazzlib.jar jcert.jar jnet.jar jsse.jar js.jar log4j.jar NTEventLogAppender.dll ozsfw51.jar OZUSLServerDES128.jar OZUSLServerSession.jar servlet.jar parser.jar xerces.jar dom4j jar jaxen jar xalan.jar xercesimpl.jar xml-apis.jar sjsxp.jar jsr173_api.jar UDSTestPackage.jar OZServiceBootstrap.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 UDS NT SOAP license ozlicense.xml logs monitor.log server.log Monitor repository_files FORCS Co., LTD 25

26 OZ Enterprise Server Administrator's Guide (for Java) db_file.data db_file.properties db_file.script query.log Builtin Builtin 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 mysql5.1.5.jar ozsapjco2.jar ozsapjco3.jar sqljdbc.jar 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 SAPJCO2 SAPJCO3 : SAPJCO3 JRE 1.5, ozcntrl.bat/ozcntrl.sh JRE. MSSQL 2008 JDBC UniSQL JDBC : JDBC "UniversalDriver" 26 FORCS Co., LTD

27 JDBC, RDB JDBC. RDB JDBC. WEB-INF WEB_INF/ bin web.xml chk_version.bat chk_version.sh ozcntrl.bat ozcntrl.sh ozencrypted.bat user.cif URL (.bat) (.sh) (.bat) (.sh) ID None ( ) WEB_INF/ cache WEB_INF/ cache_dm WEB_INF/ HelloWorld.class classes ozserver.properties WEB_INF/ conf cachemngr.properties databind.properties datasource.properties db.properties dbconfig.xml dbconfig.xsd log.properties mail.properties DB DBMS JDBC FORCS Co., LTD 27

28 OZ Enterprise Server Administrator's Guide (for Java) monitor.properties ozservice.properties repository.properties sap.properties spmgr.properties srmngr.properties ozudl.properties Monitor SAP uslmngr.properties (, PKI ) xml.properties XML WEB_INF/ conf/ sample WEB_INF/ lib 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 repository.properties.odbc repository.properties.oracle crimson.jar dtdparser120.jar hsqldb.jar jazzlib.jar jcert.jar jnet.jar jsse.jar js.jar log4j.jar NTEventLogAppender.dll db.properties DBMS repository.properties DBMS XML XML Builtin J2EE (HTTP/SSL ) JRE 1.3.X Java Script Windows NT DLL 28 FORCS Co., LTD

29 ozsfw51.jar OZUSLServerDES128.jar OZUSLServerSession.jar servlet.jar parser.jar xerces.jar dom4j jar USL USL J2EE XML jaxen jar xalan.jar xercesimpl.jar XML XPath xml-apis.jar sjsxp.jar jsr173_api.jar soap2_3_1.jar activation.jar mail.jar UDSTestPackage.jar HTTP XML UDS WEB_INF/ license ozlicense.xml WEB_INF/ monitor.log Monitor logs server.log WEB_INF/ repository_files WEB_INF/ SilverStream WEB_INF/ UniversalDriver db_file.data db_file.properties db_file.script query.log servlet.java servlet.xml classes12.jar classes12.zip db2java.jar db2java.zip Builtin Builtin SilverStream (WAS ) Oracle 8i, 9i JDBC Driver IBM DB2 JDBC Driver FORCS Co., LTD 29

30 OZ Enterprise Server Administrator's Guide (for Java) db2jcc.jar db2jcc_license_ cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Driver Oracle 7i JDBC Driver Sybase ASE JDBC Driver MSSQL 97 JDBC IBM JT400 JDBC msbase.jar mssqlserver.jar MSSQL 2000 JDBC msutil.jar mysql5.1.5.jar ozsapjco2.jar ozsapjco3.jar sqljdbc.jar unisqljdbc10.jar unsqljdbc205.zip Mysql JDBC SAPJCO2 SAPJCO3 : SAPJCO3 JRE 1.5, ozcntrl.bat/ozcntrl.sh JRE. MSSQL 2005 JDBC UniSQL JDBC : JDBC "UniversalDriver" JDBC, RDB JDBC. RDB JDBC. 30 FORCS Co., LTD

31 bin ozstart.bat, ozstop.bat. UNIX bin ozstart.sh, ozstop.sh. ozstart.bat ozstart.sh UNIX. ozcntrl.bat ozcntrl.sh. 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 FORCS Co., LTD 31

32 OZ Enterprise Server Administrator's Guide (for Java).. : 64. JAVA CLASSPATH. NT { }\bin\ozserverinstallservice.bat { }\bin\ozserveruninstallservice.bat. 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 5.1\jre\bin\hotspot\jvm.dll rem set JRE_PATH= rem rem OZ Server Home rem rem ex) set OZSERVER_HOME_BIN=C:\Program Files\Forcs\OZ Xstudio 5.1\OZServer 5.1\bin 32 FORCS Co., LTD

33 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%\ozsfw51.jar;%OZSERVER_HOME%\conf\ set OZLIB=%OZLIB%;%OZLIBALL%\ozusl.jar rem rem OZ Service BootStrap rem set OZLIB=%OZLIB%;%OZLIBALL%\OZServiceBootstrap.jar rem rem for Servlet rem set OZLIB=%OZLIB%;%OZLIBALL%\servlet.jar FORCS Co., LTD 33

34 OZ Enterprise Server Administrator's Guide (for Java) 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 rem rem USL Jar for USL rem FORCS Co., LTD

35 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%\mysql5.1.5.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 set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cisuz.jar set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cu.jar FORCS Co., LTD 35

36 OZ Enterprise Server Administrator's Guide (for Java) rem rem JDBC Driver for Uni-SQL rem set OZLIB=%OZLIB%;%OZJLIBALL%\unisqljdbc10.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 --Description ( 1024.) 36 FORCS Co., LTD

37 --DisplayName --Startup ( : 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 5.1/bin" oz.server.ozservice Bootstrap OZServerStart ) StartParams= OZServerStart --StartMode jvm Jvm --StopPath :. ) --StopPath="C:/OZServer 5.1/bin" --StopClass FORCS Co., LTD 37

38 OZ Enterprise Server Administrator's Guide (for Java) OZServerStop ) --StopParams= OZServerStop --StopParams OZServerStop ) --StopParams= OZServerStop --LogPath --LogPrefix --LogLevel :. ) --LogPath="C:/OZServer 5.1/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" OZServerUninstallService.bat OZServiceSV.exe //DS//OZServer 38 FORCS Co., LTD

39 { }\conf\ozserver.properties path.oz.server.home. { }\bin\ozserverinstallservice.bat. ' '. OZServer " ". OZServer " " "". FORCS Co., LTD 39

40 OZ Enterprise Server Administrator's Guide (for Java) OZServer ( ). : NT. NT ozstart.bat. { }\bin\ozserveruninstallservice.bat. 40 FORCS Co., LTD

41 WAS. WAS. WAS WAS.. FORCS Co., LTD 41

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

43 Daemon {OZ_HOME}\conf\cachemngr.propeties Servlet {OZ_HOME}\WEB-INF\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 FORCS Co., LTD 43

44 OZ Enterprise Server Administrator's Guide (for Java) datamodule.application.active=false datamodule.application.memorycachevalidtime=1200 datamodule.application.diskcachevalidtime=0 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' ) 44 FORCS Co., LTD

45 repository.[/sales/car].[dept1.ozr].active = true Data Module., 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' 'SQL_1' ) datamodule.report.[/sales/car].[dept1.odi].active = true datamodule.application.[/sales/car].[dept1.odi].[sql _1].[0].active = true ( 'Code', Fetch 'DM_BATCH_FETCH', 'A001' 'SQL_1' ) datamodule.report.[/sales/car].[dept1.odi].[dm_bat CH_FETCH].[Code=A001].active = true datamodule.application.[/sales/car].[dept1.odi].[sql _1].[0].[DM_BATCH_FETCH].[Code=A001].active = true ( 'Code', Fetch 'DM_CONCURRENT_FETCH', 'A001' 'SQL_1' ) FORCS Co., LTD 45

46 OZ Enterprise Server Administrator's Guide (for Java) datamodule.report.[/sales/car].[dept1.odi].[dm_co NCURRENT_FETCH].[Code=A001].active = true datamodule.application.[/sales/car].[dept1.odi].[sql _1].[0].[DM_CONCURRENT_FETCH].[Code=A001].ac tive = true 46 FORCS Co., LTD

47 Daemon {OZ_HOME}\conf\clientlist.xml Servlet {OZ_HOME}\WEB-INF\conf\clientlist.xml OZA, OZR Mac Address, IP Address, HDD Serial. : JDK clientlist.xml. : clientlist.xml XML conf. clientlist.xml <ClientList use='true'> <Client checkall='true'> <!-- true, MAC, IP, HDD --> <MACAddress checkall='false'> <Item> f </Item> <Item> f </Item> </MACAddress> FORCS Co., LTD 47

48 OZ Enterprise Server Administrator's Guide (for Java) <IPAddress checkall='false'> <Item> </Item> <Item> </Item> </IPAddress> <HDDSerial checkall='false'> <Item>S07HJ1LL200778</Item> <Item>L623471</Item> </HDDSerial> </Client> <Client checkall='true'> <MACAddress checkall='false'> <Item>00-0f-ea-fy-9a-6a</Item> </MACAddress> <IPAddress checkall='true'> <!-- true, 2IP -->. <Item> </Item> <Item> </Item> </IPAddress> <HDDSerial checkall='false'> <Item>S0AFJ10Y </Item> <Item>5JT3G3KT</Item> </HDDSerial> </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 ( ) 48 FORCS Co., LTD

49 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 ( ) HDD Serial HDD Serial. HDDSerial checkall true false HDD Serial HDD Serial HDD Serial HDD Serial ( )., "HDDSerial" "HddSerial". clientlist.xml. FORCS Co., LTD 49

50 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\databind.propeties Servlet {OZ_HOME}\WEB-INF\conf\databind.propeties. databind.properties # unit : byte, default : 4096 byte, min : 256 byte ConcurrentFetchSize=4096 # unit : count, default : 0 ConcurrentFirstRow=0 # value : default/true/false NumericDecimalDisplayZero=default databind.properties ConcurrentFetchSize FetchType "Concurrent" Stream. byte, 4096, 256. :,. 50 FORCS Co., LTD

51 ConcurrentFirstRow NumericDecimalDisplayZero FetchType "Concurrent"., 0. : DB ODI 0 "default", "true", "false "default". "Numeric" "Decimal". "default" DB ODI. FORCS Co., LTD 51

52 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\datasource.propeties Servlet {OZ_HOME}\WEB-INF\conf\datasource.propeties, HTTP, SOAP, XML.. aliasename.optionname= value : "datasource.properties" OS. : ODI. datasource.properties vendor. 52 FORCS Co., LTD

53 filename designtimefilename datasetnodename recordnodename startindex checkerror. : OZ URL. HOME, OZ URL.. : OZ URL. HOME, OZ URL. XML XML. XML XML. ROW INDEX. '0' ROW INDEX CSV.. CSV "ERR" "ERR" "ERR" CSV. FORCS Co., LTD 53

54 OZ Enterprise Server Administrator's Guide (for Java) characterset hasfieldtype fielddelimeter linedelimiter nullmark.. CSV CSV. CSV. TAB, SPACE, SEMICOLON, COLON, COMMA.. CSV. LINEFEED.. NULL. HTTP vendor url dopost urlencode filenametolog. HTTP. URL GET POST. Server URL. URL 'TRUE' FORCS Co., LTD

55 designtimefilename datasetnodename recordnodename startindex checkerror characterset hasfieldtype fielddelimeter. : OZ URL. HOME, OZ URL. XML XML. XML XML. 'RECORD'. ROW INDEX. '0' ROW INDEX CSV.. CSV "ERR" "ERR" "ERR" CSV... CSV CSV. CSV. TAB, SPACE, SEMICOLON, COLON, COMMA.. FORCS Co., LTD 55

56 OZ Enterprise Server Administrator's Guide (for Java) linedelimiter nullmark errorretrycount CSV. LINEFEED.. NULL. HTTP SOAP vendor. wsdlurl endpoint id password WSDL. : WSDL " " OZ URL. HOME, OZ URL.. HTTP ID. HTTP. XML vendor. 56 FORCS Co., LTD

57 xmlurl samplexmlurl schemapath XML. : " " OZ URL. HOME, OZ URL. XML. : OZ URL. HOME, OZ URL. DTD/XSD. : OZ URL. HOME, OZ URL. FORCS Co., LTD 57

58 OZ Enterprise Server Administrator's Guide (for Java) datasource.properties # FILE CSV file_csv.vendor=file file_csv.filename=c:\repository\csv\simple.csv file_csv.designtimefilename=c:\repository\csv\simple.csv file_csv.checkerror=error_prefix file_csv.characterset=utf-8 file_csv.hasfieldtype=true file_csv.fielddelimeter=comma file_csv.linedelimiter=linefeed file_csv.nullmark=null file_csv.startindex=1 # FILE XML File_xml.VENDOR=FILE File_xml.FILENAME=C:\Repositoryxml\simple.xml File_xml.DESIGNTIMEFILENAME=C:\Repository\xml\simple.xml File_xml.DATASETNODENAME=DATASET File_xml.RECORDNODENAME=RECORD File_xml.STARTINDEX=1 HTTP # HTTP CSV http_csv.vendor=http http_csv.url= http_csv.dopost=false http_csv.urlencode=false http_csv.filenametolog=ozhttpcsv.log http_csv.designtimefilename=c:\repository\csv\simple.csv http_csv.checkerror=error_prefix http_csv.characterset=utf-8 http_csv.hasfieldtype=true http_csv.fielddelimeter=comma http_csv.linedelimiter=linefeed http_csv.nullmark=null http_csv.startindex=1 # HTTP XML http_xml.vendor=http http_xml.url= http_xml.dopost=false 58 FORCS Co., LTD

59 http_xml.urlencode=false http_xml.filenametolog=ozhttpxml.log http_xml.designtimefilename=c:\repository\xml\simple.xml http_xml.datasetnodename=dataset http_xml.recordnodename=record http_xml.startindex=1 SOAP # SOAP soap.vendor=soap soap.wsdlurl= soap.endpoint= soap.id=myid soap.password=mypassword XML # XML xml.vendor=xml xml.xmlurl=c:\program Files\FORCS\OZ Xstudio 5.1\Repository\Xml\sample.xml xml.samplexmlurl=c:\repository\xml\sample.xml xml.schemapath=c:\repository\xml\sample.xsd FORCS Co., LTD 59

60 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\db.properties Servlet {OZ_HOME}\WEB-INF\conf\db.properties. DB Connection Pool, DB Connection Pool.. aliasename.fieldname = value aliasename fieldname db.properties vendor driver DBMS. (odbc, oracle, informix, sybase. ms-sql ) JDBC. 60 FORCS Co., LTD

61 url props dsn serveraddress portno sid servername dbname user password maxconns initconns timeout sessionquery doconnectioncheck testquerystring decodecharset encodecharset JDBC URL. JDBC Connection Property String. (User/Password ) 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. " ". : / FORCS Co., LTD 61

62 OZ Enterprise Server Administrator's Guide (for Java) PC Locale /. encodecharset, decodecharset. db.properties / /., db.properties. DBMS db.properties Oracle oracle_example.vendor=oracle oracle_example.serveraddress= oracle_example.portno=1521 oracle_example.sid=orcl oracle_example.user=oz oracle_example.password=oz oracle_example.maxconns=20 oracle_example.initconns=5 oracle_example.timeout=5 Informix informix_example.vendor=informix informix_example.serveraddress= 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= FORCS Co., LTD

63 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= 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= 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 FORCS Co., LTD 63

64 OZ Enterprise Server Administrator's Guide (for Java) unisql_example.vendor=unisql unisql_example.serveraddress= 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= 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> # 64 FORCS Co., LTD

65 # 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> FORCS Co., LTD 65

66 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\dbconfig.xml {OZ_HOME}\conf\dbconfig.xsd Servlet {OZ_HOME}\WEB-INF\conf\dbconfig.xml {OZ_HOME}\WEB-INF\conf\dbconfig.xsd DBMS JDBC.. dbconfig.xml DBMS JDBC. <?xml version="1.0" encoding="utf-8"?> <DBCONNECTION_INFORMATION xmlns:xsi=" xsi:nonamespaceschemalocation="dbconfig.xsd"> <VENDOR NAME="oracle"> <DISPLAYNAME> <LABEL LANG="en_us">ORACLE</LABEL> </DISPLAYNAME> <DRIVER SUPPORTFUNCTION="TRUE"> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>oracle.jdbc.driver.OracleDriver</JAVA> <NET>System.Data.OracleClient.OracleConnection</NET> </DRIVER> 66 FORCS Co., LTD

67 <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> 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" DEFAULTVALUE="1521"> <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" DEFAULTVALUE="ORCL"> <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><!--, DATE,. --> </FIELDTYPES> <INFOS> <INFO 'YYYY/MM/DD hh24:mi:ss')</info> FORCS Co., LTD 67

68 OZ Enterprise Server Administrator's Guide (for Java) <INFO KEY="LIKE_QUERY">like</INFO> <INFO KEY="LIKE_DELEMETER">%</INFO> </INFOS> </ADDITIONAL> <MARS ACTIVE="true" MAJOR_VERSION="1" MINOR_VERSION="1"/> </VENDOR> <VENDOR NAME="mssql"> <DISPLAYNAME> <LABEL LANG="en_us">MS-SQL</LABEL> </DISPLAYNAME> <DRIVER SUPPORTFUNCTION="FALSE"> <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} ;SelectMethod=Cursor</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> </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" DEFAULTVALUE="1433"> <LABEL LANG="en_us">Database server port number</label> <LABEL LANG="ko_kr"> </LABEL> 68 FORCS Co., LTD

69 <LABEL LANG="ja_jp">Database server port number</label> </ITEM> <ITEM KEY="dbName" DEFAULTVALUE="master"> <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 AS DATETIME)</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="mssql2005"> <DISPLAYNAME> <LABEL LANG="en_us">MS-SQL</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.microsoft.sqlserver.jdbc.SQLServerDriver</JAVA> <NET>System.Data.SqlClient.SqlConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc: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> FORCS Co., LTD 69

70 OZ Enterprise Server Administrator's Guide (for Java) </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" DEFAULTVALUE="1433"> <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" DEFAULTVALUE="master"> <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 AS DATETIME)</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="mssql2005_mars"> <DISPLAYNAME> <LABEL LANG="en_us">MS-SQL</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.SqlClient.SqlConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Network Library=DBMSSOCN;Data 70 FORCS Co., LTD

71 Source={serverAddress},{portNo};Initial Catalog={dbName};User ID={user};Password={password};MultipleActiveResultSets=True</NET> </URL> <HANDLER> <NET>com.forcs.db.OZMssqlHandler</NET> </HANDLER> <PARAMETER_FLAG> </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" DEFAULTVALUE="1433"> <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" DEFAULTVALUE="master"> <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 AS DATETIME)</INFO> </INFOS> </ADDITIONAL> <MARS ACTIVE="true" MAJOR_VERSION="2" MINOR_VERSION="0"/> </VENDOR> <VENDOR NAME="db2"> <DISPLAYNAME> <LABEL LANG="en_us">IBM-DB2</LABEL> </DISPLAYNAME> <DRIVER SUPPORTFUNCTION="FALSE"> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> FORCS Co., LTD 71

72 OZ Enterprise Server Administrator's Guide (for Java) </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> <!-- JAVA, OZGeneralHandler.. --> <NET>com.forcs.db.OZDb2Handler</NET> </HANDLER> <PARAMETER_FLAG> </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" DEFAULTVALUE="50000"> <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 'YYYY-MM-DD HH24:MI:SS')</INFO> </INFOS> 72 FORCS Co., LTD

73 </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 TYPE="positional">?</NET> </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> FORCS Co., LTD 73

74 OZ Enterprise Server Administrator's Guide (for Java) </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> <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 SUPPORTFUNCTION="FALSE"> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> 74 FORCS Co., LTD

75 </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> </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> </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> FORCS Co., LTD 75

76 OZ Enterprise Server Administrator's Guide (for Java) <FIELDTYPE NAME="DATE">DATETIME</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">CONVERT(DATETIME, </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="unisql"> <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/> <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="mysql"> 76 FORCS Co., LTD

77 <DISPLAYNAME> <LABEL LANG="en_us">mysql</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>com.mysql.jdbc.Driver</JAVA> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <JAVA>jdbc:mysql://{serverAddress}:{portNo}/{dbName}</JAVA> </URL> <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> <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"> <DISPLAYNAME> <LABEL LANG="en_us">User-Defined</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <JAVA>{driver}</JAVA> </DRIVER> FORCS Co., LTD 77

78 OZ Enterprise Server Administrator's Guide (for Java) <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"> </LABEL> <LABEL LANG="ja_jp">Driver Class Name</LABEL> </ITEM> <ITEM KEY="url"> <LABEL LANG="en_us">Connection URL</LABEL> <LABEL LANG="ko_kr"> URL</LABEL> <LABEL LANG="ja_jp">Connection URL</LABEL> </ITEM> </ITEMS> </VENDOR> <VENDOR NAME="mssql-oledb"> <DISPLAYNAME> <LABEL LANG="en_us">mssql-oledb</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.OleDb.OleDbConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Provider=SQLOLEDB;Data Source={serverAddress},{portNo};Network Library=DBMSSOCN;initial catalog={dbname};user Id={user};Password={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZOLEDBHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET TYPE="positional">?</NET> </PARAMETER_FLAG> 78 FORCS Co., LTD

79 <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> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATETIME</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO AS DATETIME)</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="oracle-oledb"> <DISPLAYNAME> <LABEL LANG="en_us">oracle-oledb</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.OleDb.OleDbConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Provider=ORAOLEDB.Oracle;Data Source={sid};User Id={user};Password={password};</NET> </URL> FORCS Co., LTD 79

80 OZ Enterprise Server Administrator's Guide (for Java) <HANDLER> <NET>com.forcs.db.OZOLEDBHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET TYPE="positional">?</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="sid"> <LABEL LANG="en_us">SID</LABEL> <LABEL LANG="ko_kr">SID</LABEL> <LABEL LANG="ja_jp">SID</LABEL> </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATE</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO 'YYYY/MM/DD hh24:mi:ss')</info> <INFO KEY="LIKE_QUERY">like</INFO> <INFO KEY="LIKE_DELEMETER">%</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="sybase-oledb"> <DISPLAYNAME> <LABEL LANG="en_us">sybase-oledb</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.OleDb.OleDbConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Provider=Sybase ASE OLE DB Provider;Datasource={dsn};User ID={user};Password={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZOLEDBHandler</NET> 80 FORCS Co., LTD

81 </HANDLER> <PARAMETER_FLAG> <NET TYPE="positional">?</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> </ITEM> </ITEMS> <ADDITIONAL> <FIELDTYPES> <FIELDTYPE NAME="DATE">DATETIME</FIELDTYPE> </FIELDTYPES> <INFOS> <INFO KEY="DATE_EXPRESSION">CONVERT(DATETIME, </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="db2-oledb"> <DISPLAYNAME> <LABEL LANG="en_us">db2-oledb</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.OleDb.OleDbConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Provider=IBMDADB2;Data Source={dbName};UID={user};PWD={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZOLEDBHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET TYPE="positional">?</NET> </PARAMETER_FLAG> FORCS Co., LTD 81

82 OZ Enterprise Server Administrator's Guide (for Java) <ITEMS> <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 'YYYY-MM-DD HH24:MI:SS')</INFO> </INFOS> </ADDITIONAL> </VENDOR> <VENDOR NAME="informix-oledb"> <DISPLAYNAME> <LABEL LANG="en_us">informix-oledb</LABEL> </DISPLAYNAME> <DRIVER> <DISPLAYNAME> <LABEL LANG="en_us">Driver</LABEL> </DISPLAYNAME> <NET>System.Data.OleDb.OleDbConnection</NET> </DRIVER> <URL> <DISPLAYNAME> <LABEL LANG="en_us">URL</LABEL> </DISPLAYNAME> <NET>Provider=Ifxoledbc;Data Source={dbName};User ID={user};password={password};</NET> </URL> <HANDLER> <NET>com.forcs.db.OZOLEDBHandler</NET> </HANDLER> <PARAMETER_FLAG> <NET TYPE="positional">?</NET> </PARAMETER_FLAG> <ITEMS> <ITEM KEY="dbName"> <LABEL LANG="en_us">Database name</label> <LABEL LANG="ko_kr"> </LABEL> 82 FORCS Co., LTD

83 </ITEM> </ITEMS> </VENDOR> </DBCONNECTION_INFORMATION> <LABEL LANG="ja_jp">Database name</label> 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 'YYYY/MM/DD hh24:mi:ss') AS DATETIME) DB2 TIMESTAMP 'YYYY-MM-DD HH24:MI:SS') FORCS Co., LTD 83

84 OZ Enterprise Server Administrator's Guide (for Java) SYBASE DATETIME CONVERT(DATETIME, DATE 'YYYY/MM/DD hh24:mi:ss') dbconfig.xsd dbconfig.xml xsd. dbconfig.xml. <?xml version="1.0" encoding="utf-8"?> <xsd:schema xmlns:xsd=" <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" 84 FORCS Co., LTD

85 maxoccurs="1" /> </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> FORCS Co., LTD 85

86 OZ Enterprise Server Administrator's Guide (for Java) <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" /> 86 FORCS Co., LTD

87 <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> FORCS Co., LTD 87

88 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\log.properties Servlet {OZ_HOME}\WEB-INF\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 # FORCS Co., LTD

89 #BUILTIN_LOGGING_FILE.TYPE=DailyRollingFile #BUILTIN_LOGGING_FILE.DatePattern=yyyy-MM-dd # #BUILTIN_LOGGING_FILE.CharSet= #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 FORCS Co., LTD 89

90 OZ Enterprise Server Administrator's Guide (for Java) # # ROLLING_FILE.Type=DailyRollingFile // # ROLLING_FILE.DatePattern=yyyy-MM-dd # 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= #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= # # configuraion of OZ Mail # #Mail.active=false #Mail.alias= 90 FORCS Co., LTD

91 #Mail.fromSend= #Mail.toSend= #Mail.SMTPServer= #Mail.SMTPServerPort=25 #Mail.SMTPUserID= #Mail.SMTPUserPassword= #Mail.SMTPUserID_encrypted= #Mail.SMTPUserPassword_encrypted= #Mail.SendRetryCount=1 #Mail.SendRetryPeriodTime=30 #Mail.PrefixSubjectMessage= #Mail.FilterType= #Mail.FilterServiceCode= LOG4OZ LOG4OZ. USE_BUILTIN_LOGGING_ ENGINE true false LOG4OZ LOG4OZ, LOG4J BUILTIN_LOGGING_CON SOLE BUILTIN_LOGGING_CON SOLE.CharSet BUILTIN_LOGGING_FILE Console. true Console false Console 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 (IBM 'CP500' ).. FORCS Co., LTD 91

92 OZ Enterprise Server Administrator's Guide (for Java) BUILTIN_LOGGING_FILE. DatePattern BUILTIN_LOGGING_FILE. LOCATION BUILTIN_LOGGING_FILE. APPEND BUILTIN_LOGGING_FILE. MaxBackupIndex BUILTIN_LOGGING_FILE. MaxFileSize BUILTIN_LOGGING_FILE. ImmediateFlush. "DatePattern"... Backup.... LOG4J., ERROR "ERROR" Set Prioritylog level priority WARN INFO "ERROR" "ERROR", "INFO" DEBUG appender CONSOLE CONSOLE.T ype CONSOLE.L ayout CONSOLE.A Appender., 'stdout'.., "Log Layout".. 92 FORCS Co., LTD

93 sync true false ( ) Rolling File. ROLLING_F ILE.Type RollingFile DailyRollingFile ex) server.log, server.log.1, server.log.2,... (DatePattern) appender ROLLING_ FILE ROLLING_F ILE.DatePat tern ROLLING_F ILE.Layout ROLLING_F ILE.File ROLLING_F ILE.Append. "DatePattern".. "Log Layout"... true false apender NT Event ROLLING_F ILE.MaxBac kupindex ROLLING_F ILE.MaxFile size ROLLING_F ILE.Immedi ateflush NT_Event.T ype Backup.... NT Event "NTEvent". : Windows NT Lib NTEventLog Appender.dll WINNT\SYSTEM32. FORCS Co., LTD 93

94 OZ Enterprise Server Administrator's Guide (for Java) apender syslog NT_Event.L ayout NT_Event.T hreshold SYSLOG.Ty pe SYSLOG.La yout SYSLOG.Thr eshold SYSLOG.Sy sloghost SYSLOG.Fac ility SYSLOG.Fac ilityprinting. "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' Facility. true false HTTP HTTP HTTP ODI, ODI HTTP,. HTTPSTORE_LOG_FILE HTTP. MANUAL HTTP. ( ) 94 FORCS Co., LTD

95 AUTO NONE HTTP. HTTP. HTTPSTORE_LOG_FILE.L OCATION,., '%OZ_HOME%/logs'.. HTTP,, HTTP. HTTP "HTTP ". 'HTTPSTORE_LOG_FILE=AUTO' HTTP. 'OZ_HTTPSTATMENT.LOG.#' '#' 1. DatePattern Pattern Rollover schedule yyyy-mm yyyy-ww yyyy-mm-dd ( ) ( ) 6 12 server.log server.log server.log., 1 12 server.log server.log server.log. 7 1 server.log server.log server.log. FORCS Co., LTD 95

96 OZ Enterprise Server Administrator's Guide (for Java) yyyy-mm-dd-hh server.log server.log server.log. Log4j Pattern. Pattern yyyy-mm yyyy-ww 1~59. (log4j ) 1~59. (log4j ) (jdk: = ) or DatePattern. DatePattern = yyyy-mm-dd server.log , server.log , DatePattern. Log Layout Character c OZServer module Category Name. Category name %c{2}. ) %c oz.server.servlet %c{1} servlet %c{2} server.servlet 96 FORCS Co., LTD

97 d m n p r. Log4j (ABSOLUTE, DATE, ISO8601). Log4j. ) [ %d{dd MM yyyy HH:mm:ss,SSS} ] [ :39:29,777 ] main INFO ozserver - OZServer... ) [ %d{iso8601} ] [ :39:29,777 ]main INFO ozserver - OZServer... message OZServer. ) %d{iso8601} [%t] %-5p %c{1} %x-%m :56:23,203[Handler 1] INFO MessageHandler C "\n". New Line. (ERROR, WARN, INFO, DEBUG). %p ) %d{iso8601} [%t] %-5p %c{1} %x-%m :56:23,203[Handler 1] INFO MessageHandler millisecond. ex) [%r] [2994] main INFO oz.server - OZServer... Thread. ex) t [%t] [Thread-2] INFO oz.server - Received a message % %. Log Date Format Symbol G Era designator Text AD FORCS Co., LTD 97

98 OZ Enterprise Server Administrator's Guide (for Java) 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 z Time zone Text Pacific Standard Time ' Escape for text Delimiter " Single quote sign Literal ' "yyyy.mm.dd G 'at' hh:mm:ss z" AD at 18:25:30 PDT "EEE, MMM d, "yy" Wed, July 10, '96 "h:mm a" 12:08 PM NT Event 98 FORCS Co., LTD

99 Instance MultiInstance WASName WASVersion Instance Instance true, false. ex) MultiInstance=true WAS. ex) WASName=WebLogic WAS. ex) WASVersion=7.1 : Instance, WAS WebLogic7.x, WebLogic8.x. active. true FORCS Co., LTD 99

100 OZ Enterprise Server Administrator's Guide (for Java) false ( ) alais fromsend tosend SMTPServer SMTPServerPort SMTPUserID SMTPUserPassword SMTPUserID_encrypted SMTPUserPassword_encry pted SendRetryCount mail.properties alias. alias. : (;) (,). ex) admin@forcs.com;oz@forcs.com admin@forcs.com,oz@forcs.com SMTP SMTP SMTP ID : SMTP. SMTP ID : SMTP. SMTP ID : SMTP ID ID ID. SMTP ID : SMTP. SendRetryPeriodTime ( : ) 100 FORCS Co., LTD

101 PrefixSubjectMessage FilterType FilterServiceCode : "[] + ". FilterServiceCode. FilterServiceCode ex) FilterServiceCode positive FilterServiceCode. FilterServiceCode ( ) ex) FilterServiceCode 123 negative 123, FilterServiceCode. : " - monitor.properties". :. FORCS Co., LTD 101

102 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\mail.properties Servlet {OZ_HOME}\WEB-INF\conf\mail.properties. mail.properties # # Main configuration of oz mail # #<alias>.active=false #<alias>.fromsend= #<alias>.tosend= #<alias>.smtpserver= #<alias>.smtpserverport=25 #<alias>.smtpuserid= #<alias>.smtpuserpassword= #<alias>.smtpuserid_encrypted= #<alias>.smtpuserpassword_encrypted= #<alias>.enablessl=false #<alias>.sendretrycount= #<alias>.sendretryperiodtime= #<alias>.prefixsubjectmessage= 102 FORCS Co., LTD

103 mail.properties active fromsend tosend SMTPServer SMTPServerPort SMTPUserID SMTPUserPassword SMTPUserID_encrypted SMTPUserPassword_enc rypted EnableSSL SendRetryCount... SMTP URL. SMTP. SMTP ID. SMTP ID. SMTP ID. SMTP. SSL. : jre1.4.2_12.. SendRetryPeriodTime. ( : ) PrefixSubjectMessage. mail.properties - ozmail.active=true ozmail.fromsend=oz@forcs.com ozmail.tosend= ozmail.smtpserver=mail.forcs.com ozmail.smtpserverport=25 ozmail.smtpuserid=userid ozmail.smtpuserpassword=userpassword #ozmail.smtpuserid_encrypted= #ozmail.smtpuserpassword_encrypted= #ozmail.enablessl=false #ozmail.sendretrycount= #ozmail.sendretryperiodtime= #ozmail.prefixsubjectmessage= - SSL FORCS Co., LTD 103

104 OZ Enterprise Server Administrator's Guide (for Java) ozmail.active=true ozmail.tosend= ozmail.smtpserver=smtp.gmail.com ozmail.smtpserverport=465 ozmail.smtpuserpassword=userpassword #ozmail.smtpuserid_encrypted= #ozmail.smtpuserpassword_encrypted= ozmail.enablessl=true #ozmail.sendretrycount=1 #ozmail.sendretryperiodtime=30 #ozmail.prefixsubjectmessage=[oz] 104 FORCS Co., LTD

105 Daemon {OZ_HOME}\conf\monitor.properties Servlet {OZ_HOME}\WEB-INF\conf\monitor.properties. monitor.properties # # configuraion of OZ Trasaction Monotior log # # # OZ. #. # # # Whether log or not # MONITOR.Active=true MONITOR.File=%OZ_HOME%/logs/monitor.log MONITOR.MaxBackupIndex=5 MONITOR.MaxFileSize=1MB MONITOR.ImmediateFlush=true MONITOR.TimePattern=yyyy-MM-dd HH:mm:ss.SSS FORCS Co., LTD 105

106 OZ Enterprise Server Administrator's Guide (for Java) monitor.properties Active File MaxBackuplndex MaxFileSize ImmediateFlush TimePattern.. Backup. Backup.... ( : yyyy-mmdd HH:mm:ss.SSS) csv.. MARK/THR_NAME/TIME/F_MEM/T_MEM/S_CODE/S_STATUS/S_PARAMS/C_IP/DB_SS/E_TIME MARK THR_NAME TIME F_MEM T_MEM S_CODE S_STATUS S_PARAMS C_IP DB_SS, "start", "end".., monitor.properties "TimePattern"... ( : MB) JVM. ( : MB). " "., "9001", "9002".. IP. DBMS ID. 106 FORCS Co., LTD

107 E_TIME, monitor.properties "TimePattern". 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> <oracle> SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid') <sybase> // 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; FORCS Co., LTD 107

108 OZ Enterprise Server Administrator's Guide (for Java) UPDATE UPPER GROUPID = 117; GET USER LIST GROUP = 118; GET GROUP LIST GROUP = 119; 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; 108 FORCS Co., LTD

109 GET ITEMINDEX LIST = 160; FINDE ITEM ITEMINDEX = 161; 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; FORCS Co., LTD 109

110 OZ Enterprise Server Administrator's Guide (for Java) // Datamodule GET DATAMODULE = 380; GET DEFAULT PARAMETER = 381; 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; 110 FORCS Co., LTD

111 // Application DataModule GET DATAMODULE APP = 520; // 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 111

112 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=8003 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 112 FORCS Co., LTD

113 path.sapclient.properties.file=%oz_home%/conf/sap.properties path.databind.properties.file=%oz_home%/conf/databind.properties path.ozservice.properties.file=%oz_home%/conf/ozservice.properties path.ozdbconfig.properties.file=%oz_home%/conf/dbconfig.xml path.ozudl.properties.file=%oz_home%/conf/ozudl.properties path.datasource.properties.file=%oz_home%/conf/datasource.properties path.mail.properties.file=%oz_home%/conf/mail.properties ozserver.properties (Servlet Type Server) # # Main configuration of ozserver/ozservlet # path.oz.server.home=%oz_running_path%/web-inf 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.ozservice.properties.file=%oz_home%/conf/ozservice.properties path.ozdbconfig.properties.file=%oz_home%/conf/dbconfig.xml path.ozudl.properties.file=%oz_home%/conf/ozudl.properties path.datasource.properties.file=%oz_home%/conf/datasource.properties path.mail.properties.file=%oz_home%/conf/mail.properties %OZ_HOME% %OZ_HOME% ozserver.properties path.oz.server.home. %OZ_RUNNING_PATH% FORCS Co., LTD 113

114 OZ Enterprise Server Administrator's Guide (for Java) %OZ_RUNNING_PATH%. "%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 path.ozudl.properties.file path.datasource.properties.file path.mail.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. ozudl.properties. datasource.properties. mail.properties. 114 FORCS Co., LTD

115 Daemon {OZ_HOME}\conf\ozservice.propeties Servlet {OZ_HOME}\WEB-INF\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 FORCS Co., LTD 115

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

117 Daemon {OZ_HOME}\conf\ozudl.propeties Servlet {OZ_HOME}\WEB-INF\conf\ozudl.propeties.. : ozudl.properties "OZ_USER_DEFINED_LOG.Active" "false". ozservice.properties # # configuraion of OZ User Defined log # OZ_USER_DEFINED_LOG.Active=false #OZ_USER_DEFINED_LOG.Class= OZ_UDL_MONITOR.Active=false #OZ_UDL_MONITOR.Class= ozservice.properties FORCS Co., LTD 117

118 OZ Enterprise Server Administrator's Guide (for Java) OZ_USER_DEFINED_LOG.Active OZ_USER_DEFINED_LOG.Class OZ_UDL_MONITOR.Active OZ_UDL_MONITOR.Class. "true", "false". : RDB RDB (UDS, Http ).. "OZ_USER_DEFINED_LOG.Active=true".. "true", "false". "OZ_UDL_MONITOR.Active=true". 118 FORCS Co., LTD

119 Daemon {OZ_HOME}\conf\repository.propeties Servlet {OZ_HOME}\WEB-INF\conf\repository.propeties. repository.properties ### ### Repository Properties ### # RDB, BUILTIN, NONE REPOSITORY_TYPE = RDB # DB alias in /conf/db.properties to use repository # note: ignored if REPOSITORY_TYPE is BUILTIN REPOSITORY_DB_ALIAS = mssql_test REPOSITORY_FILE_PATH = %OZ_HOME%/repository_files/ REPOSITORY_QUERY_MAXBACKUPINDEX = 5 REPOSITORY_QUERY_MAXFILESIZE = 1MB REPOSITORY_QUERY_IMMEDIATEFLUSH = true #BackUp History for None Type #REPOSITORY_NONE_BACKUP=false #REPOSITORY_NONE_BACKUP_PATH=%OZ_HOME%/repository_files_bak/ #REPOSITORY_NONE_BACKUP_ITEM_COUNT=10 FORCS Co., LTD 119

120 OZ Enterprise Server Administrator's Guide (for Java) #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. REPOSITORY_HISTORY_ITEM_VALID_DAYS = 10 #Temp Directory REPOSITORY_TEMP_DIRECTORY=%OZ_HOME%/temp #Get Repository Items (Get Method) #REPOSITORY_ACCESS_BY_HTTP_GET=false #REPOSITORY_HTTP_GET_CHECK_SESSION=false 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. None. None. None. None FORCS Co., LTD

121 QUERY_MAXBACKUPINDEX QUERY_MAXFILESIZE QUERY_IMMEDIATEFLUSH DB_ALIAS REPOSITORY_TEMP_DIREC TORY REPOSITORY_ACCESS_BY_ HTTP_GET REPOSITORY_HTTP_GET_C HECK_SESSION BUILTIN DB. BUILTIN DB. BUILTIN DB. db.properties Alias DB Repository. (*.czo, *.obj_stream.zip). Get. Get. : true HTTP. 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 121

122 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\sap.propeties Servlet {OZ_HOME}\WEB-INF\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= #<alias>.maxcnt= 122 FORCS Co., LTD

123 #<alias>.timeout= #<alias>.timeoutcheckperiod= #<alias>.istrace=false #<alias>.doconnectioncheck= ### TYPE2 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.r3name= #<alias>.group= #<alias>.maxcnt= #<alias>.timeout= #<alias>.timeoutcheckperiod= #<alias>.istrace=false #<alias>.doconnectioncheck= ### TYPE3 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.sysno= #<alias>.gwhost= #<alias>.gwserv= #<alias>.maxcnt= #<alias>.timeout= #<alias>.timeoutcheckperiod= #<alias>.istrace=false #<alias>.doconnectioncheck= ### TYPE4 #<alias>.gwhost= #<alias>.gwserv= #<alias>.tpname= #<alias>.maxcnt= #<alias>.timeout= #<alias>.timeoutcheckperiod= #<alias>.istrace=false #<alias>.doconnectioncheck= FORCS Co., LTD 123

124 OZ Enterprise Server Administrator's Guide (for Java) ### TYPE5 #<alias>.gwhost= #<alias>.gwserv= #<alias>.tpname= #<alias>.tphost= #<alias>.maxcnt= #<alias>.timeout= #<alias>.timeoutcheckperiod= #<alias>.istrace=false #<alias>.doconnectioncheck= sap.properties <alias> <alias>.client <alias>.user <alias>.password <alias>.language <alias>.host <alias>.sysno <alias>.r3name <alias>.group <alias>.gwhost <alias>.gwserv <alias>.tpname <alias>.tphost <alias>.maxcnt <alias>.doconnectioncheck SAP. SAP. SAP. SAP. SAP. SAP. SAP. SAP.. SAP. SAP. JCO ID.. SAP Connnection. SAP. :. : sap.properties user, password ozencrypted.bat. " ". 124 FORCS Co., LTD

125 Daemon {OZ_HOME}\conf\spmgr.propeties Servlet {OZ_HOME}\WEB-INF\conf\spmgr.propeties. spmgr.properties # Secure Level [ high / middle / low ] # default : low client_message_secure_level = low # default : middle show_browser_secure_level=low user.multilogin= true #user.sessiontimeout = 10 ### ### Allow service function. (default is true, default is accepted)) ### allow_service_qd=false enable_service_repository=false allow_service_em=false allow_service_rm=false allow_service_rv=false allow_service_av=false FORCS Co., LTD 125

126 OZ Enterprise Server Administrator's Guide (for Java) allow_service_api=false allow_service_sh=false allow_service_ps=false spmgr.properties multilogin sesiontimout... : (user.multilogin 'false' ).. :. client_message_secu re_level high middle low,. Exception Name,.,. show_browser_secur e_level.. spmgr.properties show_browser_secure_level client_message_secure_level. high. middle. ( ) low. allow_service_qd ODI. :. 126 FORCS Co., LTD

127 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. Enterprise Manager. Repository Manager. OZR. OZA. API. Scheduler. Push Server. : enable_service_repository. enable_service_repository=true allow_service_qd allow_service_rv allow_service_av true O O false O X 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 true X X false X X true X X false X X FORCS Co., LTD 127

128 OZ Enterprise Server Administrator's Guide (for Java) allow_service_av true X X false X X enable_service_repository false, allow_service_qd, allow_service_rv, allow_service_av true. 128 FORCS Co., LTD

129 Daemon/Servlet {OZ_HOME}\conf\srmngr.propeties Servlet {OZ_HOME}\WEB-INF\conf\srmngr.propeties SDM SDM. srmngr.properties # default : false use_scheduled_data=false # 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. FORCS Co., LTD 129

130 OZ Enterprise Server Administrator's Guide (for Java) Daemon {OZ_HOME}\conf\uslmngr.properties Servlet {OZ_HOME}\WEB-INF\conf\uslmngr.properties User Security Logic. uslmngr.properties # oz3.0 USL configuration # # set whether use user security logic or not globaly # UseUserSecurityLogicVer30 = false 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. 130 FORCS Co., LTD

131 Daemon {OZ_HOME}\conf\xml.propeties Servlet {OZ_HOME}\WEB-INF\conf\xml.propeties xml. xml.properties # Configuration of XML parser used by OZ Server # #SYSTEM_DEFAULT Setting sax.parser=sun dom.parser=sun xpath.parser=xerces #xpath.parser=dom4j ################################################ # # parser List # - followings are able to used in SAX and DOM # # # SUN : parser.jar # CRIMSON : crimson.jar FORCS Co., LTD 131

132 OZ Enterprise Server Administrator's Guide (for Java) # XERCES : xerces.jar # SYSTEM_DEFAULT : javax.xml.parsers.documentbuilderfactory. xml.properties sax.parser dom.parser xpath.parser. SUN, CRIMSON, XERCES, SYSTEM_DEFAULT XML. SUN, CRIMSON, XERCES, SYSTEM_DEFAULT XPath. ( : XERCES) XERCES, DOM4J : DOM4J. 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. 132 FORCS Co., LTD

133 FORCS Co., LTD 133

134 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: 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. 134 FORCS Co., LTD

135 (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 135

136 OZ Enterprise Server Administrator's Guide (for Java) url ip port HTTP-Server (Servlet) URL TCP-Server (Daemon) Address TCP-Server (Daemon) Port -url: 1 -ip: port: 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 usl USL (repository.dn ) -rpt.dn.- url: Commands Command. [ ] Type 1. {} Type 2. () Type 3. -help. : ozcntrl -help -regsrv 136 FORCS Co., LTD

137 .. : 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: port:8003 -version.. : ozcntrl version[serverinfo] ) ozcntrl version ozcntrl version url: ozcntrl version ip: port:8080 id:admin pwd:admin -local.version -version, ozcntrl ozsfw51.jar. FORCS Co., LTD 137

138 OZ Enterprise Server Administrator's Guide (for Java) : ozcntrl local.version ) 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 -property PC. : ozcntrl property:[java-prorerty-name] ) ozcntrl property : java.runtime.name : "null". Repository Manager -repository.getcfg Reository Manager. : ozcntl repository.getcfg [SERVERLOCATION] ) ozcntl rpt.getcfg ozcntl rpt.getcfg url: -repository.dn Repository. : ozcntl repository.dn [SERVERINFO] ) ozcntl rpt.dn 138 FORCS Co., LTD

139 ozcntl rpt.dn url: : USL USL Server.class USL Client.class Classpath. ) ozcntrl rpt.dn url: Cache Manager -cache.getcfg. : ozcntl cache.getcfg [SERVERINFO] ) ozcntl cache.getcfg ozcntl cache.getcfg url: Connection Pool -cp.status. : ozcntrl cp.status [SERVERINFO] ) ozcntrl cp.status ozcntrl cp.status ip: port:8003 ozcntrl cp.status url: Log Manager -log.getcfg. : ozcntrl log.getcfg [SERVERINFO] ) ozcntrl log.getcfg ozcntrl log.getcfg ip: port:8003 ozcntrl log.getcfg url: -log.dn. FORCS Co., LTD 139

140 OZ Enterprise Server Administrator's Guide (for Java) : ozcntrl log.dn [SERVERINFO] {fn:filename} filename : ) ozcntrl -log.dn ozcntrl -log.dn -lp:info ozcntrl -log.dn -url: -log.realtime. : ozcntrl log.realtime ) ozcntrl log.realtime Monitor -mntr.dn. : ozcntrl mntr.dn [SERVERINFO] {fn:filename} filename : ) ozcntrl -mntr.dn ozcntrl -mntr.dn -fn:d:/monitor.log ozcntrl -mntr.dn -url: Thread Dump threaddump Thread Dump. Jre 1.5. : ozcntrl threaddump ) ozcntrl threaddump Builtin DB -builtin.repair query.log db_file.script. : ozcntrl builtin.repair [SERVERINFO] 140 FORCS Co., LTD

141 ) ozcntrl -builtin.repair ozcntrl -builtin.repair ip: port:8003 ozcntrl -builtin.repair url: DataBind -databind.getcfg DataBind Manager. "ConcurrentFetchSize" "ConcurrentFirstRow",. : ozcntrl -databind.getcfg [SERVERINFO] filename : ) ozcntrl -databind.getcfg ozcntrl -databind.getcfg ip: port:8003 ozcntrl -databind.getcfg -url: FORCS Co., LTD 141

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

143 DataAction. Post SOAP DataModule Post SOAP DataAction Get wsdl HttpRequest "SOAPAction". HttpRequest "SOAPAction". URL "?wsdl" "GET" Response wsdl. URL "POST" SOAP. GET POST SOAP ozservice.properties "enable_webservice" "true". # # Main configuration of ozservice # enable_ozserver=true enable_webservice=true # FORCS Co., LTD 143

144 OZ Enterprise Server Administrator's Guide (for Java) (soap2_3_1.jar, mail.jar, activation.jar) (ozsfw51.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 144 FORCS Co., LTD

145 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 FORCS Co., LTD 145

146 OZ Enterprise Server Administrator's Guide (for Java) "USE-WEBSERVICE" "TRUE" license. WAS ODIService URL ODIService. ( URL " ODIService URL " : ODIService Operation. "OZAxisDataAction2Client.java". package sample; 146 FORCS Co., LTD

147 import java.io.bytearrayoutputstream; 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 = " 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(); FORCS Co., LTD 147

148 OZ Enterprise Server Administrator's Guide (for Java) sources[1].setname("address"); sources[1].settype(const_field.varchar); sources[1].setvalue("sample1"); sources[2] = new Param(); sources[2].setname("birthday"); sources[2].settype(const_field.date); sources[2].setvalue(" "); 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); 148 FORCS Co., LTD

149 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. FORCS Co., LTD 149

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

151 FORCS Co., LTD 151

152 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 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: 152 FORCS Co., LTD

153 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. 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%\ozsfw51.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 FORCS Co., LTD 153

154 OZ Enterprise Server Administrator's Guide (for Java) ozcar DB password admin ) 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 ) 154 FORCS Co., LTD

155 RDB, RDB. bin BuiltinToRDBConvert.bat BuiltinToRDBConvert.sh RDB. BuiltinToRDBConvert.bat\BuiltinToRDBConvert.sh RDB RDB,. off rem rem rem OZ BuiltinToRDBConvert 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. 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 FORCS Co., LTD 155

156 OZ Enterprise Server Administrator's Guide (for Java) set MAX_MEMORY=256 set MIN_MEMORY=128 set JAVA_OPTION= rem rem MSSQL SAMPLE rem rem set PATH=C:\Program Files\Forcs\OZ Xstudio 5.1\OZ Server 5.1\repository_files rem set DRIVER=com.microsoft.jdbc.sqlserver.SQLServerDriver rem set URL=jdbc:microsoft:sqlserver:// :1433;DatabaseName=DatabaseName rem set ID=sa rem set PWD=administrator rem set DATEFIELDTYPENAME=DATETIME rem rem ORACLE SAMPLE rem set PATH=C:\Program Files\Forcs\OZ XStudio 5.1\OZ Server 5.1\repository_files set DRIVER=oracle.jdbc.driver.OracleDriver set set ID=scott set PWD=tiger set DATEFIELDTYPENAME=DATE rem rem DB SAMPLE rem set PATH= set DRIVER= set URL= set ID= set PWD= set DATEFIELDTYPENAME= set OZSERVER_HOME=.. set OZLIBALL=%OZSERVER_HOME%\lib set OZJLIBALL=%OZSERVER_HOME%\UniversalDriver rem rem OZ Main Class rem set OZLIB=%OZLIB%;%OZLIBALL%\ozsfw51.jar; 156 FORCS Co., LTD

157 set OZLIB=%OZLIB%;%OZLIBALL%\log4j.jar set OZLIB=%OZLIB%;%OZLIBALL%\hsqldb.jar rem rem JDBC Driver for Oracle rem set OZLIB=%OZLIB%;%OZJLIBALL%\classes12.zip rem rem JDBC Driver for Mysql (5.1.5) rem set OZLIB=%OZLIB%;%OZJLIBALL%\mysql5.1.5.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 set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cisuz.jar set OZLIB=%OZLIB%;%OZJLIBALL%\db2jcc_license_cu.jar FORCS Co., LTD 157

158 OZ Enterprise Server Administrator's Guide (for Java) rem rem JDBC Driver for Uni-SQL rem set OZLIB=%OZLIB%;%OZJLIBALL%\unisqljdbc10.jar 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% oz.framework.repositoryex.adapter.builtintordbconvert "%PATH%" "%DRIVER%" "%URL%" "%ID%" "%PWD%" "%DATEFIELDTYPENAME%" pause BuiltinToRDBConvert.sh #!/bin/sh # # # OZ BuiltinToRDBConvert # # 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 158 FORCS Co., LTD

159 USER_CLASSPATH= MAX_MEMORY=256 MIN_MEMORY=128 JAVA_OPTION=-hotspot # # MSSQL SAMPLE # # PATH=C:\Program Files\Forcs\OZ Xstudio 5.1\OZ Server 5.1\repository_files # DRIVER=com.microsoft.jdbc.sqlserver.SQLServerDriver # URL=jdbc:microsoft:sqlserver:// :1433;DatabaseName=DatabaseName # ID=UserPwd # PWD=UserPwd # DATEFIELDTYPENAME=DATETIME # # ORACLE SAMPLE # # PATH=C:\Program Files\Forcs\OZ Xstudio 5.1\OZ Server 5.1\repository_files # DRIVER=oracle.jdbc.driver.OracleDriver # URL=jdbc:oracle:thin:@ :1521:ORCL # ID=UserID # PWD=UserPwd # DATEFIELDTYPENAME=DATE # # DB SAMPLE # PATH= DRIVER= URL= ID= PWD= DATEFIELDTYPENAME= OZSERVER_HOME=.. # # OZ Main Class # OZLIB=.:$OZSERVER_HOME/conf OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozsfw51.jar # FORCS Co., LTD 159

160 OZ Enterprise Server Administrator's Guide (for Java) # for User Data Set classes # OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozusl.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/hsqldb.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/servlet.jar # # Library for Logging, ZIP # OZLIB=$OZLIB:$OZSERVER_HOME/lib/log4j.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jazzlib.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 # # JDBC Driver for Mysql (5.1.5) # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/mysql5.1.5.jar # # JDBC Driver for Informix # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/ifxjdbc.jar # # JDBC Driver for Syabse # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/jconn2.jar 160 FORCS Co., LTD

161 # # JDBC Driver for IBM DB2 # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/db2java.zip # # JDBC Driver for Uni-SQL # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/unisqljdbc10.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 JAVA_OPTION="$JAVA_OPTION -mx$max_memory"m fi echo "" echo $OZLIB echo "" $JAVA_HOME/bin/java $JAVA_OPTION -classpath $OZLIB oz.framework.repositoryex.adapter.builtintordbconvert "$PATH" "$DRIVER" "$URL" "$ID" "$PWD" "$DATEFIELDTYPENAME". JAVA_HOME USER_CLASSPATH MAX_MEMORY.. JVM. FORCS Co., LTD 161

162 OZ Enterprise Server Administrator's Guide (for Java) MIN_MEMORY JAVA_OPTION PATH DRIVER URL ID PWD DATEFIELDTYPENAME JVM. "MAX_MEMORY", "MIN_MEMORY". : JAVA_OPTION.. RDB JDBC. RDB JDBC URL. RDB ID. RDB. RDB DBMS Date. ex) MSSQL : DATETIME ORACLE : DATE DB2 : TIMESTAMP SYBASE : DATETIME,,, / RDB. bin BuiltinToRDBConvert.bat RDB. ( "C:\repository_files", RDB DBMS MSSQL.) BuiltinToRDBConvert.bat... rem rem MSSQL RDB rem set PATH=C:\repository_files set DRIVER=com.microsoft.jdbc.sqlserver.SQLServerDriver set URL=jdbc:microsoft:sqlserver:// :1433;DatabaseName=Master set ID=UserID set PWD=UserPwd set DATEFIELDTYPENAME=DATETIME 162 FORCS Co., LTD

163 ... BuiltinToRDBConvert.bat. ( RDB.) - BuiltinToRDBConvert.bat BuiltinToRDBConvert.sh. -. PATH DB DB FORCS Co., LTD 163