IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

How to get connection attributes of an adapter connection? Update Connection Properties

  • 1.  How to get connection attributes of an adapter connection? Update Connection Properties

    Posted Thu October 13, 2016 09:56 AM

    Use Built-in service Name: wm.art.dev.connection:fetchConnectionMetadata
    Input Field:
    adapterTypeName: You can get this name by running pub.art:listRegisteredAdapters built-in service
    Sample Values:
    JDBCAdapter
    wmMQAdapter
    WmSAP

    Input Field:
    connectionFactoryType: You need to build this value by navigating the folders under an adapter package.
    Go thru this link for more details : websphere MQ Adapter - webMethods - Software AG Tech Community & Forums
    Sample Values:
    com.wm.adapter.wmjdbc.connection.JDBCConnectionFactory
    com.wm.adapter.wmmqadapter.connection.wmMQConnectionFactory
    com.wm.adapter.sap.spi.SAPConnectionFactory

    Now you can use these connection attributes as input fields for wm.art.dev.connection:updateConnectionNode under connectionSettings document. Then you can use this service to update connection properties of a JDBC, SAP connection etc


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: How to get connection attributes of an adapter connection? Update Connection Properties

    Posted Mon May 21, 2018 05:24 AM

    Hi Ravi Varma,

    When i tried to create a JDBC adapter using the flow service - wm.art.dev.connection:createConnectionNode
    with following inputs:

    connectionAlias: testingJDBC
    packageName: ACallPackageTest
    adapterTypeName: JDBCAdapter
    connectionFactoryType: com.wm.adapter.wmjdbc.connection.JDBCConnectionFactory

    I’m getting the following error:

    Launch started: 2018-05-21 09:21:56.519
    Configuration name: createConnectionNode
    Configuration location: /home/sagdev/workspace910/.metadata/.plugins/org.eclipse.debug.core/.launches/createConnectionNode.launch

    Could not run ‘createConnectionNode’
    com.wm.pkg.art.error.DetailedServiceException: [ART.114.233] Adapter Runtime (Metadata): Unable to get the connection type "com.wm.adapter.wmjdbc.connection.JDBCConnectionFactory ".

    com.wm.pkg.art.error.DetailedServiceException: [ART.114.233] Adapter Runtime (Metadata): Unable to get the connection type "com.wm.adapter.wmjdbc.connection.JDBCConnectionFactory ".
    at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:119)
    at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:113)
    at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:80)
    at com.wm.pkg.art.metadata.ConnectionMetadataService.getConnectionAdapterMetadata(ConnectionMetadataService.java:168)
    at com.wm.pkg.art.util.ExtendedConnectionUtils.getConnectionPropValues(ExtendedConnectionUtils.java:669)
    at com.wm.pkg.art.util.ExtendedConnectionUtils.createConnectionNode(ExtendedConnectionUtils.java:357)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:406)
    at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:650)
    at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
    at com.wm.ps.serviceMock.ServiceInterceptor.process(ServiceInterceptor.java:378)
    at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
    at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
    at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
    at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
    at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:303)
    at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)

    Could you please help?
    What is the correct input of connectionFactoryType?


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 3.  RE: How to get connection attributes of an adapter connection? Update Connection Properties

    Posted Mon June 10, 2019 05:10 PM

    Use
    wm.art.admin.connection:getResourceConfiguration


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards