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.  Failed getting instance list (java.sql.SQLException: no conn

    Posted 03/23/06 09:33 AM

    Hi all,

    When tried to test the IS CoreAudit i am getting the following error:

    Test of ISCoreAudit Failed
    [BAC.0002.0000] Wrapped Exception: java.lang.ClassNotFoundException: jdbc:wm:oracle://host:port;databaseName=databasename

    I also tried with jdbc:oracle://— in url which is also giving same error.

    (Note: I didn’t disclose host,port and database names due to security reasons)

    When i opened the monitor i got the following error:
    Failed getting instance list (java.sql.SQLException: no connection returned from pool [ProcessAudit]) on opening wM monitor home page

    I restarted the server so that db pool will be free. Even this didn’t work.

    Please help in finding solutions for this issue. Thanking in advance

    Regards,
    Satish


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 2.  RE: Failed getting instance list (java.sql.SQLException: no conn

    Posted 03/24/06 07:23 AM

    Hi Satish,

    seems that your pool config is messed up:

    URL (for DataDirectDriver Oracle) is:
    jdbc:wm:oracle://host:port;SID=dbName

    DriverAlias should be the predefined “DataDirect Connect JDBC Oracle Driver”, which contains the appropriate Class-Definitions for the Driver.

    Regards,
    Holger


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Failed getting instance list (java.sql.SQLException: no conn

    Posted 03/25/06 03:55 AM

    Hi Holgar,

    That worked for me. Thanks a lot

    Regards,
    Satish


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB