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@94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter(a)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@94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter(a)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@94d3fb(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter(a)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