2 Replies Latest reply on Dec 20, 2001 6:18 PM by Alice

    DeploymentException when using oracle

    Alice Newbie

      For "David Jencks": I do not understand what I should do in ejb-jar.xml/jboss.xml. Thanks.

      "I want to use Oracle instead of hypersonic/instantdb. This is what i did in jboss.jcml:

      1. org.jboss.jdbc.JdbcProvider mbean contains ONLY oracle driver

      2. org.jboss.jdbc.HypersonicDatabase mbean and org.jboss.jdbc.XADataSourceLoader mbeans for InstantDN and DefaultDS removed

      3. org.jboss.jdbc.XADataSourceLoader mbean for oracle added:


      OracleDB
      org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:oracle:thin:@localhost:1521:oracle
      scott
      tiger


      I get this error:

      Deploying CDBean

      oracle.jboss.ejb.DeploymentException: DefaultDS not bound

      When I use all drivers in org.jboss.jdbc.JdbcProvider mbean and keep all org.jboss.jdbc.XADataSourceLoader mbeans for defaults,

      I do not get any error but all the data gets loaded in Hypersonic instead of Oracle.

      Please help.

      Thanks very much."

        • 1. Re: DeploymentException when using oracle
          David Jencks Master

          PoolName is the jndi name the DataSource is bound under. Therefore the simplest solution is to change PoolName to DefaultDS.

          If you don't do that, you need to tell your app to use OracleDB as the jndi name of the DataSource. Reading the manual is the best way to find out how to do this: I think you change a datasource entry in standardjaws.xml and provide a resource-ref entry in your jboss.xml or ejb-jar.xml.

          In any case you will want to also change the type mapping properties in standardjaws.xml to Oracle, and if necessary in jaws.xml.

          • 2. Re: DeploymentException when using oracle
            Alice Newbie

            Thanks very much for the help.

            1.
            It was not mentioned anywhere in Jboss2.2 doc that we need to change anything other than jboss.jcml. Second, surprisingly I had the same configuration running a while back with same jboss version. I had to format my PC and thats why I had to re-download everything. I swear I never touched jaws/standardjaws/jboss/ejb-jar to point to Oracle before. This fact made things confusing for me. Anyway, I think I can have it working now.

            2.
            A rather easy thing; but Im not able to find a quick reference. How do I access Hypersonic (DefaultDS) ? I mean how can I run "sqlplus" counterpart of Oracle?

            Thanks again.