Main Service



wm.art.admin.connection:listResources -> connDataNode
wm.art.admin.connection:getResourceConfiguration -> parameter / connectionMamagerProperties ( minimum / maximum pool set 설정 등)


Document


conndataNode

connectionAlias Adapters:GS_WM
packageName LpAdapters
connectionFactoryType com.wm.adapter.wmjdbc.connection.JDBCConnectionFactory
mcfDisplayName webMethods Adapter for JDBC Connection
connectionState enabled
hasError FALSE


parameter - Connection Info 리스트

parameters[0]/value TransactionType
parameters[1]/value DataSourceClass
parameters[2]/value ServerName
parameters[3]/value UserID
parameters[4]/value Password -> pwd 와 매핑 필요 Java Service Output
parameters[5]/value DatabaseName
parameters[6]/value PortNumber
parameters[7]/value NetworkProtocol
parameters[8]/value OtherProperties


Map



JAVA Service

getJDBCAdapterConnectionPassword - JAVA Service

INPUT : conenctionAlias
OUTPUT : pwd

public static final void getJDBCAdapterConnectionPassword(IData pipeline) throws ServiceException {

IDataCursor pipelineCursorIn = pipeline.getCursor();
String connectionAlias = IDataUtil.getString(pipelineCursorIn,"connectionAlias");
pipelineCursorIn.destroy();
String connPW = "";

try{
ConnectionDataNode connectionDataNode = ConnectionDataNodeManager.getConnectionDataNode(connectionAlias);
connPW = ((JDBCConnectionFactory)connectionDataNode.getConnectionResource().getManagerConnectionFcatory()).getPassword();
}

catch(Exception ex){
throw new ServiceException(ex.getMessage());
}

IDataCursor pipelineCursorOut = pipeline.getCursor();
IDataUtil.put(pipelineCursorOut, "pwd", connPW);
pipelineCursorOut.destroy();
}




추가 테스트

(Password) %parameters[4]/value% =8xuozYGC0Vk=LQyX2pwOEpdErHchsFCALA== (BASE64 Encode?)