untitled

Size: px

Start display at page:

Download "untitled"

あきおだいほうじ
5 years ago
Views:

1 Release 11.5/Composer

2 Unify Corporation All rights reserved. Sacramento California, USA No part of this may be reproduced, transmitted, transcribed, stored in a retrieval system, or translated into any language or computer language, in any form or by any means, electronic, mechanical, magnetic, optical, chemical, manual or otherwise without the prior written consent of Unify Corporation. Unify Corporation makes no representations or warranties with respect to the contents of this document and specifically disclaims any implied warranties of merchantability or fitness for any particular purpose. Further, Unify Corporation reserves the right to revise this document and to make changes from time to time in its content without being obligated to notify any person of such revisions or changes. The Software described in this document is furnished under a Software License Agreement. The Software may be used or copied only in accordance with the terms of the license agreement. It is against the law to copy the Software on tape, disk, or any other medium for any purpose other than that described in the license agreement. The Unify Corporation Documentation Group values and appreciates any comments you may have concerning our documents. Please address comments to: doc@unify.com (800) or (800) ; (916) FAX (916) UNIFY and DataServer are registered trademarks of Unify Corporation. Unify NXJ is a trademark of Unify Corporation. Java and J2EE are registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. JReport is a trademark of Jinfonet Corporation. IBM, Lotus, Lotus Notes, Cloudscape, and WebSphere are trademarks of International Business Machines Corporation in the United States, other countries, or both. CASAHL Technology and ecknowledge are registered trademarks of CASAHL Technology, Inc. in the U.S. and other countries.all other products or services mentioned herein may be registered trademarks, trademarks, or service marks of their respective manufacturers, companies, or organizations. Name: Guide Release: Unify NXJ 11.5/Composer Last Revision: July 13, :12 pm

4 3.0 NXJ Menu Administration JBoss IBM DB Informix MS SQL Server Oracle WebSphere WebSphere NXJ / WebSphere WebLogic WebLogic WebLogic NXJ / WebLogic Oracle OC4J or 10g OAS NXJ / Oracle BEA WebLogic IBM WebSphere JBoss JBoss XML OracleApplication Server 10g...57 ii Copyright 2005 Unify Corporation

1.2 NXJ NXJ If adding, then call... If deleting, then... If adding, then call... If searching, then.

11 NXJ SQL NXJ SQL SELECT NXJ Java DataBase Connectivity JDBC NXJ 45 Unify NXJ NXJ NXJ ID 1.3 NXJ NXJ NXJ Web NXJ NXJ Unify NXJ NXJ Unify NXJ 1 NXJ NXJ NXJ 13 ccmanage NXJ Copyright 2005 Unify Corporation 5

1.3.1 NXJ NXJ ActiveWorkflow NXJ NXJ NXJ ActiveWorkflow NXJ NXJ 1.3.2

2.2 NXJ NXJ ActiveReports NXJ 2 username@organizationname

18 NXJ NXJ Securing an NXJ Application 2.5 NXJ Control Center Properties - License Key Control Center Administration > Properties > License Key NXJ NXJ Interaction Server Application Designer NXJ NXJ NXJ Interaction Server Control Center Properties - License Key NXJ Interaction Server Enabled NXJ NXJ Control Center Properties - License Key Application Designer Enabled Unify Unify NXJ 1. NXJ Control Center Administration > Properties > License Key NXJ 2. License Key / 3. Submit 12 Copyright 2005 Unify Corporation

19 2.6 ccmanage Unify NXJ ControlCenter NXJ NXJ Control Center Management ccmanage ccmanage ccmanage 3 Windows > > Unify NXJ > > UNIX UNIFY_HOME/bin PATH ccmanage UNIX <UNIFY_HOME>/bin -text GUI ccmanage NXJ NXJ 1 NXJ NXJ : Oracle AS Java Standard Enterprise Oracle AS Oracle 1 NXJ ccmanage Oracle AS Containers for J2EE Standalone OC4J Copyright 2005 Unify Corporation 13

22 JBoss Windows > > Unify NXJ > > JBoss > UNIX <UNIFY_HOME>/jboss/bin/run.sh JBoss JBoss Windows JBoss 1. > > > > 2. Unify NXJ Development Server Unify NXJ Debug Server JBoss Windows JBoss X JBoss UNIX JBoss <UNIFY_HOME>/jboss/bin shutdown.sh -S 16 Copyright 2005 Unify Corporation

