On Thursday 06 March 2003 02:09 pm, Mike wrote:
> Can someone point me to the FAQ's? Im trying to find out the
> necessary steps to use mysql instead of hypersonic database.
> Basically what do I need to remove hdb and add mysql. I’ve googled
> but find tons of howto's that are out of date. Anyway, if one of
> you could give me a push in the right direction, I would appreciate
> it. Thanks in advance.
The quickstart guide is good. But it's really not too difficult. In
any of the latest JBoss' look into the docs/examples/jca directory
and find either the mysql-service.xml or mysql-ds.xml (in the 3.2
releases), modify to suit, and throw into your deploy directory.
The mysql-ds.xml is the easiest option, just ignore the warning if
you're using 3.2.0RC2 or RC3. It seems to work for me even with the
warning. Remember to put the mysql org.gjt.mm driver in the lib/
directory of your JBoss instance, server/default/lib if you're
running the default configuration.
For using mysql-service.xml you can either put the username and
password into the XML file, look for UserName and Password and do
something like this:
<config-property name="UserName"
type="java.lang.String">MyUserName</config-property>
<config-property name="Password"
type="java.lang.String">MyPassword</config-property>
Or you can follow the directions at the top of the file and copy the
application-policy into your conf/login-config.xml. If you use JAAS,
like this, I guess you have the option of changing the configuration
so that database connections happen based on the user logged into
your application, which would be interesting but unusual.
The mysql-service.xml will work for any JBoss 3.x that I've used so
far, just make sure you use the template from the correct version,
and watch for slight syntax changes between versions. These tend to
change in subtle ways as they stabilize. No big deal.
Hope this helps a bit.
Cheers.
-Neal
-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger
for complex code. Debugging C/C++ programs can leave you feeling lost and
disoriented. TotalView can help you find your way. Available on major UNIX
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
