untitled

Size: px
Start display at page:

Download "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) 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.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> select <oracle> SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid') <sybase> select // 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 # # 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

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Enterprise Server Administrator's Guide (for Java) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Enterprise

More information

untitled

untitled Push... 2 Push... 4 Push... 5 Push... 13 Push... 15 1 FORCS Co., LTD A Leader of Enterprise e-business Solution Push (Daemon ), Push Push Observer. Push., Observer. Session. Thread Thread. Observer ID.

More information

untitled

untitled FORCS Co., LTD 1 OZ Scheduler User's Guide 2 FORCS Co., LTD .,. Manual Getting Started Getting Started Description....... FORCS Co., LTD 3 OZ Scheduler User's Guide API,,. API, UDS, USL, API API... 4 FORCS

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer

More information

untitled

untitled FORCS Co., LTD 1 2 FORCS Co., LTD FORCS Co., LTD 3 4 FORCS Co., LTD FORCS Co., LTD 5 ..,,..... 6 FORCS Co., LTD ,. Shell Command, Shell Command.,. Getting Started....,.. FORCS Co., LTD 7 WAS API, OZC,

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting Started 'OZ

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started (ver 5.1) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting

More information

untitled

untitled FORCS Co., LTD 1 OZ Query Designer User's Guide 2 FORCS Co., LTD FORCS Co., LTD 3 OZ Query Designer User's Guide 4 FORCS Co., LTD FORCS Co., LTD 5 OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS

More information

untitled

untitled FORCS Co., LTD 1 OZ Query Designer User's Guide 2 FORCS Co., LTD FORCS Co., LTD 3 OZ Query Designer User's Guide 4 FORCS Co., LTD FORCS Co., LTD 5 OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS

More information

chapter1,2.doc

chapter1,2.doc JavaServer Pages Version 08-alpha copyright2001 B l u e N o t e all rights reserved http://jspboolpaecom vesion08-alpha, UML (?) part1part2 Part1 part2 part1 JSP Chapter2 ( ) Part 1 chapter 1 JavaServer

More information

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration

More information

Interstage5 SOAP서비스 설정 가이드

Interstage5 SOAP서비스 설정 가이드 Interstage 5 Application Server ( Solaris ) SOAP Service Internet Sample Test SOAP Server Application SOAP Client Application CORBA/SOAP Server Gateway CORBA/SOAP Gateway Client INTERSTAGE SOAP Service

More information

Interstage4 설치가이드

Interstage4 설치가이드 Interstage Application Server V501 Operation Guide Internet 1 1 1 FJApache FJApache (WWW (WWW server) server) - - file file - - 2 2 InfoProviderPro InfoProviderPro (WWW (WWW server) server) - - file file

More information

1

1 A Leader of Enterprise e-business Solution FORCS Co., LTD 1 WAS WebSphere SilverStream Apache Jserv Tomcat Resin Inprise Application Server BES Oracel OC4J(ORION) HPAS(Bluestone)8 JRun EAServer JEUS 3.0

More information

PCServerMgmt7

PCServerMgmt7 Web Windows NT/2000 Server DP&NM Lab 1 Contents 2 Windows NT Service Provider Management Application Web UI 3 . PC,, Client/Server Network 4 (1),,, PC Mainframe PC Backbone Server TCP/IP DCS PLC Network

More information

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Crash Unity SDK... Log & Crash Search. - Unity3D v4.0 ios

More information

Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET

Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET 135-080 679-4 13 02-3430-1200 1 2 11 2 12 2 2 8 21 Connection 8 22 UniSQLConnection 8 23 8 24 / / 9 3 UniSQL 11 31 OID 11 311 11 312 14 313 16 314 17 32 SET 19 321 20 322 23 323 24 33 GLO 26 331 GLO 26

More information

untitled

untitled FORCS Co., LTD 1 2 FORCS Co., LTD . Publishing Wizard Publishing Wizard Publishing Wizard Publishing Wizard FORCS Co., LTD 3 Publishing Wizard Publidhing Wizard HTML, ASP, JSP. Publishing Wizard [] []

More information

Remote UI Guide

Remote UI Guide Remote UI KOR Remote UI Remote UI PDF Adobe Reader/Adobe Acrobat Reader. Adobe Reader/Adobe Acrobat Reader Adobe Systems Incorporated.. Canon. Remote UI GIF Adobe Systems Incorporated Photoshop. ..........................................................

More information

