[jboss-user] [Datasource Configuration] New message: "Re: How to configure Oracle with my application in jboss 5.0"

[Anand Kumar]

User development,

A new message was posted in the thread "How to configure Oracle with my application in jboss 5.0":

http://community.jboss.org/message/524986#524986

Author  : Anand Kumar
Profile : http://community.jboss.org/people/akstifr

Message:
--------------------------------------------------------------
Thank you for your reply 
 
Even after doing that i am unable to connect to Oracle database. I have placed driver file i.e ojdbc14.jar file in lib folder of default configuration.
 
It is giving the following errors:
 
14:26:02,015 INFO  [ProxyFactory] Bound EJB Home 'CommandExecutor' to jndi 'jbpm/CommandExecutor'
14:26:02,078 INFO  [BaseLocalProxyFactory] Bound EJB LocalHome 'Timer' to jndi 'java:jbpm/Timer'
14:26:02,078 WARN  [JmsActivation] Failure in jms activation org.jboss.resource.adapter.jms.inflow.JmsActivationSpec at 94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter at 180babf destination=queue/JbpmCommandQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=30000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=10)
javax.naming.NameNotFoundException: queue not bound
     at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
     at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
     at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
     at org.jnp.server.NamingServer.lookup(NamingServer.java:396)
     at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:713)
     at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:673)
     at javax.naming.InitialContext.lookup(Unknown Source)
     at org.jboss.util.naming.Util.lookup(Util.java:222)
     at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)
     at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)
     at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)
     at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)
     at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)
     at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:729)
     at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:204)
     at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
14:26:02,140 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
 
*** CONTEXTS MISSING DEPENDENCIES: Name -> Dependency{Required State:Actual State}
 
jboss.jca:name=JmsXA,service=ConnectionFactoryBinding
 -> jboss.jca:name=JmsXA,service=TxCM{Create:Configured}
 
jboss.jca:name=JmsXA,service=ManagedConnectionFactory
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 
jboss.jca:name=JmsXA,service=ManagedConnectionPool
 -> jboss.jca:name=JmsXA,service=ManagedConnectionFactory{Create:Configured}
 
jboss.jca:name=JmsXA,service=TxCM
 -> jboss.jca:name=JmsXA,service=ManagedConnectionPool{Create:Configured}
 
jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 -> jboss.messaging:service=PostOffice{Create:Configured}
 
jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
 -> jboss.messaging:service=PostOffice{Create:Configured}
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 
jboss.messaging.connectionfactory:service=ConnectionFactory
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 -> jboss.messaging:service=PostOffice{Create:Configured}
 
jboss.messaging.destination:name=DLQ,service=Queue
 -> jboss.messaging:service=PostOffice{Create:Configured}
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 
jboss.messaging.destination:name=ExpiryQueue,service=Queue
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 -> jboss.messaging:service=PostOffice{Create:Configured}
 
jboss.messaging:service=PostOffice
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 
jboss.mq.destination:name=JbpmCommandQueue,service=Queue
 -> jboss.mq:service=DestinationManager{Create:Configured}
 
jboss.mq:service=DestinationManager
 -> jboss.messaging:service=ServerPeer{Create:**ERROR**}
 
 
*** CONTEXTS IN ERROR: Name -> Error
 
jboss.messaging:service=ServerPeer -> java.lang.IllegalStateException: Failed to execute transaction | **ERROR**
 
jboss.ejb:service=EJB3TimerService -> org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
 [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist
]]
 
 
14:26:02,140 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
14:26:02,171 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
14:26:02,171 INFO  [ServerImpl] JBoss (Microcontainer) [5.0.0.GA (build: SVNTag=JBoss_5_0_0_GA date=200812041714)] Started in 1m:37s:328ms
14:26:12,078 INFO  [JmsActivation] Attempting to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec at 94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter at 180babf destination=queue/JbpmCommandQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=30000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=10)
14:26:12,078 ERROR [JmsActivation] Unable to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec at 94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter at 180babf destination=queue/JbpmCommandQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=30000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=10)

 
still unable to connect it...
 
Help me in connecting to Oracle

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/524986#524986