23 3 NXJ Application Package Administration NXJ NXJ Administration > Application Packages Application Package Administration Application Package Administration 3.1 NXJ NXJ NXJ Copyright 2005 Unify Corporation 17

24 NXJ ActiveForms : NXJ Control Center Administration ActiveForms ZIP ZIP output my_project Sources Output web-app WebNXJ my_project.zip ActiveForms <UNIFY_WORK>/ projects Deploy Application Package Finish 1. Control Center Administration > Application Packages Application Package Administration 2. Deploy new application package 18 Copyright 2005 Unify Corporation

25 NXJ Deploy Application Package Wizard 3. Archive Next NXJ NXJ NXJ Connection Mapping 4. Data Source Next Connection Environment Variables Next Organizations 7. Next Environment Variables Rules 8. Add Rule 9. Next : Environment Variables Rules Role Rules Role Rules Securing an NXJ Application 10. Next All Users No Users Use Rules Use Rules Building F Use Rules Copyright 2005 Unify Corporation 19

26 NXJ Match Value Building F 1 NXJ : Role Rules Finish 11. Finish NXJ Internet Explorer > > Internet Explorer Mozilla/Firefox Web "about:config" "network.http.maxpersistent-connections-per-server" 3.2 Redeploy Application Package Wizard Redeploy Application Package Wizard Deploy Application Package Wizard 20 Copyright 2005 Unify Corporation

4 Control Center Administration menu NXJ Application Packages ActiveWorkflow

30 4.1 NXJ Applications NXJ Control Center NXJ Control Center Administration NXJ Control Center Properties NXJ Edit Menu NXJ Control Center Properties 4.2 Menu Administration Menu Administration Control Center Administration > Menus Menu Administration Menu Administration NXJ / 24 Copyright 2005 Unify Corporation

4.2.1 Menu Administration NXJ name default label default short label NXJ

32 menu item columns menu region columns Unify NXJ 3 menu item max display description Unify NXJ 2 Quick Menu NXJ more Menu Administration Create New Menu Create Menu 2. Name Default Label Copyright 2005 Unify Corporation

4. Submit Unify NXJ Edit Menu - Menu Items 5. 28 Menu Administration Edit 6. Records Records 4.2.1.2 Menu Administration Remove 4.2.2 Edit Menu - Menu Items Menu Administration Edit Edit Menu > Menu Items Edit Menu - Menu Items 4.

33 4. Submit Unify NXJ Edit Menu - Menu Items Menu Administration Edit 6. Records Records Menu Administration Remove Edit Menu - Menu Items Menu Administration Edit Edit Menu > Menu Items Edit Menu - Menu Items Resource Paths NXJ /menu/<menuname> Copyright 2005 Unify Corporation 27

34 mymenu /menu/mymenu /entry/<packagename>/<entrypointname> <packagename> <entrypointname> mypackage myentryform /entry/mypackage/myentryform Edit Menu - Menu Items Submit Edit Menu - Menu Items Remove Submit 28 Copyright 2005 Unify Corporation

35 5 NXJ NXJ Unify NXJ Cloudscape NXJ Oracle Oracle : NXJ NXJ NXJ NXJ / JBoss IBM DB2 30 IBM DB2 Informix MS SQL Server Oracle 31 Informix 32 MS SQL Server 34 Oracle Copyright 2005 Unify Corporation 29

36 WebSphere WebLogic IBM DB2 Informix Oracle Oracle MS SQL Server 35 WebSphere 36 WebLogic Oracle 10g & OC4J Oracle 41 Oracle OC4J or 10g 5.1 JBoss JBoss IBM DB2 Informix MS SQL Oracle NXJ DBMS Unify NXJ Unify NXJ IBM DB2 DB2 NXJ : DB2 Type-2 CLI-based driver DB2 alias alias NXJ Type-4 alias 32KB User System 1. DB2 db2sql92 repository-db2.sql (<UNIFY_HOME>/lib/repository) db2sql92 -d ALIAS -a user/password < repository-db2.sql ALIAS alias user/password 30 Copyright 2005 Unify Corporation

37 CLI-based Jar DB2 bin PATH 2. NXJ JBoss 15 JBoss 3. DB2 JBoss a. DB2 <UNIFY_HOME>/lib/repository/db2-NXJCCDSds.xml <UNIFY_WORK>/jboss/server/default/deploy b. YOUR_HOST YOUR_PORT YOUR_DBNAME YOUR_SERVER YOUR_USER_NAME YOUR_PASSWORD 4. NXJ / NXJ ccmanage 13 ccmanage 5. ccmanage <UNIFY_HOME>/jboss/server/default/deploy cloudscape-nxjccds.xml 6. JBoss 15 JBoss Informix Informix NXJ 1. NXJ dbaccess <UNIFY_HOME>/lib/repository repository-informix.sql turbineuser-ifx.dat dbaccess - INFORMIXDIR Informix ; - INFORMIXSERVER Informix ; - PATH Informix bin Copyright 2005 Unify Corporation 31

38 Informix dbaccess dbaccess <repository> repository-informix.sql <repository> repository-informix.sql turbineuser-ifx.dat 2. NXJ JBoss default 15 JBoss 3. Informix JBoss a. Informix <UNIFY_HOME>/lib/repository/ informix-nxjccds-ds.xml <UNIFY_WORK>/jboss/server/default/deploy b. YOUR_HOST YOUR_PORT YOUR_DBNAME YOUR_SERVER YOUR_USER_NAME YOUR_PASSWORD 4. NXJ / NXJ ccmanage 13 ccmanage 5. <UNIFY_HOME>/jboss/server/default/deploy cloudscape-nxjcc-ds.xml 6. JBoss 15 JBoss MS SQL Server MS SQL Server NXJ 1. NXJ osql <UNIFY_HOME>/lib/repository "repository-mssql.sql" : Microsoft SQL Server "isql" CT-Library osql 32 Copyright 2005 Unify Corporation

39 2. NXJ JBoss 15 JBoss 3. MS SQL Server jtds JDBC Microsoft JDBC jtds JDBC MS SQL Server <UNIFY_HOME>/lib/repository/mssql-NXJCCDS-ds.xml JBoss <UNIFY_WORK>/jboss/server/default/deploy 4. YOUR_HOST YOUR_PORT YOUR_DBNAME YOUR_USER_NAME YOUR_PASSWORD Microsoft JDBC a. Microsoft JDBC Jar b. Jar mssqlserver.jar msbase.jar msutil.jar c. MS SQL Server <UNIFY_HOME>/lib/ repository/mssql-nxjccds-ds.xml JBoss <UNIFY_WORK>/jboss/server/default/deploy d. (mssql-nxjccds-ds.xml) YOUR_HOST YOUR_PORT YOUR_DBNAME YOUR_USER_NAME YOUR_PASSWORD class name: com.microsoft.jdbc.sqlserver.sqlserverdriver URL: jdbc:microsoft:sqlserver://your-host:your-port; SelectMethod=Cursor;DatabaseName=your-db-name 5. NXJ / Copyright 2005 Unify Corporation 33

40 NXJ ccmanage 13 ccmanage 6. NXJ cloudscape-nxjcc-ds.xml JBoss <UNIFY_HOME>/jboss/server/default/deploy/cloudscape-NXJCC-ds.xml 7. JBoss default 15 JBoss Oracle Oracle NXJ 1. NXJ sqlplus <UNIFY_HOME>/lib/repository "repository-oracle.sql" GRANT RESOURCE TO <username> ; 3MB 2. NXJ JBoss default 15 JBoss 3. Oracle JBoss a. Oracle <UNIFY_HOME>/lib/repository/oracle-NXJCCDS-ds.xml <UNIFY_WORK>/jboss/server/default/deploy/oracle-NXJCCDS-ds.xml b. YOUR_HOST YOUR_PORT YOUR_SID YOUR_USER_NAME YOUR_PASSWORD 4. jboss-service.xml a. <UNIFY_HOME>/jboss/server/default/conf 34 Copyright 2005 Unify Corporation

41 b. jboss-service.xml "Pad" <attribute name="pad">true</attribute> 5. NXJ / NXJ ccmanage 15 JBoss 6. NXJ cloudscape-nxjcc-ds.xml JBoss <UNIFY_HOME>/jboss/server/default/deploy/cloudscape-NXJCC-ds.xml 7. JBoss default 15 JBoss 5.2 WebSphere WebSphere IBM DB2 Informix MS SQL Oracle DBMS Unify NXJ Unify NXJ NXJ NXJ 30 IBM DB Informix 1 34 Oracle WebSphere WebSphere 5.X WebSphere Copyright 2005 Unify Corporation 35