Apache2 + Tomcat 5 + JK2 를 사용한 로드밸런싱과 세션 복제 클러스터링 사이트 구축

Apache2 + Tomcat 5 + JK2 를 사용한 로드밸런싱과 세션 복제 클러스터링 사이트 구축 Apache2 + Tomcat 5 + JK2 : 2004-11-04 Release Ver. 1.0.0.1 Email : ykkim@cabsoftware.com Apache JK2 ( )., JK2 Apache2 JK2. 3 - JK2, Tomcat -.. 3, Stress ( ),., localhost ip., 2. 2,. Windows XP., Window

More information

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770> i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,

More information

슬라이드 1

슬라이드 1 NeoDeveloper 설치가이드 차례 1. 환경 3 2. 설치 3 2.1 웹서버설치 3 Tomcat 7 3 JDK 1.6 3 2.2 NeoDeveloper 설치 3 Neo Developer 서버구성 3 Demo용 User Application 구성 4 Neo Developer 서버 Data File 4 Client 개발 Tool 설치 4 3. 설정 5 3.1

More information

No Slide Title

No Slide Title J2EE J2EE(Java 2 Enterprise Edition) (Web Services) :,, SOAP: Simple Object Access Protocol WSDL: Web Service Description Language UDDI: Universal Discovery, Description & Integration 4. (XML Protocol

More information

Solaris Express Developer Edition

Solaris Express Developer Edition Solaris Express Developer Edition : 2008 1 Solaris TM Express Developer Edition Solaris OS. Sun / Solaris, Java, Web 2.0,,. Developer Solaris Express Developer Edition System Requirements. 768MB. SPARC

More information

uFOCS

uFOCS 1 기 : 기 UF_D_V250_002 기 기 기 품 ufocs 기 v2.5.0 히기기기기기기기기기 기 Manual 기 version 기 3.2 기품 2011.7.29 히기 345-13 1 Tel : 02-857-3051 Fax : 02-3142-0319 : http://www.satu.co.kr 2010 SAT information Co., Ltd. All

More information

Microsoft Word - Server Guide-1.doc

Microsoft Word - Server Guide-1.doc 목 차 Ⅰ. 시작하기전에 4 본매뉴얼의목적.. 5 본매뉴얼구성..... 5 매뉴얼로드맵...... 6 Ⅱ. 오즈엔터프라이즈서버소개... 7 오즈엔터프라이즈서버개요...... 8 오즈엔터프라이즈서버특징... 8 오즈엔터프라이즈서버아키텍처.... 10 Ⅲ. 오즈엔터프라이즈서버설치및실행..... 11 시스템요구사항... 12 오즈엔터프라이즈서버설치.. 12 서버세팅.....

More information

J2EE & Web Services iSeminar

J2EE & Web Services iSeminar 9iAS :, 2002 8 21 OC4J Oracle J2EE (ECperf) JDeveloper : OLTP : Oracle : SMS (Short Message Service) Collaboration Suite Platform Email Developer Suite Portal Java BI XML Forms Reports Collaboration Suite

More information

untitled

untitled Memory leak Resource 力 金 3-tier 見 Out of Memory( 不 ) Memory leak( 漏 ) 狀 Application Server Crash 理 Server 狀 Crash 類 JVM 說 例 行說 說 Memory leak Resource Out of Memory Memory leak Out of Memory 不論 Java heap

More information

Backup Exec

Backup Exec (sjin.kim@veritas.com) www.veritas veritas.co..co.kr ? 24 X 7 X 365 Global Data Access.. 100% Storage Used Terabytes 9 8 7 6 5 4 3 2 1 0 2000 2001 2002 2003 IDC (TB) 93%. 199693,000 TB 2000831,000 TB.

More information

OZ-LMS TM OZ-LMS 2008 OZ-LMS 2006 OZ-LMS Lite Best IT Serviece Provider OZNET KOREA Management Philosophy & Vision Introduction OZNETKOREA IT Mission Core Values KH IT ERP Web Solution IT SW 2000 4 3 508-2

More information

untitled

untitled PowerBuilder 連 Microsoft SQL Server database PB10.0 PB9.0 若 Microsoft SQL Server 料 database Profile MSS 料 (Microsoft SQL Server database interface) 行了 PB10.0 了 Sybase 不 Microsoft 料 了 SQL Server 料 PB10.0

More information

1217 WebTrafMon II

1217 WebTrafMon II (1/28) (2/28) (10 Mbps ) Video, Audio. (3/28) 10 ~ 15 ( : telnet, ftp ),, (4/28) UDP/TCP (5/28) centralized environment packet header information analysis network traffic data, capture presentation network

More information

Chap7.PDF

Chap7.PDF Chapter 7 The SUN Intranet Data Warehouse: Architecture and Tools All rights reserved 1 Intranet Data Warehouse : Distributed Networking Computing Peer-to-peer Peer-to-peer:,. C/S Microsoft ActiveX DCOM(Distributed

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 Synergy EDMS www.comtrue.com opyright 2001 ComTrue Technologies. All right reserved. - 1 opyright 2001 ComTrue Technologies. All right reserved. - 2 opyright 2001 ComTrue Technologies. All right reserved.

More information

교육2 ? 그림

교육2 ? 그림 Interstage 5 Apworks EJB Application Internet Revision History Edition Date Author Reviewed by Remarks 1 2002/10/11 2 2003/05/19 3 2003/06/18 EJB 4 2003/09/25 Apworks5.1 [ Stateless Session Bean ] ApworksJava,

More information

초보자를 위한 ADO 21일 완성

초보자를 위한 ADO 21일 완성 ADO 21, 21 Sams Teach Yourself ADO 2.5 in 21 Days., 21., 2 1 ADO., ADO.? ADO 21 (VB, VBA, VB ), ADO. 3 (Week). 1, 2, COM+ 3.. HTML,. 3 (week), ADO. 24 1 - ADO OLE DB SQL, UDA(Universal Data Access) ADO.,,

More information

Corporate PPT Template

Corporate PPT Template Tech Sales Consultant Oracle Corporation What s New in Oracle9iAS Forms? Why upgrade Oracle Forms to the WEB? Agenda Oracle9i Forms Web Oracle9i Forms Oracle9i Forms Oracle9i Forms What s NEW in Oracle

More information

Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer

Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer Domino, Portal & Workplace WPLC FTSS Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer ? Lotus Notes Clients

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 1,..... @ 1 Green Project 1991 Oak Java 1995. 5 December '90 by Patrick Naughton, Mike Sheridan and James Gosling Embedded in various consumer electronic device 1992. 9. 3 Star 7 1993 www portability

More information

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper Windows Netra Blade X3-2B( Sun Netra X6270 M3 Blade) : E37790 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs,

More information

Business Agility () Dynamic ebusiness, RTE (Real-Time Enterprise) IT Web Services c c WE-SDS (Web Services Enabled SDS) SDS SDS Service-riented Architecture Web Services ( ) ( ) ( ) / c IT / Service- Service-

More information

User's Guide Manual

User's Guide Manual 1. 롯데 통합구매 시스템 사용자 매뉴얼 (공급사용) 2006.01-1 - 문서 이력(Revision History) Date Version Description Author(s) 2006/01 V1.0 사용자 매뉴얼 - 공급사용 롯데CFD 주) 이 사용자 안내서의 내용과 롯데 통합구매 시스템은 저작권법과 컴퓨터 프로그램 보호법으로 보호 받고 있으며, 롯데CFD의

More information

<목 차 > 제 1장 일반사항 4 I.사업의 개요 4 1.사업명 4 2.사업의 목적 4 3.입찰 방식 4 4.입찰 참가 자격 4 5.사업 및 계약 기간 5 6.추진 일정 6 7.사업 범위 및 내용 6 II.사업시행 주요 요건 8 1.사업시행 조건 8 2.계약보증 9 3

<목 차 > 제 1장 일반사항 4 I.사업의 개요 4 1.사업명 4 2.사업의 목적 4 3.입찰 방식 4 4.입찰 참가 자격 4 5.사업 및 계약 기간 5 6.추진 일정 6 7.사업 범위 및 내용 6 II.사업시행 주요 요건 8 1.사업시행 조건 8 2.계약보증 9 3 열차운행정보 승무원 확인시스템 구축 제 안 요 청 서 2014.6. 제 1장 일반사항 4 I.사업의 개요 4 1.사업명 4 2.사업의 목적 4 3.입찰 방식 4 4.입찰 참가 자격 4 5.사업 및 계약 기간 5 6.추진 일정 6 7.사업 범위 및 내용 6 II.사업시행 주요 요건 8 1.사업시행 조건 8 2.계약보증 9 3.시운전 및 하자보증 10

More information

Microsoft PowerPoint - Smart CRM v4.0_TM 소개_20160320.pptx

Microsoft PowerPoint - Smart CRM v4.0_TM 소개_20160320.pptx (보험TM) 소개서 2015.12 대표전화 : 070 ) 7405 1700 팩스 : 02 ) 6012 1784 홈 페이지 : http://www.itfact.co.kr 목 차 01. Framework 02. Application 03. 회사 소개 01. Framework 1) Architecture Server Framework Client Framework

