Hi
I have configured JBoss4.0.5 n 2 physical machines to test cluster enabled JMS.
I am using HA-JNDI/HA-JMS to run application. Also, I have configured to use
oracle as backend database.
Here are the configs I have used -
jbossmq-destinations-service.xml
<depends
optional-attribute-name="DestinationManager">jboss.mq:service=DestinationManager
<depends
optional-attribute-name="SecurityManager">jboss.mq:service=SecurityManager
jbossmq-service.xml - default configuration
login-config.xml - Modified to add Oracle references
Once I modified the files, I have started the server on both the one machines.
My serverPublishTopic has created. Also, I have verified the databse and found
the rquired tables have created.
We have Java Swing based GUI application which is having one server and
multiple clients. When I am trying to login my application try to establish the
JMS connection from the server as well as from the client. I have verified the
logs and found that the connection is esatblsihed properly. In my case server
publsihes the messages and clinets alwasys the subscribes the messages. We are
using Persistent publsiher and Durable subscriber.
But when server is trying to publish the messages I am getting the following
exception. It seems Jboss is unable to store the messages in Oracle database.
om.indigo.base.BasketException: Could not store message: 4813 msg=1070 hard
NOT_STORED PERSISTENT
queue=TOPIC.serverPublishTopic.DurableSubscription[clientId=guest name=guest
selector=(originator <> 'guest' AND filter = 'N') OR guest = 'Y'] priority=4
lateClone=false hashCode=2769003; - nested throwable: (java.sql.SQLException:
ORA-01460: unimplemented or unreasonable conversion requested
)
at com.indigo.utils.BasketLoader.save(BasketLoader.java:828)
at com.indigo.utils.BasketLoader.createBasket(BasketLoader.java:1159)
at com.indigo.base.Basket.createIndexBasket(Basket.java:1926)
at toplevel.HunterTest5.createIndexBasket(HunterTest5.java:83)
at toplevel.HunterTest5.init(HunterTest5.java:37)
at
com.indigo.neuron.client.AbstractAlgorithm.run(AbstractAlgorithm.java:2294)
at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.mq.SpyJMSException: Could not store message: 4813 msg=1070
hard NOT_STORED PERSISTENT
queue=TOPIC.serverPublishTopic.DurableSubscription[clientId=guest name=guest
selector=(originator <> 'guest' AND filter = 'N') OR guest = 'Y'] priority=4
lateClone=false hashCode=2769003; - nested throwable: (java.sql.SQLException:
ORA-01460: unimplemented or unreasonable conversion requested
)
at com.indigo.utils.jms.JMSSource.publish(JMSSource.java:475)
at
com.indigo.basketserver.ServerSideJMSRMIDriver.invokePublish(ServerSideJMSRMIDriver.java:435)
at
com.indigo.basketserver.ServerSideJMSRMIDriver.access$1(ServerSideJMSRMIDriver.java:415)
at
com.indigo.basketserver.ServerSideJMSRMIDriver$ModelNone.invokeMethodForAll(ServerSideJMSRMIDriver.java:965)
at
com.indigo.basketserver.ServerSideJMSRMIDriver.invokeMethodForAll(ServerSideJMSRMIDriver.java:453)
at
com.indigo.basketserver.ServerSideJMSRMIDriver.invokeMethodForAll(ServerSideJMSRMIDriver.java:402)
at
com.indigo.basketserver.ServerSideJMSRMIDriver.processBasket(ServerSideJMSRMIDriver.java:485)
at
com.indigo.basketserver.ServerSideProcessor.sendBasket(ServerSideProcessor.java:237)
at
com.indigo.basketserver.RemoteServerImpl.sendBasket(RemoteServerImpl.java:224)
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:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at com.indigo.basketserver.RemoteServerImpl_Stub.sendBasket(Unknown
Source)
at
com.indigo.basketserver.ClientSideRMIJMSDriver$4.execute(ClientSideRMIJMSDriver.java:497)
at
com.indigo.basketserver.ClientSideRMIJMSDriver.makeRequest(ClientSideRMIJMSDriver.java:464)
at
com.indigo.basketserver.ClientSideRMIJMSDriver.sendBasket(ClientSideRMIJMSDriver.java:495)
at com.indigo.utils.BasketLoader.save(BasketLoader.java:826)
... 6 more
Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable
conversion requested
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1136)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1082)
at
org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:58)
at
org.jboss.mq.server.SelectorPersistentQueue.addMessage(SelectorPersistentQueue.java:84)
at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:392)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:415)
at
org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:399)
at
org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:106)
at
org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168)
at
org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:226)
at
org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112)
at
org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:111)
at
org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:395)
at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398)
at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:595)
Please respond to this query w/ a possible solution as soon as possible.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4026643#4026643
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4026643
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