42 : WebSphere Websphere 5.X NXJ nxjwebsphereconfig.properties a. $UNIFY_HOME/lib/websphere UNIFY_HOME NXJ b. 2. wsadmin.sh UNIX wsadmin.bat Windows a. $WS_HOME/Appserver/bin $WS_HOME WebSphere :./wsadmin.sh -p $UNIFY_HOME/lib/websphere/ nxjwebsphereconfig.properties -f $UNIFY_HOME/lib/websphere/ nxjwebsphereconfig.jacl 3. WebSphere NXJ ActiveReporting a. Servers > Application Servers b. NXJ c. Server Infrastructure Administration > Custom Properties d. Name: java.awt.headless Value: true NXJ / NXJ ccmanage 13 ccmanage WebSphere 5.3 WebLogic WebLogic EAR 36 Copyright 2005 Unify Corporation

43 5.3.1 NXJ 32 MS SQL Server 1 34 Oracle WebLogic WebLogic startweblogic.cmd Unix/Linux startweblogic.sh 1. java Windows: -Djava.security.auth.login.config=%UNIFY_HOME%/lib/weblogic/wasp_jaas.config %UNIFY_HOME% NXJ Unix/Linux: -Djava.security.auth.login.config=${UNIFY_HOME}/lib/weblogic/wasp_jaas.config ${UNIFY_HOME} NXJ 2. Oracle CLASSPATH jar Windows: %UNIFY_HOME%/lib/jdbcDrivers/JdbcOraWrapper.jar Unix/Linux: ${UNIFY_HOME}/lib/jdbcDrivers/JdbcOraWrapper.jar : WebLogic CLASSPATH Oracle jar ${UNIFY_HOME}/lib/jdbcDrivers/ojdbc14.jar 3. MS SQL Server CLASSPATH jar Windows $UNIFY_HOME/lib/jdbcDrivers/jtds-1.1.jar Unix/Linux ${UNIFY_HOME}/lib/jdbcDrivers/jtds-1.1.jar 4. NXJ ActiveReporting jar CLASSPATH Copyright 2005 Unify Corporation 37

44 Windows %UNIFY_WORK%/controlCenters/<CCName>/app/<CCName>Ear.ear/reportlib/ hsqldb.jar %UNIFY_WORK%/controlCenters/<CCName>/app/<CCName>Ear.ear/reportlib/ commons-codec-1.2.jar Unix ${UNIFY_WORK}/controlCenters/<CCName>/app/<CCName>Ear.ear/reportlib/ hsqldb.jar ${UNIFY_WORK}/controlCenters/<CCName>/app/<CCName>Ear.ear/reportlib/ commons-codec-1.2.jar ${UNIFY_WORK} NXJWork <CCName> 5. NXJ ActiveSOA jar CLASSPATH Windows %UNIFY_HOME%/wasp/lib/security-ng.jar %UNIFY_HOME%/lib/nxjwaspjaas.jar Unix/Linux ${UNIFY_HOME}/wasp/lib/security-ng.jar ${UNIFY_HOME}/lib/nxjwaspjaas.jar 6. WebLogic WebLogic WebLogic Server Console 1. < Oracle > a. Services > JDBC Connection Pools b. Configure a new JDBC Connection Pool c. Choose Database Continue Database Type: Oracle Database Driver: Other d. Define and test connection Test Driver Configuration Name: NXJCCDSPool Driver Classname: JdbcOraWrapperDriver URL: jdbc:oracle_clob:thin:@<host>:<port>:<sid> 38 Copyright 2005 Unify Corporation

45 Database User Name: <username> Password: <password> Confirm Password: <password> <host> <port> <sid> sid <username> <password> Test Driver Configuration Connection successful : CLASSPATH WebLogic Server Console JDBC driver is not on the CLASSPATH JdbcOraWrapperDriver Driver Classname JdbcOraWrapper.jar CLASSPATH ( 2 ) e. Create and Deploy < Microsoft SQL Server > a. Services > JDBC Connection Pools b. Configure a new JDBC Connection Pool... c. Choose Database Continue Database Type: Other Database Driver: Other d. Define Connection Continue Name: NXJCCDSPool Driver Classname: net.sourceforge.jtds.jdbc.driver URL: jdbc:jtds:sqlserver://<database host>:<database port>/<database name> Database User Name: <username> Password: <password> Confirm Password: <password> <database host> <database port> <database name> <username> <password> e. Test data connection Test Driver Configuration Connection successful f. Create and Deploy Copyright 2005 Unify Corporation 39

