Regarding JDBC Pool connection

,
1

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.

2

Hi @JayaBharath - Can you try once by placing the JAR in this path

image
image1291Ă—373 13.8 KB

3

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

KM

4

Yeah tried but stiil the same issue

image
image922Ă—397 26.5 KB

5

Yeah Kasi restarted IS

image
image922Ă—397 26.5 KB

6

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

4 Likes
7

What are you tying to achieve?

1 Like
8

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

10

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.

1 Like