1 Reply Latest reply on Sep 20, 2002 2:28 PM by Dain Sundstrom

    Get wrong values with JBoss3.0, CMP2.0, Oracle8.1.7

    razafinimanana Newbie

      Hi folks,

      I'm using JBoss3.0 and CMP2.0 to retreive data from
      Oracle 8.1.7 on NT4 (sp6). Unfortunatly these values
      are wrong. When I compare those values retreive
      throught CMP2.0 and using sql+, there are differents !!
      For instance with CMP2.0 I get : #11 whereas with Sqlplus I get: #1
      The oracle definition is:
      ....
      PC_SUP_ID NUMBER NOT NULL,
      ....
      I'have tried differents configuration inside 'jbosscmp-jdbc.xml' (using <jdbc-type>INTEGER<..>, REAL, DECIMAL, DOUBLE), but no one manage to give me right values.


      Regards

      Anjarivo

        • 1. Re: Get wrong values with JBoss3.0, CMP2.0, Oracle8.1.7
          Dain Sundstrom Master

          Since you are the first person to every complain about this, I assume you have some very weird configuration issues. As for what the exact problem is I have no idea. If you want to see the exact code used to load the values look at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil. If you want to see the generated sql increase your log level to DEBUG for category org.jboss.ejb.plugins.cmp.

          One possibility is you are not actually connecting to Oracle but some other database, such as the built in default database hypersonic.