webMethods Adapter for JDBC
Sample Connection Properties
Connection properties follow this pattern:
artConnection.<packageName>.<connectionName>.propertyGroup.property=value
For example:
artConnection.TestPkg_JDBC.connections.Oracle_LT.connectionEnabled=true
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.blockingTimeout=1000
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.expireTimeout=1000
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.heartBeatInterval=0
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.maximumPoolSize=10
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.minimumPoolSize=1
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.poolIncrementSize=1
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.poolable=true
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.startupBackoffSecs=10
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionManagerSettings.startupRetryCount=0
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.databaseName=orclcdb
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.datasourceClass=oracle.jdbc.pool.OracleDataSource
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.driverType=Default
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.networkProtocol=tcp
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.otherProperties=driverType\=thin
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.password={AES}kSoTK3xdu2nyV1SDA+W43g==
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.portNumber=1521
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.serverName=vmnxwebmadapter01
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.transactionType=LOCAL_TRANSACTION
artConnection.TestPkg_JDBC.connections.Oracle_LT.
connectionSettings.user=ORACLE_USER
Sample connecting to Microsoft SQL Server:
#Sample Generated Template
#Fri Dec 31 05:03:05 UTC 2021
artConnection.Default.connection.AIA_LT.connectionEnabled=false
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
blockingTimeout=1000
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
expireTimeout=1000
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
heartBeatInterval=0
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
maximumPoolSize=10
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
minimumPoolSize=1
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
poolIncrementSize=1
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
poolable=true
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
startupBackoffSecs=10
artConnection.Default.connection.AIA_LT.connectionManagerSettings.
startupRetryCount=0
artConnection.Default.connection.AIA_LT.connectionSettings.
databaseName=$env{CACHEDBNAME}
artConnection.Default.connection.AIA_LT.connectionSettings.
datasourceClass=com.microsoft.sqlserver.jdbc.SQLServerDataSource
artConnection.Default.connection.AIA_LT.connectionSettings.
networkProtocol=
artConnection.Default.connection.AIA_LT.connectionSettings.
otherProperties=
artConnection.Default.connection.AIA_LT.connectionSettings.
password={AES}kSoTK3xdu2nyV1SDA+W43g==
artConnection.Default.connection.AIA_LT.connectionSettings.
portNumber=$env{CACHEDBPORTNO}
artConnection.Default.connection.AIA_LT.connectionSettings.
serverName=$env{CACHEDBSERVER}
artConnection.Default.connection.AIA_LT.connectionSettings.
transactionType=LOCAL_TRANSACTION
artConnection.Default.connection.AIA_LT.connectionSettings.
user=$env{CACHEDBUSER}
Sample Polling Notification Properties
Polling Notification properties follow this pattern:
artNotification.<packageName>.<notificationName>.propertyGroup.property=value
For example:
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
connectionAlias=com.webmethods.adapters.jdbc.mssql\:TestMSSQL
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
extendedStatus.notificationImmediate=true
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
extendedStatus.notificationInterval=10
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
extendedStatus.notificationOverlap=false
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
notificationEnabled=false
artNotification.TestJDBC.notifications.JDB1020.JDB1020_Notification.
userName=Administrator
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
connectionAlias=com.webmethods.adapters.jdbc.mssql\:TestMSSQL
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
extendedStatus.notificationImmediate=false
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
extendedStatus.notificationInterval=60
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
extendedStatus.notificationOverlap=false
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
notificationEnabled=false
artNotification.TestJDBC.notifications.deletion.DN_SpChar.
userName=Administrator