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
Expand all | Collapse all

Pubdbcall Data size bigger than max error

  • 1.  Pubdbcall Data size bigger than max error

    Posted Wed June 11, 2003 01:42 PM

    I’m using pub.db.call to call an Oracle stored procedure and am getting the following error:
    java.sql.SQLException:Data size bigger than max size for this type: 49090
    I’m using longvarchar. I tried longvarbinary and got the same error.
    I’m using version 4.01. Is there anyway around this size limitation? I didn’t see anymore data type options other than these 2 longs?
    Thanks,
    Mike


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: Pubdbcall Data size bigger than max error

    Posted Thu June 12, 2003 12:59 PM

    Hi, Michael.

    Just curious… which database driver are you using? If you are using a thin driver, you may want to try a Type 2 like jdbc:oracle:oci8.

    Let us know what you come up with.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB