3 Replies Latest reply on Aug 4, 2012 2:00 AM by antoine_h

Using GateIn 3.3.0 Jboss AS7 with mysql

cliffm Jun 14, 2012 10:46 PM

I just downloaded and installed GateIn 3.3.0 Jboss AS7 today and tried to configure it. I set up two mysql databases - gatein_idm and gatein_portal and edited the configuration.properties file to point to them. When I try to startup GateIn/Jboss, I get ClassNotFound exceptions about com.mysql.jdbc.Driver. I have looked online for a fix, and have tried everything I have found - copying the mysql connector jar into standalone/deployments, copying it into modules/com/mysql/main and creating the module.xml, and just putting it into my CLASSPATH. I have tried with mysql 5.1 connector versions 5.1.10, 5.1.13 and 5.1.20.

What am I doing wrong and how do I fix this?

1. Re: Using GateIn 3.3.0 Jboss AS7 with mysql

haint Jun 15, 2012 12:46 AM (in response to cliffm)

You need declare dependency to mysql module in gatein/modules/org/gatein/lib/main/module.xml (find "hsqldb" in that which is example)
Actions
2. Re: Using GateIn 3.3.0 Jboss AS7 with mysql

cliffm Jun 15, 2012 9:58 AM (in response to haint)

This worked, thank you.

For anyone who is reading this, my final solution was to copy the mysql connector jar file to modules/com/mysql/main, create the module.xml for it and then update the gatein/modules/org/gatein/lib/main/module.xml to include the dependency on mysql.
Actions
3. Re: Using GateIn 3.3.0 Jboss AS7 with mysql

antoine_h Aug 4, 2012 2:00 AM (in response to cliffm)
Hi,

this is a much better solution than this one :
https://community.jboss.org/message/751994#751994

For setting the dependency, in the file : JBOSS_HOME/gatein/modules/org/gatein/lib/main/module.xml
add :
.... <module name="org.hsqldb" />  <module name="com.mysql.jdbc" /> <module name="org.jboss.common-core" /> ....

(with "com.mysql.jdbc" being the name you put for your MySQL connector driver module).

Antoine
JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.
Actions

Go to original post