3 Replies Latest reply on Nov 25, 2002 6:16 PM by msnair

    Oracle datasource works, but type mapping ...

    ivylim

      Hi people,

      My current env is Ant, XDoclet 1.2.2 on JBoss 3,0 (Windows 2000) with Oracle thin JDBC (for Oracle 8i).

      My simple CMP bean (used in the Quick Start Guide template) works well with a Oracle data source. Well, not 100%. I still need to call the type mapping as "Hypersonic SQL". If I change it to say "Oracle" it has the following exception upon table (CMP bean) creation: -


      16:20:45,900 ERROR [EjbModule] Initialization failed
      org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasource-mapping Oracle not found
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java
      :365)
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMet
      aData.java:237)
      at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)

      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.j
      ava:601)



      Again, Oracle data source works with the app, just this part I'm not sure: -

      # Part of the Ant properties.
      # Set the DB type mapping (Hypersonic SQL, PostgreSQL etc., see XDoclet's attribute "typemapping")
      #type.mapping=Hypersonic SQL // WORKS
      type.mapping=Oracle // FAILS!



      In fact, I have not a clue how come the app is 'hardcoded' to response correctly with Hypersonic type mapping even though I've changed to Oracle data source and have explicitly removed the hsqldb-service.xml.

      I'm sure somebody has move forward with Oracle a 100%. Please assist.

      Thank you.