[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Change DefaultDS

[PeterJ]

I did exactly what you described. Well, not exactly, I think you didn't mention a few steps so I will mention them here:

1) I created a new database and user in MySQL
I see you are using the "test" database in MySQL - I recommend create a new database and setting up permissions. Here are the SQL statements I use (I run them via Ant, hence the use of '${...}' and property names):

CREATE DATABASE ${db.database};
GRANT ALL PRIVILEGES ON ${db.database}.* TO '${db.user}'@'localhost' IDENTIFIED BY '${db.password}' WITH GRANT OPTION;


2) I edited the mysql-ds.xml file to reference the database, user and password from step 1
3) I changed the jndi-name in mysql-ds.xml to DefaultDS.
4) I change the hostname in the connection URL in mysql-ds.xml to "localhost".
(Please verify that the hostname you used, server.xubuntu, is valid an reachable from the box running JBoss AS.)
5) I commented out this line in mysql-persistence-service.xml:

      <!-- <depends optional-attribute-name="ChannelFactoryName">jboss.jgroups:service=ChannelFactory</depends> -->

I knew that this step had to be done in 5.0.0.GA, but for some reason I thought they would have fixed it in 5.0.1.GA so that this step was no longer necessary. 

And that's it. It works for me. And my environment is:

10:33:11,862 INFO  [ServerInfo] Java version: 1.6.0_13,Sun Microsystems Inc.
  | 10:33:11,862 INFO  [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
  | 10:33:11,862 INFO  [ServerInfo] Java VM: Java HotSpot(TM) Server VM 11.3-b02,Sun Microsystems Inc.
  | 10:33:11,862 INFO  [ServerInfo] OS-System: Windows XP 5.1,x86

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4224936#4224936

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4224936