46 : WebLogic NXJCCDSPool 2. a. Services > JDBC Data Sources b. Configure a new JDBC Data Source c. Configure the data source Continue Name: NXJCCDS JNDI Name: NXJCCDS Honor Global Transactions: (check) d. Connect to connection pool Continue Pool Name: NXJCCDSPool e. Target the data source Create : WebLogic 8.1 non-xa : i. JDBC > Data Sources > Advanced ii. Emulate Two-Phase Commit for non-xa Driver 3. ActiveWorkflow JMS Connection Factory a. Services > JMS Connection Factories b. Configure a new JMS Connection Factory c. General Create Name: ConnectionFactory JNDI Name: ConnectionFactory d. WebLogic 8.1 Transactions XA Connection Factory Enabled e. Target and Deploy Apply 4. ActiveWorkflow JMS Destination Queue a. Services > JMS > Servers > WSStoreForwardInternalJMSServermyserver b. Destinations c. Configure a new JMS Queue d. General Create Name: BPMQueue JNDI Name: queue/bpmevents 40 Copyright 2005 Unify Corporation

47 5. ActiveSOA WebLogic 8.1 JMS Destination Queue a. Navigation Services > JMS > Servers > WSStoreForwardInternalJMSServermyserver b. Destinations c. Configure a new JMS Queue d. General Create Name: JMSQueue JNDI Name: queue/nxjwaspqueue 6. ActiveSOA WebLogic 8.1 JMS Destination Topic a. Navigation Services > JMS > Servers > WSStoreForwardInternalJMSServermyserver b. Destinations c. Configure a new JMS Topic d. General Create Name: JMSTopic JNDI Name: queue/nxjwasptopic : WebLogic mydomain WSStoreForwardInternalJMSServermyserver JMS server JMS WebLogic JMS WebLogic NXJ / NXJ ccmanage 13 ccmanage WebLogic 5.4 Oracle OC4J or 10g Oracle OAS EAR OAS Oracle Copyright 2005 Unify Corporation 41

48 : 10g 1 NXJ 2 ccmanage Oracle NXJ 34 Oracle OAS 1. Oracle 10g/OC4J version a. b. Application Server Control c. Application Server Control d. Administration : Oracle 10g Administration e. Services > JDBC Resources f. New Connection Pool - Name: NXJCC_ConnPool - Connection Factory Class: oracle.jdbc.pool.oracleconnectionpooldatasource - JDBC URL: jdbc:oracle:thin:@your-host:your-port:your-sid - Username: your-username - Password: your-password g. h. New Data Source - - 'Managed Data Source' Continue - Name: NXJCCDS - JNDI Location: NXJCCDS - Transaction Level: Global & Local Transaction - Connection Pool: NXJCC_ConnPool - Login Timeout (seconds): 1 42 Copyright 2005 Unify Corporation

49 2. NXJ ActiveWorkflow JMS Provider a. Application Server Control Administration b. Services > JMS Providers c. Destinations d. Create New e. Destination Type: Queue Destination Name: BPM Events Queue Description: A BPM Events Queue JNDI Location: queue/bpmevents Persistence file: f. OK 3. Oracle Java -Xms256m -Xmx1024m -XX:PermSize=64m -XX:MaxPermSize=128m 4. Oracle 10g Oracle - server.xml - http-web-site.xml - global-web-application.xml - application.xml 5. ActiveReport a. Administration b. Properties > Shared Libraries c. Create d. Shared Library Name: cc_libraries Shared Library Version: 1 e. Next f. 3 jar - hsqldb.jar controlcenter ear reportlib - itext.jar controlcenter ear reportlib - tools.jar jdk lib g. oc4j orion-application.xml controlcenter ear <imported-shared-libraries> <import-shared-library name= cc_libraries /> </imported-shared-libraries> : cc_libraries 6. UNIX Oracle 10g ActiveReports ActiveWorkflow DISPLAY Copyright 2005 Unify Corporation 43

