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.  How can I obtain data from PostgreSQL refcursor?

    Posted 09/28/09 10:06 AM

    I have to call PostgeSQL procedure that returns refcursor.
    When I create JDBC adapter (StoredProcedureWithSignature) it shows SQL type “refcursor” as JDBC type “OTHER”.
    Is it posible to read data that way?
    Or, if not, how can I write function/procedure to get set of records from PostgreSQL database?

    Regards
    Jacek


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


  • 2.  RE: How can I obtain data from PostgreSQL refcursor?

    Posted 09/29/09 01:48 PM

    did you try with an SQL adapter of type Select ?

    By the way, how you configured your access to PostgreSQL ?


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


  • 3.  RE: How can I obtain data from PostgreSQL refcursor?

    Posted 09/29/09 02:32 PM

    Thanks for your reply.
    I can’t call select because of our serurity policy :eek:…
    I’m using org.postgresql.ds.PGSimpleDataSource
    and postgresql-8.1-404.jdbc3.jar

    Regards


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


  • 4.  RE: How can I obtain data from PostgreSQL refcursor?

    Posted 10/06/09 03:41 PM

    JDBC adapter returns refcursor as org.postgresql.jdbc3.Jdbc3ResultSetMetaData class
    I change it to document list with java service.

    Regards


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