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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3950410#3950410
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3950410
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
