How to use MySQL and JBoss?

[hidefguy]

Hi;
As a complete newby with an important project which needs a combination of JBoss and MySQL, could someone please provide some clues about how to set up the example template to work with MySQL instead of the default Hypersonic database. I can get the template to compile and run fine with Hypersonic but I am totally lost in respect to configuring MySQL access using JCA. Anyone care to share their config files?
Many thanks
Greg
[e-mail]

[joelvogt]

There are plenty of examples here
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jbosscx/src/etc/example-config/

[hidefguy]

Hi;
Thanks for the info but all that's there are two XML files with no indication at all about how to deploy them.

Please, could someone (anyone) give a brief overview and sample deployment of connecting JBoss to MySQL.

Many thanks

Greg

[joelvogt]

Take the service.xml and put it in jboss/<your-config>/deploy. Then just adjust the file with your own settings (connection string etc)

[browne]

Then come back and complain when you get a "No JNDI bound" error. When that happens, you will be met with silence.

[hidefguy]

Nope, haven't got this error, i got the setup working a few days ago by trial and error.

I didn't realize that the example template is actually broken in respect to the web deployment. This is a complete joke.

It's now clear to me that JBoss is probably about 2-3 years away from being a commercial class application server because there is little or no documentation for it (typical of open source projects).

[sgturner]

Hey hidefguy,

JBoss is a world class commercial class app server now !!! Here is the JBoss business model since you seem to not understand it. There are some free docs. Then there are some docs that you pay for. The next step up from that is paying for the help of a JBoss Authorized Consultant. The next step up from that is paying for help from a core developer. Free JBoss software does not mean free support. Now if you have a world class app that you want to deploy on JBoss, I suggest you take some of the money you save from not having to pay license fees to one of the other vendors and pay for the help that you need. Then you will have still saved a lot of money and you get to stop betraying your lack of understanding of Jboss.

[joelvogt]

The jndi error you might have had seems to be with
myDS

which should be placed in the mbean below where it is now.

Jboss is commercial class, and it isn't that hard to get up and running. If you want the commercial level support, ie your questions answered straight away then it's available. Otherwise please be patient with the other people who will all be happy to help when they can.

[hidefguy]

All good points guys, I'm fraid my fraying nerves got the better of me when I was writing my previous post.
I've just purchased a years docs, and will try to get my company to pony up for at least the startup consulting.

...but... please could someone with a better grasp of both J2EE and JBoss than I currently have per-lease fix the example template that's being distributed because the web example cannot possibly work as currently configured.