3 messages in com.mysql.lists.javaRe: JBoss exception sorter / connecti...
FromSent OnAttachments
Nathan Gross23 Jun 2005 12:46 
Mark Matthews23 Jun 2005 13:41 
Nathan Gross23 Jun 2005 15:21 
Subject:Re: JBoss exception sorter / connection checker. 3.1.9 drivers.
From:Nathan Gross (natg@oneeasysystem.com)
Date:06/23/2005 03:21:53 PM
List:com.mysql.lists.java

Mark Matthews wrote:

Nathan Gross wrote:

Hi; Section 1.4.3 of the manual included with the 3.1.9 drivers advises to use JBoss specific drivers for the exception sorter and connection-checker. However this results in a 'classNotFound'. Any input regarding this issue would be appreciated. Thanks; -nat

Nathan,

They're in the .jar file. Are you sure you're not getting bitten by JBoss classloader issues? (My guess is that you're not deploying the driver in a classloader that's visible to the connection pool).

- -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com

Well, you made me do some homework. Indeed, not only is it in the jar, but for a datasource OTHER than DefaultDS, JBoss loads it! We are using MySql to completely replace the HypersonicDB that ships with JBoss, and have a "JBoss" schema in MySQL, using the DefaultDS to point to it. All this works (and worked with 3.1.7) fine (all required HSdb files have been removed, etc.) and we can monitor JBoss' interaction with MySQL ok. So, to clarify this problem, it appears only on the DefaultDS datasource. Other MySql datasources load ok. Also, please note that it loads and binds the jndi ok, except it turns these two classes 'off'. Thank you much. -nat PS. A tiny portion of the log follows.

WARN [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Exception trying to create connection checker (disabling): java.lang.ClassNotFoundException: Unexpected error during load of:
com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker,
msg=org/jboss/resource/adapter/jdbc/ValidConnectionChecker at
org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:512) at
org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.java:377)

--------------