More information

1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder Service - efolder

1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder Service - efolder Embian efolder 설치가이드 efolder 시스템구성 efolder 설치순서 Installation commands 1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder

More information

02 C h a p t e r Java

02 C h a p t e r Java 02 C h a p t e r Java Bioinformatics in J a va,, 2 1,,,, C++, Python, (Java),,, (http://wwwbiojavaorg),, 13, 3D GUI,,, (Java programming language) (Sun Microsystems) 1995 1990 (green project) TV 22 CHAPTER

More information

FileMaker 15 ODBC 및 JDBC 설명서

FileMaker 15 ODBC 및 JDBC 설명서 FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker.

More information

Sun Java System Messaging Server 63 64

Sun Java System Messaging Server 63 64 Sun Java System Messaging Server 6.3 64 Sun Java TM System Communications Suite Sun Microsystems, Inc. 4150 Network Circle Santa Clara, CA 95054 U.S.A. : 820 2868 2007 7 Copyright 2007 Sun Microsystems,

More information

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate ALTIBASE HDB 6.1.1.5.6 Patch Notes 목차 BUG-39240 offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG-41443 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate 한뒤, hash partition

More information

vm-웨어-01장

vm-웨어-01장 Chapter 16 21 (Agenda). (Green),., 2010. IT IT. IT 2007 3.1% 2030 11.1%, IT 2007 1.1.% 2030 4.7%, 2020 4 IT. 1 IT, IT. (Virtualization),. 2009 /IT 2010 10 2. 6 2008. 1970 MIT IBM (Mainframe), x86 1. (http

More information

DocsPin_Korean.pages

DocsPin_Korean.pages Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google

More information

ODS-FM1

ODS-FM1 OPTICAL DISC ARCHIVE FILE MANAGER ODS-FM1 INSTALLATION GUIDE [Korean] 1st Edition (Revised 4) 상표 Microsoft, Windows 및 Internet Explorer는 미국 및 / 또는 다른 국가에서 Microsoft Corporation 의 등록 상표입 Intel 및 Intel Core

More information

MS-SQL SERVER 대비 기능

MS-SQL SERVER 대비 기능 Business! ORACLE MS - SQL ORACLE MS - SQL Clustering A-Z A-F G-L M-R S-Z T-Z Microsoft EE : Works for benchmarks only CREATE VIEW Customers AS SELECT * FROM Server1.TableOwner.Customers_33 UNION ALL SELECT

More information

Intro to Servlet, EJB, JSP, WS

Intro to Servlet, EJB, JSP, WS ! Introduction to J2EE (2) - EJB, Web Services J2EE iseminar.. 1544-3355 ( ) iseminar Chat. 1 Who Are We? Business Solutions Consultant Oracle Application Server 10g Business Solutions Consultant Oracle10g

More information

MySQL-Ch10

MySQL-Ch10 10 Chapter.,,.,, MySQL. MySQL mysqld MySQL.,. MySQL. MySQL....,.,..,,.,. UNIX, MySQL. mysqladm mysqlgrp. MySQL 608 MySQL(2/e) Chapter 10 MySQL. 10.1 (,, ). UNIX MySQL, /usr/local/mysql/var, /usr/local/mysql/data,

More information

28 THE ASIAN JOURNAL OF TEX [2] ko.tex [5]

28 THE ASIAN JOURNAL OF TEX [2] ko.tex [5] The Asian Journal of TEX, Volume 3, No. 1, June 2009 Article revision 2009/5/7 KTS THE KOREAN TEX SOCIETY SINCE 2007 2008 ko.tex Installing TEX Live 2008 and ko.tex under Ubuntu Linux Kihwang Lee * kihwang.lee@ktug.or.kr

More information

Assign an IP Address and Access the Video Stream - Installation Guide

Assign an IP Address and Access the Video Stream - Installation Guide 설치 안내서 IP 주소 할당 및 비디오 스트림에 액세스 책임 본 문서는 최대한 주의를 기울여 작성되었습니다. 잘못되거나 누락된 정보가 있는 경우 엑시스 지사로 알려 주시기 바랍니다. Axis Communications AB는 기술적 또는 인쇄상의 오류에 대해 책 임을 지지 않으며 사전 통지 없이 제품 및 설명서를 변경할 수 있습니다. Axis Communications

More information

Orcad Capture 9.x

Orcad Capture 9.x OrCAD Capture Workbook (Ver 10.xx) 0 Capture 1 2 3 Capture for window 4.opj ( OrCAD Project file) Design file Programe link file..dsn (OrCAD Design file) Design file..olb (OrCAD Library file) file..upd

More information

Apache Ivy

Apache Ivy JBoss User Group The Agile Dependency Manager 김병곤 fharenheit@gmail.com 20100911 v1.0 소개 JBoss User Group 대표 통신사에서분산컴퓨팅기반개인화시스템구축 Process Designer ETL, Input/Output, Mining Algorithm, 통계 Apache Hadoop/Pig/HBase/Cassandra

More information

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자 SQL Developer Connect to TimesTen 유니원아이앤씨 DB 팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 2010-07-28 작성자 김학준 최종수정일 2010-07-28 문서번호 20100728_01_khj 재개정이력 일자내용수정인버전

More information

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat Sun Server X3-2( Sun Fire X4170 M3) Oracle Solaris : E35482 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including

More information

Portal_9iAS.ppt [읽기 전용]

Portal_9iAS.ppt [읽기 전용] Application Server iplatform Oracle9 A P P L I C A T I O N S E R V E R i Oracle9i Application Server e-business Portal Client Database Server e-business Portals B2C, B2B, B2E, WebsiteX B2Me GUI ID B2C

More information

OPCTalk for Hitachi Ethernet 1 2. Path. DCOMwindow NT/2000 network server. Winsock update win95. . . 3 Excel CSV. Update Background Thread Client Command Queue Size Client Dynamic Scan Block Block

More information

The Self-Managing Database : Automatic Health Monitoring and Alerting

The Self-Managing Database : Automatic Health Monitoring and Alerting The Self-Managing Database : Automatic Health Monitoring and Alerting Agenda Oracle 10g Enterpirse Manager Oracle 10g 3 rd Party PL/SQL API Summary (Self-Managing Database) ? 6% 6% 12% 55% 6% Source: IOUG

More information

10.ppt

10.ppt : SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL

More information

1

1 04단원 컴퓨터 소프트웨어 1. 프로그래밍 언어 2. 시스템 소프트웨어 1/10 1. 프로그래밍 언어 1) 프로그래밍 언어 구분 각종 프로그래밍 언어에 대해 알아보는 시간을 갖도록 하겠습니다. 우리가 흔히 접하는 소프트웨어 들은 프로그래밍 언어로 만들어지는데, 프로그래밍 언어는 크게 2가지로 나눌 수 있습니다. 1 저급어 : 0과 1로 구성되어 있어, 컴퓨터가

More information

오늘날의 기업들은 24시간 365일 멈추지 않고 돌아간다. 그리고 이러한 기업들을 위해서 업무와 관련 된 중요한 문서들은 언제 어디서라도 항상 접근하여 활용이 가능해야 한다. 끊임없이 변화하는 기업들 의 경쟁 속에서 기업내의 중요 문서의 효율적인 관리와 활용 방안은 이

오늘날의 기업들은 24시간 365일 멈추지 않고 돌아간다. 그리고 이러한 기업들을 위해서 업무와 관련 된 중요한 문서들은 언제 어디서라도 항상 접근하여 활용이 가능해야 한다. 끊임없이 변화하는 기업들 의 경쟁 속에서 기업내의 중요 문서의 효율적인 관리와 활용 방안은 이 C Cover Story 05 Simple. Secure. Everywhere. 문서관리 혁신의 출발점, Oracle Documents Cloud Service 최근 문서 관리 시스템의 경우 커다란 비용 투자 없이 효율적으로 문서를 관리하기 위한 기업들의 요구는 지속적으로 증가하고 있다. 이를 위해, 기업 컨텐츠 관리 솔루션 부분을 선도하는 오라클은 문서관리

More information

Analyst Briefing

Analyst Briefing . Improve your Outlook on Email and File Management iseminar.. 1544(or 6677)-3355 800x600. iseminar Chat... Improve your Outlook on Email and File Management :, 2003 1 29.. Collaboration Suite - Key Messages

More information

chapter4

chapter4 Basic Netw rk 1. ก ก ก 2. 3. ก ก 4. ก 2 1. 2. 3. 4. ก 5. ก 6. ก ก 7. ก 3 ก ก ก ก (Mainframe) ก ก ก ก (Terminal) ก ก ก ก ก ก ก ก 4 ก (Dumb Terminal) ก ก ก ก Mainframe ก CPU ก ก ก ก 5 ก ก ก ก ก ก ก ก ก ก

More information

시스코 무선랜 설치운영 매뉴얼(AP1200s_v1.1)

시스코 무선랜 설치운영 매뉴얼(AP1200s_v1.1) [ Version 1.3 ] Access Point,. Access Point IP 10.0.0.1, Subnet Mask 255.255.255.224, DHCP Client. DHCP Server IP IP,, IP 10.0.0.X. (Tip: Auto Sensing Straight, Cross-over.) step 1]. step 2] LAN. step

