[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
"MmarcoM" wrote : Hi, | i see... | ok if you want just a MYSQL datasource foryour own purposes, it's enough to do step 1/2/3, configure mysql-ds.xml and proper authentication in login-config. | All jboss MQ that comes with default dist i gues it is using hsql as database, so if you would have gone to do steps 5/6 that mean to me that you want tocompletely replace hsql with mysql, having mysql db handling everything, | at least, that's what looks to me by checking the link you provide | | i have been using mysql with jboss for over 3 years, and all i needed todo was to configure properly a mysql-ds.xml | | that's what it seems to me you want to do | | hth | marco I was having the same issue because I removed the same hsqldb-jdbc-state-service.xml file when I switch to MySQL. Restore that file solved the problem. I don't agree, though, that you only need step 1/2/3. Step 4 is necessary as it contains SQL statement only meant to be used with HS DB. And I got exceptions if I keep that file there. Also note that the sample mysql-jdbc2-service.xml depends on "MysqlDS", which should be changed to "DefaultDS" to make it work. I think in this case the SQL statements in the hsqldb-jdbc-state-service.xml happen to work with MySQL DB as well, that's why we kept that file. Had it contains HS DB specific statements, we won't be able to use it directly then. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4003531#4003531 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4003531 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
thanks a lot marco for clarifying :) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=388#388 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=388 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
Hi, i see... ok if you want just a MYSQL datasource foryour own purposes, it's enough to do step 1/2/3, configure mysql-ds.xml and proper authentication in login-config. All jboss MQ that comes with default dist i gues it is using hsql as database, so if you would have gone to do steps 5/6 that mean to me that you want tocompletely replace hsql with mysql, having mysql db handling everything, at least, that's what looks to me by checking the link you provide i have been using mysql with jboss for over 3 years, and all i needed todo was to configure properly a mysql-ds.xml that's what it seems to me you want to do hth marco View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=382#382 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=382 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
"MmarcoM" wrote : why have you done those 2 steps? | | 4) deleted hsqldb-jdbc2-service.xml from default\deploy\jms | 5) and I've also deleted hsqldb-jdbc-state-service.xml from default\deploy\jms | | well step 4 is outlined in http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource under JBossMQ header, and I've assumed I should do 5) as well as it seemed related to hsdb. thanks cinzia View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=360#360 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=360 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
solved: I've wrongly removed the file which contained the definition of jboss.mq:service=StateManager, i.e. step 5) and I've also deleted hsqldb-jdbc-state-service.xml from default\deploy\jms View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=356#356 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=356 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
hello, btw, why have you done those 2 steps? 4) deleted hsqldb-jdbc2-service.xml from default\deploy\jms 5) and I've also deleted hsqldb-jdbc-state-service.xml from default\deploy\jms mayb those deletions are the source of your problems.. what r you trying to accomplish? why would you need to delete hsqldb? hth marco View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=355#355 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=355 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Beginners Corner] - Re: JBoss 4.0.5.GA MySQL integration
by the way, I've used ejb3 installation. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=349#349 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=349 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user