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

Regarding JDBC Pool connection

  • 1.  Regarding JDBC Pool connection

    Posted Fri July 19, 2024 01:15 AM

    Hi Team,

    Facing an issue while creating JDBC pool connection for MySql, Connection getting failed due to com.mysql.jdbc.Driver

    For this i have add mysql jar in integrationServer/Lib and instances/default/package/WmJDBCadapter/code/jars libraries but still facing same issue. Can some one help on this isssue.


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Regarding JDBC Pool connection



  • 3.  RE: Regarding JDBC Pool connection

    Posted Fri July 19, 2024 05:11 AM


  • 4.  RE: Regarding JDBC Pool connection

    Posted Fri July 19, 2024 04:55 AM

    Have you restarted the IS?
    What is the error message?

    KM


    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Regarding JDBC Pool connection

    Posted Fri July 19, 2024 05:16 AM


  • 6.  RE: Regarding JDBC Pool connection

    Posted Fri July 19, 2024 06:52 AM

    IS JDBC Pools vs JDBC Adapter Connections are different and they serve different purposes.

    An IS JDBC Pool is needed for various IS functions (link). The Embedded Database may be sufficient for basic operations, but in this case you need an RDBMS as the error message says.

    1. Create a dedicated DB for IS core/internal functionality (i.e., don’t create any custom artefacts inside this DB)
    2. Follow the steps here (link) to create the necessary DB components for the relevant products you have; you will used a component named Database Component Configurator (link) which you install using the Installer
    3. The steps to create the IS JDBC Pool are here (link)
    4. Once you create a Pool Alias, you can associate it with the various IS Functional Aliases (link) (in your case, you need to configure the ISInternal one as the error message says)

    These are fundamental/basic items, so you are not going to find much forum/supporting content other than the product documentation I’ve shared.

    KM


    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: Regarding JDBC Pool connection

    Posted Mon July 22, 2024 09:13 AM

    Now its working fine,
    Before while creating JDBC pool in place of database name i have given DatabaseName=, but now created only with my database name it is working.

    @Kasi Mugada Thanks for your suggestions


    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: Regarding JDBC Pool connection

    Posted Mon July 22, 2024 09:17 AM

    Now it’s working.

    Before while creating JDBC Pool in place of database name I have given “database name= (my database name)”, but now created only with my database name its working fine.

    Thanks for your suggestions.


    #Integration-Server-and-ESB
    #webMethods


  • 9.  RE: Regarding JDBC Pool connection

    Posted Sat July 20, 2024 10:09 AM

    What are you tying to achieve?


    #webMethods
    #Integration-Server-and-ESB


  • 10.  RE: Regarding JDBC Pool connection

    Posted Mon July 22, 2024 05:52 AM

    Hi,

    when setting up internal database schemas for using them with the JDBC Pools functions in IS or MWS, you can rely on the bundled DataDirect Driver, which has support for all databases support by DatabaseConfigurator component.

    See webMethods Systems Requirements Guide which databases are currently supported by which wM component.
    See the Installing webMethods guide for further informations about preparing the environment.

    Regards,
    Holger


    #webMethods
    #Integration-Server-and-ESB