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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

JDBC adapter template does not load list of schemas from database

  • 1.  JDBC adapter template does not load list of schemas from database

    Posted Wed March 31, 2004 07:44 PM

    I am getting the following error while trying to create an Insert operation using insertSQL template 0f JDBC adapter. The operation is created but it does not load the list of schemas.
    I am using webMethods 6.1 and JDBC adapter 6.0.3 and is connecting to oracle database.

    Here is the exact error message
    com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values.
    [ADA.1.321] Cannot get the list of schemas. "
    (60000/600) ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , , ,
    "
    ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , , ,
    on tables.schemaName [Ljava.lang.String;@1a3fa82
    java.lang.Exception: Adapter values are not available.

    The database has a large number of schemas.
    Any help will be appreciated.


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


  • 2.  RE: JDBC adapter template does not load list of schemas from database

    Posted Wed March 31, 2004 09:00 PM

    I recall that we had similar errors on our 6.1 server when we installed JDBC 6.0.3 using Oracle 9i.
    Make sure the classes12.zip file from Oracle is at the proper directory on the designated server
    at : /opt/webMethods6/IntegrationServer/lib/jars

    And insure that the userid that is running the adapter has schema rights on the Oracle instance.
    Also checkout url:
    [url=“wmusers.com”]wmusers.com

    HTH


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


Related Content