hi
i am using jboss 3.04. can anyone help me on configuring my application to use more then one database in DB2.
I have tweaked with the db2-service.xml file but it doesnot work. Do i have to have a seperate jndi name for each database i want to connect to ? below is the portion of the db2-service.xml file where you usually do this. It will be great if anyone of you can show what changes i have to make on it.
DB2DS
<config-property name="ConnectionURL" type="java.lang.String">jdbc:db2://192.168.1.3/j2eeofsy</config-property>
<config-property name="DriverClass" type="java.lang.String">COM.ibm.db2.jdbc.net.DB2Driver</config-property>
<!-- Earlier value = COM.ibm.db2.jdbc.app.DB2Driver -->
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">gmhadm</config-property>
<config-property name="Password" type="java.lang.String">psyche32</config-property>
<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper