-
1. Re: share external database(urgent)
gilkatz Jun 14, 2005 9:40 AM (in response to ivyeibsoft)3. Start Jboss with MySql server as the default DB server.
a. First install MySql server, administrator and query browser.
b. From the MySql command line run the following commands.
i. CREATE DATABASE jboss;
ii. SHOW DATABASES;
iii. mysql> GRANT ALL PRIVILEGES ON jboss.* to jboss@localhost IDENTIFIED BY 'password';
iv. select User,Host,Password from mysql.User;
v. CREATE TABLE JMS_MESSAGES (MESSAGEID INT NOT NULL,DESTINATION VARCHAR ( 255) NOT NULL, TXID INT , TXOP CHAR ( 1),MESSAGEBLOB BLOB , PRIMARY KEY (MESSAGEID, DESTINATION));
vi. CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER );
c. Add to the CLASSPATH the MySql driver.
d. Delete the hsqldb-ds.xml
e. Copy from Docs/examples/jca the mysql-ds.xml to the deploy folder.
f. Change the connection url from mysql-host to mysql host name.
g. Change user-name to jboss
h. Change password to password.
i. Start Jboss.