More information

<49534F20323030303020C0CEC1F520BBE7C8C4BDC9BBE720C4C1BCB3C6C320B9D7204954534D20BDC3BDBAC5DB20B0EDB5B5C8AD20C1A6BEC8BFE4C3BBBCAD2E687770>

<49534F20323030303020C0CEC1F520BBE7C8C4BDC9BBE720C4C1BCB3C6C320B9D7204954534D20BDC3BDBAC5DB20B0EDB5B5C8AD20C1A6BEC8BFE4C3BBBCAD2E687770> ISO 20000 인증 사후심사 컨설팅 및 ITSM 시스템 고도화를 위한 제 안 요 청 서 2008. 6. 한 국 학 술 진 흥 재 단 이 자료는 한국학술진흥재단 제안서 작성이외의 목적으로 복제, 전달 및 사용을 금함 목 차 Ⅰ. 사업개요 1 1. 사업명 1 2. 추진배경 1 3. 목적 1 4. 사업내용 2 5. 기대효과 2 Ⅱ. 사업추진계획 4 1. 추진체계

More information

thesis

thesis ( Design and Implementation of a Generalized Management Information Repository Service for Network and System Management ) ssp@nile nile.postech.ac..ac.kr DPE Lab. 1997 12 16 GMIRS GMIRS GMIRS prototype

