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
  • 1.  postgresql adapter setting

    Posted Thu May 17, 2007 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 Thu May 17, 2007 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 Tue June 12, 2007 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 Tue June 12, 2007 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