1 Reply Latest reply on Jun 2, 2003 4:20 AM by jonlee

    oracle DataSource in JBoss 3.2.1

    abhayrege

      Hello,
      In Jboss 3.2.1, I have created a Oracledb-ds.xml to create oracle datasource.

      <local-tx-datasource>
      <jndi-name>OracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:abhayr:1521:lbora</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>scott</user-name>
      tiger
      </local-tx-datasource>


      It getting deployed properly. In jaws.xml of an entity bean, I mentioned datasource as,

      java:/OracleDS
      <enterprise-beans>

      ......
      ......

      .....


      The problem is that instead of connecting to scott schema of oracle it is connecting to hypersonic hsql database.

      Can anybody help me on this issue?

      Thanks & regards,

      Abhay Rege

        • 1. Re: oracle DataSource in JBoss 3.2.1
          jonlee

          IF you are using the 2.0 definition is ejb-jar.xml:
          <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN"
          "http://java.sun.com/j2ee/dtds/ejb-jar_2_0.dtd">

          You must modify the global standardjbosscmp-jdbc.xml or have your own jbosscmp-jdbc.xml for the EJB. The datasource and the mapping must be appropriately changed for your requirements.

          e.g. java:/PostgresDS
          <datasource-mapping>PostgreSQL 7.2</datasource-mapping>