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.


#TechXchangePresenter
 View Only
  • 1.  AdapterNotification Problem in JDBCAdapter

    Posted Mon August 25, 2003 08:36 PM

    Hi all,

    Here i am facing one problem.I set up Alias for JDBCAdapter.I set up
    Pooling connection period.Now I am trying to create AdapterNotification
    on that database using JDBCAdapterNotification template.

               I am getting below error. 
    

    com.wm.app.b2b.server.ServiceException: [ART.114.235] Adapter Runtime (Metadata): Error in getNotificationAdapterMetadata. Missing parameter: adapterTypeName.

    com.wm.ui.UiException: com.wm.app.b2b.server.ServiceException: [ART.114.235] Adapter Runtime (Metadata): Error in getNotificationAdapterMetadata. Missing parameter: adapterTypeName.

    when i looked into getNotificationAdapterMetadata service in WMART
    package,this service needs adapterTypeName parameter as input.
    where did it gets this information?

    thanks,
    SriniK


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


  • 2.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Mon August 25, 2003 10:48 PM

    wow - I thought I was alone. I am getting that exact same error. I have created update and insert notifications on that adapter in the past, and they have worked fine. Recently, I installed SP2 and SP1_Fix_43 though - I wonder if that is causing some problems. Because now, I am getting this error on ALL my adapters, even if I create a new one from scratch. It will let me create SELECT and INSERT adapter services, but it gives me the same ART.114.235 error you’re getting when I try to create adapter notifications.

    Jeremy


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


  • 3.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Mon August 25, 2003 11:07 PM

    Hi Jeremy,

    I figure out in SP2_fix it is asking AdapterTypeName parameter.In  
    

    my localHost,I didn’t apply any service packs.So it is allowing me
    to create adapterNotification.My Dev,test,Staging environments we applied SP1,SP2_fixes (These environments i am getting above problem).
    we are not applied SP2 on Production environment.So my previous notifications on Prod working fine.So I came in conclusion In SP2_fix
    we need additional parameters.When i open wmART package in my local
    box i observed there is no AdapterTypename parameter(input).I am not applied any service packs (reason i am not using Jdk1.4).we open
    ticket regarding this issue.

    Thanks,
    sriniK


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


  • 4.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Mon August 25, 2003 11:31 PM

    There are some upgrade steps when installing SP1 (or when going directly to SP2) which are described in the readme (see IS_6-0-1_SP2_README.txt for SP2) that have to do with JDBC datasource definitions. I’m not sure of the details of the manifestation of not running the update scripts, but that would be good to verify that isn’t the problem.


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


  • 5.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Tue August 26, 2003 12:20 AM

    Jeremy/Hartman,

       Today I received servicePak for developer/IDE(wb601sp1developer) 
    

    from my Administrator.This service pak for developerConsole/IDE
    in order to interact with servers that have service pak 2 installed.
    According to his mail from webMethods will support to create JDBC
    Notifications.Contact webMethods support.I am going to apply it now.

    Thanks,
    sriniK


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


  • 6.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Tue August 26, 2003 04:20 PM

    Hi Jeremy,

        I applied wb601sp1developer on my m/c now notification is  
    

    working for me.so pl contact webMethods support to get developer

    service pack.

    Thanks,
    SriniK


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


  • 7.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Tue August 26, 2003 09:00 PM

    yes - I just found the same thing. Integration Server SP2 requires that you install Developer SP1. Thanks.


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


  • 8.  RE: AdapterNotification Problem in JDBCAdapter

    Posted Tue August 26, 2003 09:19 PM

    Hi Jeremy,

     I have one question.Did you ever used storedProcedure service 
    

    in JDBC Adapter?If yes,did you pass parameter date into your stored

    -Procedure.I am facing problem when I pass date parameter into

    JDBC storedProcedure service.I passed like yyyy-MM-dd HH:mm:ss/ss.s

    format.Same thing working fine for me in wmDb package.If i pass

    date parameter like dd-MMM-yyyy format for wmDB package.

    Thanks,
    Srini


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