0 Replies Latest reply on Jun 26, 2002 4:47 AM by demian demian

    CMP deployment problem

    demian demian Newbie

      Hi all,
      I try redeploy my application .jar from WLS to JBoss 3.0, and have problem.
      1. create DataSource for Oracle8i, I get example from CVS and setting to my DB (oracledb-service.xml):
      2002-06-26 08:40:35,734 DEBUG [org.jboss.system.ServiceConfigurator] ManagedConnectionFactoryProperties set to
      <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@s2_abb:1521:vyvoj</config-property>
      <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String"/>
      <config-property name="Password" type="java.lang.String"/>
      in jboss.jca:service=LocalTxDS,name=OracleDS
      ......
      2002-06-26 08:40:35,859 INFO [org.jboss.deployment.MainDeployer] Successfully completed deployment of package: file:/D:/JBoss/server/default/deploy/oracledb-service.xml

      2. edit jboss.xml and jbosscmp-jdbc.xml

      <ejb-name>Pouzivatel</ejb-name>
      java:/OracleDS
      <table-name>ajf_pouzivatel</table-name>
      ...


      3. When try deploy this bean get error:
      2002-06-26 08:40:47,703 INFO [org.jboss.ejb.EjbModule] Deploying Pouzivatel
      ..
      2002-06-26 08:40:54,546 ERROR [org.jboss.ejb.EjbModule] Initialization failed
      org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (java.sql.SQLException: ResourceException javax.resource.ResourceException: Could not create connection)
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:103)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.create(JDBCStoreManager.java:333)
      at org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceManager.java:155)
      at org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
      at org.jboss.ejb.Container.invoke(Container.java:789)

      Error say I can't create DB connection to Oracle DB, I trying change some settings, but still unsucesfull.
      Some ideas?
      (DB is live, and connections from WLS are sucesfull)

      Miro