More information

1. Windows 설치 (Client 설치 ) 원하는위치에다운받은발송클라이언트압축파일을해제합니다. Step 2. /conf/config.xml 파일수정 conf 폴더에서 config.xml 파일을텍스트에디터를이용하여 Open 합니다. config.xml 파일에서, 아

1. Windows 설치 (Client 설치 ) 원하는위치에다운받은발송클라이언트압축파일을해제합니다. Step 2. /conf/config.xml 파일수정 conf 폴더에서 config.xml 파일을텍스트에디터를이용하여 Open 합니다. config.xml 파일에서, 아 LG U+ SMS/MMS 통합클라이언트 LG U+ SMS/MMS Client Simple Install Manual LG U+ SMS/MMS 통합클라이언트 - 1 - 간단설치매뉴얼 1. Windows 설치 (Client 설치 ) 원하는위치에다운받은발송클라이언트압축파일을해제합니다. Step 2. /conf/config.xml 파일수정 conf 폴더에서 config.xml

More information

Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 11 년 10 월 26 일수요일

Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 11 년 10 월 26 일수요일 Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 Introduce Me!!! Job Jeju National University Student Ubuntu Korean Jeju Community Owner E-Mail: ned3y2k@hanmail.net Blog: http://ned3y2k.wo.tc Facebook: http://www.facebook.com/gyeongdae

