webmethods connection

Oracle連接：jdbc:oracle:thin:@10.xxx.xx.xx:port:server name

Oracle驅動：oracle.jdbc.driver.OracleDriver

SQL SERVER連接：jdbc:sqlserver://10.xxx.xx.xx:port;databasename=xxx

SQL SERVER驅動：com.microsoft.sqlserver.jdbc.SQLServerDriver

Informix連接：1jdbc:informix-sqli://10.xxx.xx.xx:port/ait:INFORMIXSERVER=xxx;DB_LOCALE=xxx;

2jdbc:informix-sqli://10.xxx.xx.xx:port/skyone:INFORMIXSERVER=xxx;DB_LOCALE=xx;IFX

_USE_STRENC=true;

Informix驅動：com.informix.jdbc.IfxDriver

(DB文件在SOSTWARE AG/IS/Packages/WMDB/config/jdbc)

TN:

Oracle:Database URL: jdbc:wm:oracle://10.XXX.XX.XX:PORT;SID=XX

SQL Server:Database URL:jdbc:wm:sqlserver://localhost:1433;databaseName=XXX;SelectMethod=cursor

連接名：com.informix.jdbc.IfxDriver

連接URL：jdbc:informix-sqli://XXX:1526/sample:informixserver=XXX;user=XXX;password=XXX

Informix JDBCDriver download URL

https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?S_PKG=370jC5de&S_SRCID=ifxjdbc&source=ifxjdbc&S_TACT=&S_CMP=&ibm-continue=Continue&l=English+U.S.

MWM:

新建默認的內部數據庫
E:\SoftwareAG82\MWS\bin>mws new -Dserver.name=wm82 -Dhttp.port=8585
JAVA_HOME: E:\SoftwareAG82\jvm\jvm160_32
MWS_HOME:  E:\SoftwareAG82\MWS
WM_HOME:   E:\SoftwareAG82\MWS\..
Creating new server instance. Please wait...
Buildfile: E:\SoftwareAG82\MWS\server\deploy.xml
Successfully created. Please see new.log for details and start server instance t
o complete initialization.
---------------------------------------------------------------------------
新建外部數據庫：
E:\SoftwareAG82\MWS\bin>mws new -Dserver.name=Sqlserver104 -Dhttp.port=8585
-Ddb.type=sqlserver -Ddb.driver=com.wm.dd.jdbc.sqlserver.SQLServerDriver

-Ddb.url=jdbc:wm:sqlserver://10.XXX.XX.XXX:1433;databaseName=xxx -Ddb.username=xxx -Ddb.password=xxx

安装oracle：
通過 webMethods 自帶 EDIINTAS2 DB Script 建立 Database

– 在目錄 webMethods82\common\db\scripts 下

  (在安裝webMethods時要選擇Database組件)

WMDB(JDBCAdapter):安装ojdbc14.jar,ojdbc14_g.jar,ocijdbc10.dll,classes12.jar等必要插件至E:\SoftwareAG82\IS\lib\jars(JDBC oci支持c++,VB可快速获得缓存,thin 支持Java)

SAP:安装sapidoc3.jar,sapjco.dll,sapjco.jar等必要插件至E:\SoftwareAG82\IS\Packages\wmSAP\code\jars\static(8.2)

安装sapidoc3.jar,sapjco.dll,sapjco.jar等必要插件至E:\SoftwareAG82\IS\Instances\default\packages\wmSAP\code\jars\static(9.12)

验证SAP ADA：cd至插件目录输入java -jar sapjco3.jar

java heap space:

• 以編輯方式打開 IntegrationServer \bin\server.bat

– 調整內存大小

• setJAVA_MIN_MEM=128M

• setJAVA_MAX_MEM=1024M

– 調整 JVM 目錄

• SETJAVA_DIR=\ webMethods \ jvm \win142(8.2)

set SOFTWARE AG\profiles\IS_default\configuration\custom_wrapper.conf/wrapper.conf JAVA_MIN/MAX_MEM
set IS/BIN/migrate/migrate.bat JAVA_MIN/MAX_MEM
set SOFTWARE AG\profiles\IS_default\bin/setenv.bat JAVA_MIN/MAX_MEM(9.12)