50 a. Oracle Enterprise Manager b. OC4J home c. Administration d. Server Properties e. Command Line Options Java Options -Djava.awt.headless=true f. Enviroment Variables DISPLAY X YOUR-X-HOST:0.0 NXJ X X Xvbf Xvfb g. Apply NXJ / NXJ ccmanage 13 ccmanage Oracle 44 Copyright 2005 Unify Corporation

52 CLASSPATH BEA WebLogic BEA WebLogic Windows startwls.cmd UNIX startwls.sh BEA WebLogic weblogic81 : Oracle JDBC CLASSPATH.jar WebLogic Oracle.jar nls_charset12.zip CLASSPATH 2. JDBC Connection Pool a. BEA WebLogic NXJ Unify NXJ NXJ startweblogic startmanagedweblogic Windows > > WebLogic > Start Default Server b. BEA WebLogic Server Console Services > JDBC > Connection Pools c. Configure a new JDBC Connection Pool d. General IBM DB2 Name <pool name> URL Driver Classname Properties ACLName Password Open String Password jdbc:db2:<database name> COM.ibm.db2.jdbc.app.DB2Driver <user-name> <password> IBM Informix Name <pool name> URL Driver Classname Properties ACLName jdbc:informix-sqli://<host>:<port>/<database name>: INFORMIXSERVER=<database server name> : <host>= ; <port>= ; <database server name>= com.informix.jdbc.ifxdriver user=<user> 46 Copyright 2005 Unify Corporation

53 MS SQL Server 2000 Password Open String Password Name URL Driver Classname Properties ACLName Password Open String Password <password> <pool name> jdbc:jtds:sqlserver://<host>:<port> : <host>= ; <port>= net.sourceforge.jtds.jdbc.driver user=<user> <password> MySQL Name <pool name> URL Driver Classname Properties user = <user > ACL Name Password jdbc:mysql://<host>:<port>/<dbname> : <host>= ; <port>= ; <dbname>= com.mysql.jdbc.driver <password> Oracle Name <pool name> URL Driver Classname Properties ACLName Password Open String Password jdbc:oracle:thin:@<host>:<port>:<sid> : <host>= ; <port>= ; <sid> = SID oracle.jdbc.driver.oracledriver user=<user> <password> Sybase Name <pool name> URL Driver Classname Properties ACLName Password jdbc:sybase:tds:<host>:<port> : <host>= ; <port>= com.sybase.jdbc2.jdbc.sybdriver user=<user> <password> Copyright 2005 Unify Corporation 47

54 Unify DataServer Open String Password Name URL Driver Classname Properties ACL Name Password Open String Password <pool name> jdbc:simba:<host>:<port>/<dsn> : <host>= ; <port>= ; <DSN>= simba.jdbc.simbadriver user=<user> <password> e. f. DataServer i. ii. Prepared Statement Cache Size 0 iii. g. default h. 3. JDBC a. Services > JDBC > Tx Data Sources b. JDBC Tx Data Source c. Name: <data source name> JNDI Name: <data source name> Pool Name: <pool name> d. e. f. 48 Copyright 2005 Unify Corporation

55 6.2 IBM WebSphere IBM WebSphere Unify NXJ IBM Websphere Unify NXJ 1. WebSphere Application Server Administrative Console NXJ 2. J2C a. Security > JAAS Configuration > J2C Authentication Data b. New c. General OK Alias: NXJCCDS User ID: <username> Password: <password> <username>/<password> / <node>/nxjccds <node> WebSphere 3. NXJCCDS Oracle a. Resources > JDBC Providers b. New c. JDBC Providers User-defined JDBC Driver OK d. JDBC Provider General OK Name: JdbcOraWrapper Description: JDBC provider for the NXJ Control Center Data Repository running on Oracle. Classpath: ${UNIFY_HOME}/lib/jdbcDrivers/ojdbc14.jar ${UNIFY_HOME}/lib/jdbcDrivers/JdbcOraWrapper.jar Implementation Classname: JdbcOraWrapperConnectionPoolDataSource Copyright 2005 Unify Corporation 49

