4 Replies Latest reply on Dec 6, 2001 3:21 PM by klaust

    JBoss 2.4.3 JDBC Config Problem

    klaust
    klaust Dec 6, 2001 11:19 AM

      Hi,
      i'm very new to JBoss, but have ported out Application successfully from Orion to WebLogic-6.0 and Borland-4.5.1. And now hopefully to JBoss/Tomcat.

      I think my jboss.xml is ok, i see in the logs that my beans try to access the right Resourcename:

      <resource-managers>
      <resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
      <res-name>LOGADSRef</res-name>
      <res-jndi-name>java:/LOGADS</res-jndi-name>
      </resource-manager>
      </resource-managers>

      <enterprise-beans>

      <ejb-name>waehrungBean</ejb-name>
      <jndi-name>PIAG/L2001/waehrung</jndi-name>
      <configuration-name></configuration-name>
      <resource-ref>
      <res-ref-name>jdbc/P2001DB</res-ref-name>
      <resource-name>LOGADSRef</resource-name>
      </resource-ref>

      [...]

      But i have some Problems to configure the Database (Ora9i, DB2).
      I read the OnlineDocs and tried to put a File, as described in "Examples for specific databases" to the deploy-directory but it seems completly ignored!

      did i miss something?
      is the online-doc only for jboss-3.0?

      pleas point me n the right direction.

      thanks
      klaus



      • 17969 Views
      • Tags:
        • 1. Re: JBoss 2.4.3 JDBC Config Problem
          dciarnie Dec 6, 2001 11:37 AM (in response to klaust)

          In Jboss 2.4.3 connection pools are configured in conf/default/jboss.jcml.
          I don't know the details for Oracle or DB2 but you will need to add a driver to the JdbcProvider mbean and an mbean for your pool(s). There is a sample pool configuration in jboss.jcml that you should be able to use as a guide.

          Dan Ciarniello

            • Actions
          • 2. Re: JBoss 2.4.3 JDBC Config Problem
            klaust
            klaust Dec 6, 2001 12:04 PM (in response to klaust)

            thanks,
            but the sample pool is a XA Datasourcepool for Hypersonic.
            What to do for a "normal" (nox-XA) Datasource?

            When I try the entrys from the docu
            "<mbean code="org.jboss.resource.ConnectionFactoryLoader"
            ..."
            i get exceptions (javax.management.RuntimeOperationsException: Object name cannot be null)

            Can i read anywhere how to configure this?

            tia
            klaus

              • Actions
            • 3. Re: JBoss 2.4.3 JDBC Config Problem
              dciarnie Dec 6, 2001 1:36 PM (in response to klaust)

              Looking through some old configuration files I found an Oracle connection pool that I had once set up when using JBoss 2.2.2:

              <!-- JDBC -->

              oracle.jdbc.driver.OracleDriver



              org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
              OracleDBPool
              jdbc:oracle:thin:@host:1521:myoracle

              Username
              Password
              2
              2
              true
              20
              20
              false
              false
              true
              false
              false
              1800000
              1.0



              Hope this helps,
              Dan.

                • Actions
              • 4. Re: JBoss 2.4.3 JDBC Config Problem
                klaust
                klaust Dec 6, 2001 3:21 PM (in response to klaust)


                thanks.
                it works!

                klaus

                  • Actions