1 Reply Latest reply on Aug 22, 2005 3:46 PM by steverar

    Deployment Problem - Oracle Database

    sgowri

      hi,
      i have tried to work out with the sample application exappendixa. which to connecting to oracle database.
      i have changed the name of the database. because i need to connect to my remote database.
      my database is in ip 10.119.53.61
      port is 1521
      sid: japanqa.mak.com
      i have changed the titandb-ds according to the above thing. but while deploying the titan.jar i am getting the following error.

      i am new to ejb and jboss server. pls give me a breif explination.

      14:52:59,766 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss
      -3.2.0/server/default/deploy/titan.jar
      14:52:59,786 INFO [EJBDeployer] looking for nested deployments in : file:/C:/jb
      oss-3.2.0/server/default/deploy/titan.jar
      14:53:00,316 INFO [EjbModule] Creating
      14:53:00,326 INFO [EjbModule] Deploying CustomerEJB
      14:53:00,866 INFO [EntityContainer] Creating
      14:53:00,866 INFO [EntityInstancePool] Creating
      14:53:00,866 INFO [EntityInstancePool] Created
      14:53:00,876 INFO [EntityContainer] Created
      14:53:00,876 INFO [EjbModule] Created
      14:53:00,886 INFO [EjbModule] Starting
      14:53:00,886 INFO [EntityContainer] Starting
      14:53:01,707 ERROR [EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error while fixing table name; - neste
      d throwable: (org.jboss.util.NestedSQLException: Apparently wrong driver class s
      pecified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(de
      scription=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_data=(S
      ERVICE_NAME=japanqa.mak.com))); - nested throwable: (org.jboss.resource.JBossR
      esourceException: Apparently wrong driver class specified for URL: class: sun.jd
      bc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(description=(address=(host=10.119
      .53.61)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=japanqa.mak.com))
      )))
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEnt
      ityBridge.java:119)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBC
      StoreManager.java:438)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
      r.java:372)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
      er.java:170)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      92)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ler.java:966)
      at $Proxy11.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy38.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:347)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      92)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ler.java:966)
      at $Proxy11.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:541)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
      at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy7.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen
      tScanner.java:280)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS
      canner.java:421)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      doScan(AbstractDeploymentScanner.java:200)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      loop(AbstractDeploymentScanner.java:211)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      run(AbstractDeploymentScanner.java:190)
      Caused by: org.jboss.util.NestedSQLException: Apparently wrong driver class spec
      ified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(descr
      iption=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_data=(SERV
      ICE_NAME=japanqa.mak.com))); - nested throwable: (org.jboss.resource.JBossReso
      urceException: Apparently wrong driver class specified for URL: class: sun.jdbc.
      odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(description=(address=(host=10.119.53
      .61)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=japanqa.mak.com))))
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:106)
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:39)
      ... 56 more
      Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver cl
      ass specified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thi
      n@(description=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_da
      ta=(SERVICE_NAME=japanqa.mak.com)))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.g
      etDriver(LocalManagedConnectionFactory.java:284)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
      reateManagedConnection(LocalManagedConnectionFactory.java:146)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
      eateConnection(InternalManagedConnectionPool.java:352)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
      tConnection(InternalManagedConnectionPool.java:151)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePo
      ol.getConnection(JBossManagedConnectionPool.java:648)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
      dConnection(BaseConnectionManager2.java:413)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
      nnection(TxConnectionManager.java:331)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
      onnection(BaseConnectionManager2.java:488)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
      nManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:102)
      ... 57 more
      14:53:02,807 WARN [ServiceController] Problem starting service jboss.j2ee:jndiN
      ame=CustomerHomeRemote,service=EJB
      org.jboss.deployment.DeploymentException: Error while fixing table name; - neste
      d throwable: (org.jboss.util.NestedSQLException: Apparently wrong driver class s
      pecified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(de
      scription=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_data=(S
      ERVICE_NAME=japanqa.mak.com))); - nested throwable: (org.jboss.resource.JBossR
      esourceException: Apparently wrong driver class specified for URL: class: sun.jd
      bc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(description=(address=(host=10.119
      .53.61)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=japanqa.mak.com))
      )))
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEnt
      ityBridge.java:119)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBC
      StoreManager.java:438)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
      r.java:372)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
      er.java:170)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      92)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ler.java:966)
      at $Proxy11.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy38.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:347)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
      92)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
      ler.java:966)
      at $Proxy11.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:541)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
      at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBea
      nDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy7.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen
      tScanner.java:280)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS
      canner.java:421)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      doScan(AbstractDeploymentScanner.java:200)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      loop(AbstractDeploymentScanner.java:211)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
      run(AbstractDeploymentScanner.java:190)
      Caused by: org.jboss.util.NestedSQLException: Apparently wrong driver class spec
      ified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(descr
      iption=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_data=(SERV
      ICE_NAME=japanqa.mak.com))); - nested throwable: (org.jboss.resource.JBossReso
      urceException: Apparently wrong driver class specified for URL: class: sun.jdbc.
      odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(description=(address=(host=10.119.53
      .61)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=japanqa.mak.com))))
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:106)
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:39)
      ... 56 more
      Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver cl
      ass specified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thi
      n@(description=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_da
      ta=(SERVICE_NAME=japanqa.mak.com)))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.g
      etDriver(LocalManagedConnectionFactory.java:284)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
      reateManagedConnection(LocalManagedConnectionFactory.java:146)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
      eateConnection(InternalManagedConnectionPool.java:352)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
      tConnection(InternalManagedConnectionPool.java:151)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePo
      ol.getConnection(JBossManagedConnectionPool.java:648)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
      dConnection(BaseConnectionManager2.java:413)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
      nnection(TxConnectionManager.java:331)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
      onnection(BaseConnectionManager2.java:488)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
      nManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:102)
      ... 57 more
      14:53:03,888 INFO [EjbModule] Started
      14:53:03,918 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.0/server/
      default/deploy/titan.jar
      14:53:03,958 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
      ration 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:

      MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.j2ee:jndiName=CustomerHomeRemote,service=EJB
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Error while fixing tab
      le name; - nested throwable: (org.jboss.util.NestedSQLException: Apparently wron
      g driver class specified for URL: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc
      :oracle:thin@(description=(address=(host=10.119.53.61)(protocol=tcp)(port=1521))
      (connect_data=(SERVICE_NAME=japanqa.mak.com))); - nested throwable: (org.jboss
      .resource.JBossResourceException: Apparently wrong driver class specified for UR
      L: class: sun.jdbc.odbc.JdbcOdbcDriver, url: jdbc:oracle:thin@(description=(addr
      ess=(host=10.119.53.61)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=jap
      anqa.mak.com)))))]