2 Replies Latest reply on Feb 9, 2006 4:26 PM by Emmanuel Bernard

    Oracle Type Mapping not being used

    Atilio Ranzuglia Newbie

      Hi, we use JBoss 4.0.3SP1, we have defined oracle datasources in:
      - deploy/oracle-ds.xml
      - conf/standardjaws.xml
      - conf/standardjbosscmp-jdbc.xml
      - conf/login-config.xml
      - deploy/jms/oracle-jdbc2-service.xml
      - deploy/jms/oracle-jdbc-state-service.xml
      - deploy/ejb3.deployer/META-INF/persistence.properties

      Our application is using EJB3, inside .par we have:
      - META-INF/jbosscmp-jdbc.xml

      Everywhere says java:/OracleDS and Oracle8 as type mapping

      When we deploy, every SQL statement (for entity beans, not JMS) that is being constructed is not using Oracle's type mapping. We are getting several errors creating tables, like Invalid datatype or Missing keyword

      Can somebody help us identify why those mapping aren't being used?