0 Replies Latest reply on Jan 30, 2003 9:44 AM by seemanto

    Configuring multiple database in DB2

    seemanto Newbie


      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.


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:db2://</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 -->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper