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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  postgresql adapter setting

    Posted 05/17/07 04:21 AM

    I am creating a new adapter postgresql, however it was unable to connect.
    I got the following error:

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource bossiniIntranet.adapters:Intranet.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    null

    I guess there is something wrong with my settings.

    my setting:
    Transaction Type:


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


  • 2.  RE: postgresql adapter setting

    Posted 05/17/07 04:25 AM

    my Setting:

    Transaction Type: LOCAL_TRANACTION
    DataSource Class : org.postgresql.Driver
    networkProtocol:
    Other Properties:

    do i need to set networkprotocol and other properties?

    Thanks alot


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


  • 3.  RE: postgresql adapter setting

    Posted 06/12/07 01:29 AM

    hi
    I think this adapter is not support for in jdbc. only jdbc support 8 databases only. same problem i faced in my porject also. we done some services on that time. we can configure postgres adapter also but you gave data source class name is wrong.you need postgresql-8[1].2dev-503.jdbc2ee.jar u need to store in integration server- lib -jars …you need to put that jar file.

    regards
    sagar


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


  • 4.  RE: postgresql adapter setting

    Posted 06/12/07 02:44 AM

    You’ve put Driver instead of DataSource. Try org.postgresql.ds.PGPoolingDataSource.
    Any way, webMethods JDBC Adapter does not support this database although it works fine as I tested.


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