56 ${UNIFY_HOME} NXJ WebSphere UNIFY_HOME NXJ WebSphere Administrative Console e. JdbcOraWrapper f. Data Sources g. New h. General OK Name: NXJCCDS JNDI Name: NXJCCDS Database Helper Classname: com.ibm.websphere.rsadapter.oracledatastorehelper Component-managed Authentication Alias: <node>/nxjccds Container-managed Authentication Alias: <node>/nxjccds i. NXJCCDS j. Custom Properties k. New l. General OK Name: URL Value: <hostname> <port> Oracle 1521 <sid> SID Microsoft SQL Server a. Resources > JDBC Providers b. New c. JDBC Providers Microsoft JDBC driver for MSSQLServer 2000 OK d. JDBC Provider General OK Classpath MSSQLSERVER_JDBC_DRIVER_PATH WebSphere Environment -> Manage WebSphere Variables Microsoft Classpath jar e. Microsoft JDBC driver for MSSQLServer 2000 f. Data Sources g. New h. General OK 50 Copyright 2005 Unify Corporation

57 Name: NXJCCDS JNDI Name: NXJCCDS Component-managed Authentication Alias: <node>/nxjccds server Value 1433 portnumber Value OK 4. Resouces JDBC Prividers JDBC Providers 5. New Configuration 6. General JDBC Provider ApplyClick Unify NXJ General JDBC Unify NXJ DB2 Universal JDBC provider Scope (Type 4) Name DB2 Universal JDBC Driver Provider DB2 Legacy JDBC provider Description Classpath Native Library Path Implementati on Classname Scope DB2 Universal JDBC Driver-compliant Provider ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar ${UNIVERSAL_JDBC_DRIVER_PATH}/ db2jcc_license_cu.jar ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/ db2jcc_license_cisuz.jar ( ) com.ibm.db2.jcc.db2connectionpooldatasource (Type 2) Name DB2 Legacy CLI-based Type 2 JDBC Driver Informix Description Classpath Native Library Path Implementati on Classname DB2 JDBC2-compliant Provider ${DB2_JDBC_DRIVER_PATH}/db2java.zip ( ) COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource Copyright 2005 Unify Corporation 51

58 MS SQL Server 2000 MySQL Sybase JDBC Driver Scope Name Sybase JDBC Driver Description Classpath Native Library Path Implementati on Classname Sybase JDBC Driver ${SYBASE_JDBC_DRIVER_PATH}/jconn2.jar com.sybase.jdbc2.jdbc.sybconnectionpooldatasource Oracle JDBC Driver Scope Unify DataServer Name Description Classpath Native Library Path Implementati on Classname Oracle JDBC Driver Oracle JDBC Driver ${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar oracle.jdbc.pool.oracleconnectionpooldatasource 7. Apply 8. JDBC Providers Additional Data Sources Data Sources 9. Data Sources New Container managed persistence Component-managed Authentication Alias 10. Apply 11. Additinal Custom 52 Copyright 2005 Unify Corporation

59 12. DB2 JDBC provider (Type 4) DB2 JDBC provider (Type 2) Informix JDBC Driver Sybase JDBC Driver Oracle JDBC Thin Driver MSSQL Server 2000 Unify DataServer databasename servername portnumber databasename databasename servername portnumber URL 13. Apply JBoss JBoss 2 JBoss JBoss Unify NXJ JBoss Unify NXJ JBoss NXJ JBoss Copyright 2005 Unify Corporation 53

60 1. XML JBoss XML <UNIFY_WORK>\jboss\server\default\deploy\UnifyNXJ-<connection name>ds.xml. NXJ <C:\Unify\NXJWork\jboss\server\default\deploy\UnifyNXJ-tutorial-ds.xml 2. XML 1 C:\Unify\NXJWork\jboss\server\default\deploy\<yourXMLfile> 3. JDBC : <?xml version="1.0" encoding="utf-8"?> <datasources> <local-tx-datasource> <jndi-name>tutorial</jndi-name> <connection-url>jdbc:csv:c:/unify/nxjwork/projects/ tutorials/databases/inet/db</connection-url> <driver-class>com.inet.csv.csvdriver</driver-class> <user-name /> <password /> </local-tx-datasource> </datasources> 4. JBoss JDBC NXJ JDBC DBMS Unify NXJ DBMS JDBC.zip.jar <JBossInstallDir>/server/<serverName>/lib <JBossInstallDir> JBoss <servername> JBoss JDBC Unify NXJ 3 54 Copyright 2005 Unify Corporation

61 5. DB2 JBoss Windows run.bat UNIX run.sh DB2 Windows run.bat set JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;%JAVAC_JAR%;%RUNJAR% set JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;<SQLLIB>/java/ db2java.zip UNIX run.sh JAVA_OPTS="$JAVA_OPTS -Dprogram.name=$PROGNAME" JBOSS_CLASSPATH=$JBOSS_CLASSPATH:<SQLLIB>/java/db2java.zip <SQLLIB> DB2 JDBC JBoss XML 1. -ds.xml -ds.xml <datasources> <local-tx-datasource> <jndi-name>yourdatasourcename</jndi-name> <connection-url>yourjdbcurl</connection-url> <driver-class>yourjdbcdriverclass</driver-class> <user-name>yourusername</user-name> <password>yourpassword</password> </local-tx-datasource> </datasources> : yourdatasourcename yourjdbcurl JDBC URL yourjdbcdriverclass yourusername Copyright 2005 Unify Corporation 55

62 yourpassword URL IBM DB2 IBM Informix MS SQL Server 2000 MySQL Oracle Sybase Unify DataServe r 2. deploy <JBossInstallDir>/server/<serverName>/deploy : COM.ibm.db2.jdbc.app. DB2Driver com.informix.jdbc.ifxdrive r net.sourceforge.jtds.jdbc. Driver com.mysql.jdbc.driver <UNIFY_HOME>\lib\ jdbcdrivers\ downloads/api-jdbcstable.html. oracle.jdbc.driver. OracleDriver com.sybase.jdbc2. jdbc.sybdriver simba.jdbc.simbadriver <JBossInstallDir> JBoss <servername> JBoss jdbc:db2:<database name> : <database name> = ID jdbc:informix-sqli: //<host>:<port>/<database name>: INFORMIXSERVER=<database server name> : <host>= ; <port>= <database name>= <database server name>= jdbc:jtds:sqlserver://<host>:<port> : <host> = <port> = jdbc:mysql://<host>:<port>/<dbname> : <host>= ; <port>= ; <dbname>= jdbc:oracle:thin:@<host>:<port>:<sid> : <host> = <port> = <SID> = SID jdbc:sybase:tds:<host>:<port> : <host> = <port> = jdbc:simba:<host>:<port>/<dsn> : <host> = <port> = <DSN> = 3. JBoss JBoss 15 JBoss 56 Copyright 2005 Unify Corporation

63 6.4 OracleApplication Server 10g Unify NXJ OracleAS Unify NXJ Oracle Application OC4J Enterprise Edition OC4J <Oracle installation directory>/j2ee/<server name> : <Oracle installation directory> Oracle9iAS Containers for J2EE OC4J <server name> Unify NXJ home 3. java -jar oc4j.jar 4. 2 <Oracle installation directory>/j2ee/<server name> 5. config/rmi.xml rmi-server <port number> 6 6. java % java -jar admin.jar ormi://<localhost>:<port number> admin <administrative password> -application default -installdatasource -classname com.evermind.sql.orioncmtdatasource -url jdbc:oracle:thin:@<host>:<port>:<sid> -connectiondriver oracle.jdbc.oracledriver -location <data source name> -username <database username> -password <database password> : <localhost> ORMI <port number> ORMI Copyright 2005 Unify Corporation 57

64 <administrative password> ORMI <host> <port> <sid> ID <data source name> classname url URL connectiondriver JDBC location JNDI username password Enterprise Edition Appllication Server Control J2EE Applications 1. default 2. Resources Data Sources 3. Create Like Create Oracle 10g 4. Create 58 Copyright 2005 Unify Corporation

65 A Application Designer Applications C ccmanage Oracle AS Control Center ccmanage URL Control Center Administration Control Center Properties Control Center D Deploy Application Package E Edit Menu H Help Home L Login Logout M Menu Administration N NXJ Interaction Server NXJ Application Package Administration NXJ NXJ Q Quick Menu panel R resource paths S static content Copyright 2005 Unify Corporation 59

untitled

untitled Unify NXJ Release 12 2002-2008 Unify Corporation All rights reserved. Sacramento California, USA No part of this tutorial may be reproduced, transmitted, transcribed, stored in a retrieval system, or translated