More information

LXR 설치 및 사용법.doc

LXR 설치 및 사용법.doc Installation of LXR (Linux Cross-Reference) for Source Code Reference Code Reference LXR : 2002512( ), : 1/1 1 3 2 LXR 3 21 LXR 3 22 LXR 221 LXR 3 222 LXR 3 3 23 LXR lxrconf 4 24 241 httpdconf 6 242 htaccess

More information

NoSQL

NoSQL MongoDB Daum Communications NoSQL Using Java Java VM, GC Low Scalability Using C Write speed Auto Sharding High Scalability Using Erlang Read/Update MapReduce R/U MR Cassandra Good Very Good MongoDB Good

More information

소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수

소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수 사용 설명서 TeraStation Pro II TS-HTGL/R5 패키지 내용물: 본체 (TeraStation) 이더넷 케이블 전원 케이블 TeraNavigator 설치 CD 사용 설명서 (이 설명서) 제품 보증서 www.buffalotech.com 소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를

More information

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS ( PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (http://ddns.hanwha-security.com) Step 1~5. Step, PC, DVR Step 1. Cable Step

More information

untitled

untitled 1-2 1-3 1-4 Internet 1 2 DB Server Learning Management System Web Server (Win2003,IIS) VOD Server (Win2003) WEB Server Broadcasting Server 1-5 1-6 MS Internet Information Server(IIS) Web MS-SQL DB ( )

More information

ETL_project_best_practice1.ppt

ETL_project_best_practice1.ppt ETL ETL Data,., Data Warehouse DataData Warehouse ETL tool/system: ETL, ETL Process Data Warehouse Platform Database, Access Method Data Source Data Operational Data Near Real-Time Data Modeling Refresh/Replication

More information

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) 8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop

More information

FileMaker ODBC 및 JDBC 가이드

FileMaker ODBC 및 JDBC 가이드 FileMaker ODBC JDBC 2004-2019 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker, FileMaker Cloud, FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker,

More information

단계

단계 TIBERO-WAS 연동 Guide 본문서에서는 Tibero RDBMS 에서제공하는 JDBC 통한 JEUS, WEBLOGIC 등다양한 WAS (Web Application Server) 제품과의연동방법을알아본다. Contents 1. Connection Pool 방식... 2 2. JEUS 연동... 3 2.1. JEUSMain.xml 설정 (Thin 방식

More information

1

1 1 1....6 1.1...6 2. Java Architecture...7 2.1 2SDK(Software Development Kit)...8 2.2 JRE(Java Runtime Environment)...9 2.3 (Java Virtual Machine, JVM)...10 2.4 JVM...11 2.5 (runtime)jvm...12 2.5.1 2.5.2

More information

Web Application Hosting in the AWS Cloud Contents 개요 가용성과 확장성이 높은 웹 호스팅은 복잡하고 비용이 많이 드는 사업이 될 수 있습니다. 전통적인 웹 확장 아키텍처는 높은 수준의 안정성을 보장하기 위해 복잡한 솔루션으로 구현

Web Application Hosting in the AWS Cloud Contents 개요 가용성과 확장성이 높은 웹 호스팅은 복잡하고 비용이 많이 드는 사업이 될 수 있습니다. 전통적인 웹 확장 아키텍처는 높은 수준의 안정성을 보장하기 위해 복잡한 솔루션으로 구현 02 Web Application Hosting in the AWS Cloud www.wisen.co.kr Wisely Combine the Network platforms Web Application Hosting in the AWS Cloud Contents 개요 가용성과 확장성이 높은 웹 호스팅은 복잡하고 비용이 많이 드는 사업이 될 수 있습니다. 전통적인

More information

목 차 Ⅰ. 일반사항 1 Ⅱ. 특기사항 3 Ⅲ. 물품내역 및 세부규격 8 Ⅳ. 주의사항 11-2 -

목 차 Ⅰ. 일반사항 1 Ⅱ. 특기사항 3 Ⅲ. 물품내역 및 세부규격 8 Ⅳ. 주의사항 11-2 - 대전마케팅공사 경영정보포털 구축 사업 패키지 소프트웨어 2식 구매 설치 시방서 (소프트웨어 2식) 2016. 06. 대전마케팅공사 경 영 지 원 파 트 목 차 Ⅰ. 일반사항 1 Ⅱ. 특기사항 3 Ⅲ. 물품내역 및 세부규격 8 Ⅳ. 주의사항 11-2 - Ⅰ. 일반사항 1. 목적 본 시방서는 대전마케팅공사가 추진하고 있는 경영정보포털 사업의 패키지 소프트웨어 도입을

More information

rmi_박준용_final.PDF

rmi_박준용_final.PDF (RMI) - JSTORM http://wwwjstormpekr (RMI)- Document title: Document file name: Revision number: Issued by: Document Information (RMI)- rmi finaldoc Issue Date: Status:

More information

Dialog Box 실행파일을 Web에 포함시키는 방법

Dialog Box 실행파일을 Web에 포함시키는 방법 DialogBox Web 1 Dialog Box Web 1 MFC ActiveX ControlWizard workspace 2 insert, ID 3 class 4 CDialogCtrl Class 5 classwizard OnCreate Create 6 ActiveX OCX 7 html 1 MFC ActiveX ControlWizard workspace New

More information

Intra_DW_Ch4.PDF

Intra_DW_Ch4.PDF The Intranet Data Warehouse Richard Tanler Ch4 : Online Analytic Processing: From Data To Information 2000. 4. 14 All rights reserved OLAP OLAP OLAP OLAP OLAP OLAP is a label, rather than a technology

More information

10X56_NWG_KOR.indd

10X56_NWG_KOR.indd 디지털 프로젝터 X56 네트워크 가이드 이 제품을 구입해 주셔서 감사합니다. 본 설명서는 네트워크 기능 만을 설명하기 위한 것입니다. 본 제품을 올바르게 사 용하려면 이 취급절명저와 본 제품의 다른 취급절명저를 참조하시기 바랍니다. 중요한 주의사항 이 제품을 사용하기 전에 먼저 이 제품에 대한 모든 설명서를 잘 읽어 보십시오. 읽은 뒤에는 나중에 필요할 때

More information

MySQL-Ch05

MySQL-Ch05 MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08 05 Chapter MySQL MySQL. (, C, Perl, PHP),. 5.1 MySQL., mysqldump, mysqlimport, mysqladmin, mysql. MySQL. mysql,. SQL. MySQL... MySQL ( ). MySQL,.

More information

FileMaker 15 WebDirect 설명서

FileMaker 15 WebDirect 설명서 FileMaker 15 WebDirect 2013-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker.

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 1 2 3 4 5 6-2- - - - - - -3- -4- ( Knowledge Cube, Inc. ) // www.kcube.co.kr -5- -6- (KM)? - Knowledge Cube, Inc. - - Peter Drucker - -7- KM Context KM Context KM Context KM Context KM Context KM KM KM

More information

본 기기에 대하여 언제, 어디서나 자유롭게 LG 넷하드를 구입해주셔서 감사합니다. LG 넷하드는 인터넷이 연결된 곳이라면 언제 어디서나 자유롭게 파일을 저장하고 공유할 수 있는 장치입니다. 2

본 기기에 대하여 언제, 어디서나 자유롭게 LG 넷하드를 구입해주셔서 감사합니다. LG 넷하드는 인터넷이 연결된 곳이라면 언제 어디서나 자유롭게 파일을 저장하고 공유할 수 있는 장치입니다. 2 이 설명서의 저작권은 (주)LG전자에 있습니다. (주)LG전자의 사전 허가 없이 설명서 내용의 일부 또는 전부를 무단 사용하거나 복제하는 것은 금지되어 있습니다. 본 기기에 대하여 언제, 어디서나 자유롭게 LG 넷하드를 구입해주셔서 감사합니다. LG 넷하드는 인터넷이 연결된 곳이라면 언제 어디서나 자유롭게 파일을 저장하고 공유할 수 있는 장치입니다. 2 본

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 Web Browser Web Server ( ) MS Explorer 5.0 WEB Server MS-SQL HTML Image Multimedia IIS Application Web Server ASP ASP platform Admin Web Based ASP Platform Manager Any Platform ASP : Application Service

More information

Sena Technologies, Inc. HelloDevice Super 1.1.0

Sena Technologies, Inc. HelloDevice Super 1.1.0 HelloDevice Super 110 Copyright 1998-2005, All rights reserved HelloDevice 210 ()137-130 Tel: (02) 573-5422 Fax: (02) 573-7710 E-Mail: support@senacom Website: http://wwwsenacom Revision history Revision

More information

Session XX-XX: Name

Session XX-XX: Name . Oracle on Linux iseminar.. 1544(or 6677)-3355 800x600. iseminar Chat. Oracle Corporation 9i Series iseminar: Presenters: 2002 9 25 Collaboration Suite Email Platform replace 1 with lesson number Developer

More information

PRO1_09E [읽기 전용]

PRO1_09E [읽기 전용] Siemens AG 1999 All rights reserved File: PRO1_09E1 Information and - ( ) 2 3 4 5 Monitor/Modify Variables" 6 7 8 9 10 11 CPU 12 Stop 13 (Forcing) 14 (1) 15 (2) 16 : 17 : Stop 18 : 19 : (Forcing) 20 :

More information

MPLAB C18 C

MPLAB C18 C MPLAB C18 C MPLAB C18 MPLAB C18 C MPLAB C18 C #define START, c:\mcc18 errorlevel{0 1} char isascii(char ch); list[list_optioin,list_option] OK, Cancel , MPLAB IDE User s Guide MPLAB C18 C

More information