Hi,
How can I find out what caused the issue?
2005-02-28 12:29:06 CET [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ProcessAudit functional alias, check configuration.?
I’m going to configure webMethods IS 6.1 to use MySQL server with MySQL Connector/J driver (mysql-connector-java-3.1.7-bin.jar), but it looks IS doesn’t like it.
Jacek
Hi Jacek,
Unfortunately MySQL is not one of the database that we support for the platform pools - specifically for the ProcessAudit. Refer to the install guide that accompanies the installation - PlatformInstallGuide.pdf, Chapter 3, Software requirements.
The supported database vendors for the various components defined in the resource pools are:
Nino…
I do know that MySQL is not on the list of the supported DBs, but the point is whether it’s possible to run it at all or not. Does it mean that having the JDBC compliant driver isn’t enough to run it in IS?
I can’t understand the error message I’m getting while trying to run MySQL as the database for ProcessAudit:
java.sql.SQLException: Cannot load connection class because of underlying exception: ‘java.lang.SecurityException: Prohibited package name: java.sql’.
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:277)
at java.sql.DriverManager.getConnection(DriverManager.java:543)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at com.wm.app.jdbc.JDBCConnection.(JDBCConnection.java:41)
at com.wm.app.jdbc.JDBCConnectionPool.(JDBCConnectionPool.java:51)
at com.wm.app.jdbc.JDBCConnPoolMgr.createConnPool(JDBCConnPoolMgr.java:38)
at com.wm.app.b2b.server.JDBCConnectionManager.testConnPool(JDBCConnectionManager.java:129)
at wm.server.jdbcpool.testPool(jdbcpool.java:1155)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:294)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:533)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.wm.server.jdbcpool:testPool
but hey, it looks the error was generated by the MySQL driver nor IS.
It looks as if the game were not over 
And the reason of the previous troubles has finally been found and sorted out. Hurraay!
webMethods 6.1 build 132 seems to work with MySQL 4.1.10 via MySQL Connector/J 3.1.7.
The reason was the JVM version IS used and the database URL (but I think it’s less important).
Now, the issue is with the tables that WmPRT package expects in the database. It however should be much easier as I guess it’s documented somewhere what tables to create depending on a database type - Oracle, DB2 or MS SQL Server.
IS_HOME is the home directory of Integration Server
WM_HOME is the home directory of webMethods 6.x (that’s where IS_HOME, Broker, Modeler and some other directories are)
Here’s what I did to get MySQL running. What I mean saying ‘running’ is that it’s now possible to test the MySQL pool in the JDBC Pools panel. It at least gives me: “Test of ProcessAudit successful”.
%IS_HOME%\config\jdbc\driver\MySQL.xml is as follows:
<?xml version="1.0" encoding="UTF-8"?>
MySQL
com.mysql.jdbc.Driver
1
MySQL Connector/J 3.1.7
%IS_HOME%\config\jdbc\pool\MySQLPool.xml looks like this:
<?xml version="1.0" encoding="UTF-8"?>
MySQLPool
1
10
100
jdbc:mysql://localhost/test?user=wm&password=webmethods
wm
commented out due to security reasons
MySQL
MySQL Pool
The MySQL JDBC driver is applied to IS CLASSPATH in %IS_HOME%\bin\server.bat:
set APPENDCLASSES=C:\apps\mysql-connector-java\mysql-connector-java-3.1.7-bin.jar
And the most important point is that IS has to be running with Java 1.4. Otherwise java.sql.Savepoint class won’t be found - it’s not available in 1.3 which is the IS default JVM version.
So, instead of running IS with the default JVM (it’s in %IS_HOME%\jvm):
java version “1.3.1”
Java™ 2 Runtime Environment, Standard Edition (build 1.3.1)
Classic VM (build 1.3.1, J2RE 1.3.1 IBM Windows 32 build cn131-20021107 (JIT enabled: jitc))
IS should be run with that one (it’s in %WM_HOME%\jvm\win142):
java version “1.4.2”
Java™ 2 Runtime Environment, Standard Edition (build 1.4.2-b28)
Java HotSpot™ Client VM (build 1.4.2-b28, mixed mode)
In order to do it, %IS_HOME%\bin\server.bat (on MS Windows) has to be changed:
rem SET JAVA_DIR=C:\apps\webMethods6\IntegrationServer\jvm
SET JAVA_DIR=C:\apps\webMethods6\jvm\win142
Start up IS and have fun! 
Going to create the tables for WmPRT…
In order to create the tables for WmPRT one needs to run the scripts:
with the following changes:
The scripts are in %WM_HOME%\common\db\scripts\create
Having done this, WmPRT doesn’t complain at startup anymore (but it doesn’t certainly mean that everything is fine).