4 Replies Latest reply on Sep 2, 2002 7:28 PM by David Jencks

    jbosscmp-jdbc.xml and Oracle question

    steve bryant Newbie

      Could someone who has successfully gotten JBoss3 to connect to Oracle9i post there jbosscmp-jdbc.xml, specifically this section.

      <jbosscmp-jdbc>

      <create-table>true</create-table>
      <remove-table>true</remove-table>
      java:/oraDS
      <datasource-mapping>Oracle9i</datasource-mapping>

      ...
      </jbosscmp-jdbc>

      This has been throwing a wobbler on me for a while. Whenever I deploy the Entity bean JBoss gives out saying the the datasource and datasource-mapping elements cannot be nested there...

      Cheers...

        • 1. Re: jbosscmp-jdbc.xml and Oracle question
          gateway87 Newbie

          Hi,

          I ever wrote a very similar xml file (8i inplace of 9i) under JBoss 3.0. At the first time of deploying, I always got "DataSource cann't be bound" exception. However, after I recompile the package and redeploy, everything is OK, I wonder what the problem is. Did you encounter this kind of problem?

          Thanks.

          Gateway

          • 2. Re: jbosscmp-jdbc.xml and Oracle question
            gateway87 Newbie

            Hi,

            I ever wrote a very similar xml file (8i inplace of 9i) under JBoss 3.0. At the first time of deploying, I always got "DataSource cann't be bound" exception. However, after I recompile the package and redeploy, everything is OK, I wonder what the problem is. Did you encounter this kind of problem?

            Thanks.

            Gateway

            • 3. Re: jbosscmp-jdbc.xml and Oracle question
              steve bryant Newbie

              Sorry Gateway, I never ran into this problem. My problem is that everytime I deploy an Entity EJB using Oracle I get a message saying that the "datasource" element cannot be nested under the "defaults" element which is crap because I've checked the DTD and looked at examples. This one would drive me to drink if other things hadn't already...

              Alternatively, I was trying to get someone to post their jbosscmp-jbdc.xml file to see if I was making a balls of something...but no one has...

              Cheers,
              Steve

              • 4. Re: jbosscmp-jdbc.xml and Oracle question
                David Jencks Master

                this is really a question for the cmp forum. There have been various changes to the dtd at various times, so I would look around, possibly in cvs, and see if there are any other dtds with a different structure for the defaults.