-
1. Re: use mysql in jboss 3.0.2
kristofvcl Nov 28, 2002 3:19 AM (in response to meixiaolong)Make another service file with an other database name.
Regards
Kristof -
2. Re: use mysql in jboss 3.0.2
meixiaolong Nov 28, 2002 3:56 AM (in response to meixiaolong)thanks,and I have two database in mysql server,I want to configure two connection in mysql-service.xml file,can you tell me what do I do next?
-
3. Re: use mysql in jboss 3.0.2
kristofvcl Nov 28, 2002 7:23 AM (in response to meixiaolong)you have a mysql service1 and mysqlservice2 (for instance)
in the first there is something like
dbase1
<config-property name="ConnectionURL" type="java.lang.String">jdbc connection URL </config-property>
<config-property name="DriverClass" type="java.lang.String">jdbcdriver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">user</config-property>
<config-property name="Password" type="java.lang.String">password</config-property>
and in the second you change dbase1 with dbase2
and the connection URL to the one for the second db
In your code you have to use dbase1 or dbase2 for getting the connection.
Check the manual for more info.
Regards
Kristof