Re: mysql as DefaultDS in jboss

mooras@xxxxx wrote:
hi!
I have huge problem configuring jboss to use mysql as a default
database.
I've made a lot of researches on how to do it but something is still
wrong.
I work with Jboss 4.0.4, mysql 5.0, connector/j 3.1.13
Following the instruction on the ONjava web site
http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html

This website is fine, but not complete for the task you want to do.

I'm occuring such a results by starting up server from eclipse:
> [...]
14:55:48,941 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS'
to JNDI name 'java:DefaultDS'

Here it seems your datasource is correctly bound. Is DefaultDS a MySQL database or a HyperSonic SQL database?

14:55:49,963 WARN [ServiceController] Problem starting service
jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited
transactions. Message recovery may not be accurate; - nested
throwable: (java.sql.SQLException: Every derived table must have its
own alias)

If you have modified the DefaultDS to connect a MySQL database, it won't work. Here your stack trace shows there is a problem with JMS. If you look at the folder (if you run the 'default' configuration):
<path-to-jboss>\server\default\deploy\jms
there is a file 'hsqldb-jdbc-state-service.xml'
you need to replace it with the file:
<path-to-jboss>\docs\examples\jms\mysql-jdbc2-service.xml

But this file uses the MySQLDS datasource, not DefaultDS, so you need to edit it and change MySQLDS by DefaultDS to follow you settings.

There might have other files needing similar changes in other services deployed by JBoss.
Good luck.

--
JSC
.

Relevant Pages