1 Reply Latest reply on Dec 22, 2011 1:42 AM by nickarls

    JBoss 7 and OracleDriver

    sabbirali

      I have created module for oracle 6 driver and its working fine with connection pool.

       

      But

       

      same datasource is used by quartz also. its giving below error when initialise

       

      11:33:00,619 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/IASWeb]] (MSC service thread 1-4) StandardWrapper.Throwable: java.lang.NoClassDefFoundError: oracle/sql/BLOB

                at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:642) [quartz-oracle-1.8.5.jar:]

                at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:207) [quartz-oracle-1.8.5.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1101) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1046) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3691) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3763) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3687) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1034) [quartz.jar:]

                at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:798) [quartz.jar:]

                at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243) [quartz.jar:]

                at com.eks.jobs.JobSchedulerInitServlet.removeTempFileProcess(JobSchedulerInitServlet.java:144) [classes:]

                at com.eks.jobs.JobSchedulerInitServlet.init(JobSchedulerInitServlet.java:59) [classes:]

                at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_10]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_10]

                at java.lang.Thread.run(Thread.java:619) [:1.6.0_10]

      Caused by: java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.IASEar.ear.IASWeb.war:main" from Service Module Loader]

                at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:191)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:361)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:333)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:333)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:310)

                at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:103)

                at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) [:1.6.0_10]

                ... 23 more

       

       

      11:33:00,635 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/IASWeb]] (MSC service thread 1-4) Servlet /IASWeb threw load() exception: java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.IASEar.ear.IASWeb.war:main" from Service Module Loader]

                at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:191)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:361)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:333)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:333)

                at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:310)

                at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:103)

                at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) [:1.6.0_10]

                at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:642) [quartz-oracle-1.8.5.jar:]

                at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:207) [quartz-oracle-1.8.5.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1101) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1046) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3691) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3763) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3687) [quartz.jar:]

                at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1034) [quartz.jar:]

                at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:798) [quartz.jar:]

                at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243) [quartz.jar:]

                at com.eks.jobs.JobSchedulerInitServlet.removeTempFileProcess(JobSchedulerInitServlet.java:144) [classes:]

                at com.eks.jobs.JobSchedulerInitServlet.init(JobSchedulerInitServlet.java:59) [classes:]

                at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

                at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_10]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_10]

                at java.lang.Thread.run(Thread.java:619) [:1.6.0_10]

       

       

      if both classloader are independant then where to put dependacies in web module.