Steven Webster wrote:
> Hi all,
>
> I'm having a real hard time trying to get JBoss working with MySQL;
> reading through the list archives, all I can really ascertain is that
> the docs are not necessarily correct with regards to setting up JBoss.
There's some JBoss 2.0 related stuff that's no longer accurate.
>
> Has anyone successfully setup JBoss with MySql, that could perhaps
> send me the various entries they've made in the properties, conf and
> jcml files, to get things working ? I've got the driver installed ok,
> and checked it works with some simple JDBC client code (non EJB code).
Sorry, I'm not a MySQL person, so I can't give you precise settings, but
in general:
1. Do Nothing to jboss.properties or jboss.conf
2. Add your driver to the JdbcProvider mbean in jboss.jcml
3. Add a XADataSource mbean (or modify an existing one) to jboss.jcml.
Use the DefaultDS one as a template. You should only need to change the
URL, JDBCUser, and Password attributes to get it working.
Beware, you _may_ need to delete jboss-auto.jcml, expecially if you
chane an existing mbean.
>
> As an aside; in looking for the answer, I've noticed a few people
> allude to the jboss.conf file being deprecated, in preference for
> the jboss.jcml file - is this the case ?
It isn't deprecated, exactly, it's just that it doesn't need to be
modified much anymore. It's used as a bootstrap to get some of the base
JBoss MBeans up and running, then they take over and load the mbeans
specified in jboss.jcml, the jboss-auto.jcml (or some variant of that order)
>
> Also; when I make changes for logging to the .jcml file, including
> adding the GUI Logger (I guess I'm answering my own question from
> earlier today), the changes don't seem to take immediate effect...how
> often are these files read, and are they parsed into a cached format
> in any way, shape or form ??
They're only read at startup. If you point a browser at port 8082 of the
machine JBoss is running on, however, you'll get a crude web interface
allowing you to change things on the fly. Things changed here wind up in
jboss-auto.jcml.
I hope this helps,
danch
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
