webMethods

webMethods

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

Using JDBC 4.2 against tables with >100 fields

  • 1.  Using JDBC 4.2 against tables with >100 fields

    Posted Mon February 10, 2003 03:21 PM

    We have a number of cases where I need to build configured operations against tables that have >100 or >300 fields in them. In a prior project I was unsuccessful in getting the adapter to introspect these large tables. Even having added memory to adapter or EI; adding a single field, saving, then autofill; single field by field; never have we been able to sucessfully introspect these large schemas.

    A workaround done previously was to build the configured operation in VI then take the broken component and build the WHERE clauses, etc. in EI. This, however, is not functioning for the large schema (389 fields).

    Has anyone had any luck or resolutions for similar issues? Watching the JDBC adapter in debug it appears that it is doing a very laborious traversal of the full schema for each element and therefore time would be the crucial component. Even extending the timeout on EI didn’t give me resolution.

    Any help would be excellent!

    Sincerely,

    Scott


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


  • 2.  RE: Using JDBC 4.2 against tables with >100 fields

    Posted Tue February 11, 2003 02:20 PM

    Basically I’ve moved away from using the SELECT operation for that very reason.


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


Related Content