-
1. Re: Dukes Bank application deployment in jboss using MySql
visolvejboss Jun 12, 2006 7:46 AM (in response to vikramb)Hi,
You can use the following steps to make the Dukes bank application work with MySQL.
1. Copy the mysql-ds.xml file from docs/examples/jca to server/default/deploly. The default datasource name is MySqlDS, make a note of it. Modify the connection-url (with the hostname and dbname), user-name and password as per your environment.
11 <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url>
12 <driver-class>com.mysql.jdbc.Driver</driver-class>
13 <user-name>x</user-name>
14 password y
2. Modify the datasource name in the {dukes-home}/examples/bank/dd/ebb/boss from DefaultDS to MySqlDS. If you are using UNIX, you can use following commands to do this job.
# sed 's/DefaultDS/MySqlDS/g' dd/ejb/jboss.xml > temp.xml
# mv temp.xml dd/ejb/jboss.xml
3. You have to insert the data's manually into the mysql. For this you can use the following commands.
# mysql --database=jbossdb < hsql-create-table.sql
# mysql --database=jbossdb < insert.sql
Note that, jbossdb is database we have used. Change the database name accordingly.
Regards,
ViSolve JBoss Team -
2. Re: Dukes Bank application deployment in jboss using MySql
visolvejboss Jun 12, 2006 7:54 AM (in response to vikramb)Hello,
Also,
1. Copy the mysql jdbc connector jar file into the server/default/lib directory.
2. Grant the access permission to database with the following command.
mysql> grant all on database_name.* to user_name@'localhost' identified by 'passwd'
Regards,
ViSolve JBoss Team.