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

    Configuring multiple database in DB2

    seemanto

      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