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
Back to discussions
Expand all | Collapse all

Accessing postgreSQL using the jdbc adapter

  • 1.  Accessing postgreSQL using the jdbc adapter

    Posted Tue December 10, 2002 02:55 AM

    Has anyone used the jdbc adapter with postgreSQL?

    Thanks


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


  • 2.  RE: Accessing postgreSQL using the jdbc adapter

    Posted Wed April 06, 2005 10:50 PM

    Hi Edwin,
    did you manage to connect to postgreSQL?
    I’d like to know if there is such possibility.

    Regards,
    Fabio.


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


  • 3.  RE: Accessing postgreSQL using the jdbc adapter

    Posted Fri August 03, 2007 08:17 AM

    This may now be old hat - I notice that the message is quite old.

    This is how I got wM 6.1 to work with POstgres 8.2

    POST_DIR is the Postgres SQL root directory, defaults to c:\program files\postgresql on Windows

    IS_DIR is the Integration server root directory

    1. Copy the the postrpostgresql-8.2-505.jdbc2ee.jar from
      POST_DIR\8.2\jdbc to IS_DIR\lib\jars

    2. In the wM admin console select Adapters > JDBC Adapter > Configure Connection

    3. Use the following parameters

    DataSource Class org.postgresql.ds.PGSimpleDataSource
    portNumber 5432 (this is the default, change it if you use a different postgres port)
    networkProtocol jdbc:postgresql

    This should all work perfectly.

    Dave


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


Related Content