-
Ensure a current version of java development kit (v1.4.x), see
above.
Ensure JAVA_HOME is set (JBoss requires
JAVA_HOME)
Ensure JAVA_HOME/bin is in the
PATH (You will NOT need to set your
CLASSPATH, nor will you need any of the jars used in the
previous tests).
-
Ensure a current version of JBoss (v4.0RC1 or better)
https://www.jboss.org/index.html
select "Downloads"
select "jboss-4.0.zip"
pick a mirror
unzip ~/dload/jboss-4.0.zip
create a JBOSS_HOME environment variable set to the unzipped directory
unix only:
cd $JBOSS_HOME/bin
chmod +x *.sh
Deploy (copy) the connector-mxj.jar to
$JBOSS_HOME/server/default/lib.
Deploy (copy)
mysql-connector-java-3.1.4-beta-bin.jar
to $JBOSS_HOME/server/default/lib.
Create a mxjtest.war directory in
$JBOSS_HOME/server/default/deploy.
Deploy (copy) index.jsp to
$JBOSS_HOME/server/default/deploy/mxjtest.war.
-
Create a mysqld-service.xml file in
$JBOSS_HOME/server/default/deploy.
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="com.mysql.management.jmx.jboss.JBossMysqldDynamicMBean"
name="mysql:type=service,name=mysqld">
<attribute name="datadir">/tmp/xxx_data_xxx</attribute>
<attribute name="autostart">true</attribute>
</mbean>
</server>
-
Start jboss:
Be ready: JBoss sends a lot of output to the screen.
When JBoss seems to have stopped sending output to the screen,
open a web browser to:
https://localhost:8080/jmx-console
Scroll down to the bottom of the page in the
mysql section, select the bulleted
mysqld link.
Observe the JMX MBean View page. MySQL should already be
running.
(If "autostart=true" was set, you may skip this step.) Scroll
to the bottom of the screen. You may press the
Invoke button to stop (or start) MySQL
observe Operation completed successfully without a
return value. Click Back to MBean
View
-
To confirm MySQL is running, open a web browser to
https://localhost:8080/mxjtest/ and you
should see that
SELECT 1
returned with a result of
1
Guided by the
$JBOSS_HOME/server/default/deploy/mxjtest.war/index.jsp
you will be able to use MySQL in your Web Application. There
is a test database and a
root user (no password) ready to expirement
with. Try creating a table, inserting some rows, and doing
some selects.
Shut down MySQL. MySQL will be stopped automatically when
JBoss is stopped, or: from the browser, scroll down to the
bottom of the MBean View press the stop service
Invoke button to halt the service.
Observe Operation completed successfully without a
return value. Using ps or
task manager see that MySQL is no longer
running
