Config for Oracle as Persistent Store
Arun Thangamani
I am new to Application Servers.
I have trying to configure Oracle as Persistent Store,
while starting the weblogic server the server says( everything is fine) DBMS
is Oracle, Connection pool started, persistent store started and all that
but i am getting the following error message when i am trying to run the
JMSDrawDemo with persistant message store.
did i miss out anything with the coinfiguration.
Please Advice
***********mess while running in DrawDemo(when making the persistence check
box *************************
javax.jms.JMSException: System error:
weblogic.rmi.extensions.RemoteRuntimeException: Undeclared checked
exception - with nested exception:
[weblogic.rmi.ConnectException: Failed to create socket to:
8557347154182732747S192.168.1.64:[7001,7001,7002,7002,7001,-1] using
protocol t3]
at
weblogic.jms.common.JMSUtilities.jmsException(JMSUtilities.java:18)
at
weblogic.jms.client.JMSSession.handleException(JMSSession.java:682)
at
weblogic.jms.client.JMSSession.removeProducer(JMSSession.java:596)
at
weblogic.jms.client.JMSMessageProducer.close(JMSMessageProducer.java:243)
at examples.jms.drawdemo.JMSDrawDemo.exit(JMSDrawDemo.java:252)
at
examples.jms.drawdemo.JMSDrawDemo.access$000(JMSDrawDemo.java:100)
at
examples.jms.drawdemo.JMSDrawDemo$1.windowClosing(JMSDrawDemo.java:549)
at java.awt.Window.processWindowEvent(Window.java:798)
at javax.swing.JFrame.processWindowEvent(JFrame.java:241)
at java.awt.Window.processEvent(Window.java:774)
at java.awt.Component.dispatchEventImpl(Component.java:2595)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Window.dispatchEventImpl(Window.java:912)
at java.awt.Component.dispatchEvent(Component.java:2499)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:319)
at
java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:103)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:84)
Arun Thangamani
***********mess while running in DrawDemo(when checking the persistence
check box) *************************
javax.jms.JMSException: Error allocating key for JMSMessage
at
weblogic.rmi.extensions.AbstractRequest.sendReceive(AbstractRequest.java:76)
at
weblogic.jms.common.WLStuby1u2v1o3yc724g271r7304w243q64.sendMessage(WLStuby1
u2v1o3yc724g271r7304w243q64.java:478)
at weblogic.jms.client.JMSSession.sendMessage(JMSSession.java:391)
at
weblogic.jms.client.JMSMessageProducer.publish(JMSMessageProducer.java:78)
at
examples.jms.drawdemo.JMSDrawDemo.publishPoint(JMSDrawDemo.java:199)
at
examples.jms.drawdemo.JMSDrawDemo.mouseReleased(JMSDrawDemo.java:383)
at java.awt.Component.processMouseEvent(Component.java:3717)
at java.awt.Component.processEvent(Component.java:3546)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2595)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2499)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
Steven Pozarycki
I assume that JMS started and is active, You saw this message:
<JMS> Startup process complete. JMS is active
correct?
Based on the stack trace below I suspect that the tables weren't created
correctly. Did you
create all of the JMS tables using the DDL statements we provide?
($WEBLOGICHOME/classes/weblogic/jms/ddl/jms_oracle.ddl)
You should be able to create the tables using something like this command:
java utils.Schema jdbc:weblogic:oracle:<YOUR_SERVER> weblogic.jdbc.oci.Driver -u
<USER>
-p <PASSWORD> -verbose $WEBLOGICHOME\classes\weblogic\jms\ddl\jms_oracle.ddl
You could also look in the docs (if you're using 5.1 use docs51 instead of
docs45) under:
http://www.weblogic.com/docs45/classdocs/API_jms.html#createjmsdb
Thanks.