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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...