Deploy EJB.jar failing - error fixing table name

[dantepasquale]

We're running jboss as 5.1.0 jdk6 on OEL 5u2 64. We are having issues deploying our EJB application. The error is mentioned above, but it looks to be something related to the jdbc but I've tried using classes12.zip, ojdbc14.jar and ojdbc6.jar in jboss-home/common/lib and nothing changes. I've created the Oracle data service and that looks OK on the admin console. Database is up and running an listner is up on port 1521. Can connect fine with sqlplus. Oh, databases is Oracle 10.2.0.2. Here's the error messages:

java.lang.RuntimeException: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

*** DEPLOYMENTS IN ERROR: Name -> Error

vfsfile:/usr/local/jboss-5.1.0.GA.jdk6/server/default/deploy/planlinkEJB.jar/ -> org.jboss.deployment.DeploymentException: Error while fixing table name

DEPLOYMENTS IN ERROR:

  Deployment "vfsfile:/usr/local/jboss-5.1.0.GA.jdk6/server/default/deploy/planlinkEJB.jar/" is in error due to the following reason(s): java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver from BaseClassLoader@5a621de2{VFSClassLoaderPolicy@5f980ec9{name=vfsfile:/usr/local/jboss-5.1.0.GA.jdk6/server/default/deploy/planlinkEJB.jar/ domain=ClassLoaderDomain@b7c96a9{name=DefaultDomain parentPolicy=BEFORE parent=org.jboss.bootstrap.NoAnnotationURLClassLoader@38a97b0b} roots=[MemoryContextHandler@2012405542[path= context=vfsmemory://5c4o43m-vwcg2t-h3ri2ha7-1-h3ria9c9-11b real=vfsmemory://5c4o43m-vwcg2t-h3ri2ha7-1-h3ria9c9-11b], FileHandler@953071151[path=planlinkEJB.jar context=file:/usr/local/jboss-5.1.0.GA.jdk6/server/default/deploy/ real=file:/usr/local/jboss-5.1.0.GA.jdk6/server/default/deploy/planlinkEJB.jar/]]  delegates=null exported=[com.vkmsolutions.planlink.password, com.vkmsolutions.planlink.member, , com.vkmsolutions.planlink.error, com.vkmsolutions.planlink.enrollment, com.vkmsolutions.planlink.messages, com.vkmsolutions.planlink.claims, com.vkmsolutions.planlink.sl, com.vkmsolutions.planlink.login, META-INF] <IMPORT-ALL>NON_EMPTY}}

        at org.jboss.profileservice.management.upload.remoting.StreamingDeploymentTarget.invoke(StreamingDeploymentTarget.java:313)

        at org.jboss.profileservice.management.upload.remoting.StreamingDeploymentTarget.start(StreamingDeploymentTarget.java:190)

        at org.jboss.profileservice.management.upload.DeploymentProgressImpl.start(DeploymentProgressImpl.java:231)

        at org.jboss.profileservice.management.upload.DeploymentProgressImpl.run(DeploymentProgressImpl.java:88)

        at org.rhq.plugins.jbossas5.util.DeploymentUtils.run(DeploymentUtils.java:120)

        at org.rhq.plugins.jbossas5.AbstractManagedDeploymentComponent.invokeOperation(AbstractManagedDeploymentComponent.java:181)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:482)

        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

        at java.util.concurrent.FutureTask.run(FutureTask.java:138)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:662)

the Oracle-ds.xml file:

cat OracleDS-ds.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<datasources>

    <local-tx-datasource>

        <jndi-name>OracleDS</jndi-name>

        <rar-name>jboss-local-jdbc.rar</rar-name>

        <use-java-context>true</use-java-context>

        <connection-definition>javax.sql.DataSource</connection-definition>

        <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name>

        <min-pool-size>0</min-pool-size>

        <max-pool-size>10</max-pool-size>

        <blocking-timeout-millis>30000</blocking-timeout-millis>

        <idle-timeout-minutes>30</idle-timeout-minutes>

        <prefill>false</prefill>

        <background-validation>false</background-validation>

        <background-validation-millis>0</background-validation-millis>

        <validate-on-match>true</validate-on-match>

        <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter>

        <isSameRM-override-value>false</isSameRM-override-value>

        <allocation-retry>0</allocation-retry>

        <allocation-retry-wait-millis>5000</allocation-retry-wait-millis>

        <application-managed-security xsi:type="securityMetaData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>

        <metadata>

            <type-mapping>Oracle9i</type-mapping>

        </metadata>

        <type-mapping>Oracle9i</type-mapping>

        <local-transaction/>

        <user-name>USER</user-name>

        <password>PW</password>

        <check-valid-connection-sql>SELECT * FROM DUAL</check-valid-connection-sql>

        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

        <prepared-statement-cache-size>0</prepared-statement-cache-size>

        <share-prepared-statements>false</share-prepared-statements>

        <set-tx-query-timeout>false</set-tx-query-timeout>

        <query-timeout>0</query-timeout>

        <use-try-lock>60000</use-try-lock>

        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

        <connection-url>jdbc:oracle:thin:@192.168.4.130:1521:SID</connection-url>

    </local-tx-datasource>

</datasources>