[jboss-user] [JBoss Messaging] - Getting java.sql.SQLException: ORA-01460: unimplemented or u
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=DestinationManagerjboss.mq:service=DestinationManager depends optional-attribute-name=SecurityManagerjboss.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
[jboss-user] [JBoss Messaging] - Re: Issues w/ JBoss Messging Cluster Environment when using
Could any one please respond? I am unable to subcribe the messages I have published through my client. I am using Durable Subscriber. I am running the Subscriber client after I publsih all the mesages. Please verify whether my set up is correct or not. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4023747#4023747 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023747 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Messaging] - Re: Issues w/ JBoss Messging Cluster Environment when using
I have followed the instructions specified ClusterGuide.pdf file only. Some reason, I am not able to receive any of the messages by using Durable Subscriber. I have heard that, I need to modify the some state config file to specify the user name and then use that particular user in my client while creating connection. Could any one of you give me more details about the same? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4023771#4023771 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023771 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Messaging] - Issues w/ JBoss Messging Cluster Environment when using Dura
I am trying to set up the JBoss cluster in two machines. Here are the steps I have followed to set up and test the examples - 1) Installed the JBoss4.0.5 on 2 machines by using the default partition name 2) Modified the config files to refer to our in house Oracle Database 3) Installed the jboss-messaging1.2.CR1 on both the machines 4) Modified/added the config files to refer in house Oracle Database 5) Started the servers 6) Verified that the JMS related Tables have created in Oracle Database or not. They are created. 6) Ran the examples on Node1 machine - When both Nodes are up and running - Queue and Topic examples ran well - Getting exceptions while trying to run the other(Queue Failover, mdb etc.) examples. - When I shut down the Node1 server - None of the examples are running 7) Modifed jndi.properties file to set PORVIDER_URL parameter to 2 Nodes URLs on Node1 machine - When both Nodes are up and running - Queue and Topic examples ran well - Getting exceptions while trying to run the other(Queue Failover, mdb etc.) examples. - When I shut down the Node1 server - Queue and Topic examples ran well - Getting exceptions while trying to run the other(Queue Failover, mdb etc.) examples. After the above steps, I have following questions - 1) Why is Auto-Failover is not working? 2) Is there something wrong w/ my cluster configuration? 3) Do the clients need to know about all the running clusters? 4) How do both the clusters know each other? 5) Is there any heartbeat mechanism b/w both the clusters? 6) How do I make one of the cluster as ACTIVE node and the other as INACTIVE?(Inactive one becomes only active when the current active one becomes unavailable) Also I have written clients for both publisher and subscriber. We are planning to use durable subscriber. But I am unable to retrive any messages from my subscriber. Here is the code - | | Publisher | | import javax.jms.JMSException; | import javax.jms.Message; | import javax.jms.MessageListener; | import javax.jms.Topic; | import javax.jms.TopicConnection; | import javax.jms.TopicConnectionFactory; | import javax.jms.TopicPublisher; | import javax.jms.TopicSubscriber; | import javax.jms.TopicSession; | import javax.jms.TextMessage; | import javax.jms.DeliveryMode; | import javax.naming.Context; | import javax.naming.InitialContext; | import javax.naming.NamingException; | import java.util.Hashtable; | import javax.jms.MessageListener; | | /** A JMS client example program that sends a TextMessage to a Topic*/ | | public class TopicSendClient{ | | TopicConnection conn = null; | TopicConnection conn1 = null; | | TopicSession session = null; | | Topic topic = null; | | String CLIENT_ID = TopicClient; | | long MESSAGE_LIFESPAN = 180; //30 minutes | | public void setupPubSub() { | System.out.println(setupPubSub()); | | | // Initial environment with various properties | HashtableObject, Object env = new HashtableObject, Object(); | env.put(Context.INITIAL_CONTEXT_FACTORY, org.jnp.interfaces.NamingContextFactory); | env.put(Context.PROVIDER_URL, jnp://server1:1099,jnp://server2:1099); | env.put(Context.URL_PKG_PREFIXES, org.jboss.naming:org.jnp.interfaces); | | try{ | System.out.println(Before()); | InitialContext iniCtx = new InitialContext(env); | | System.out.println(ConnectionFactory Not exists); | | //InitialContext iniCtx = new InitialContext(); | Object tmp = iniCtx.lookup(ConnectionFactory); | | System.out.println(ConnectionFactory exists); | | TopicConnectionFactory tcf = (TopicConnectionFactory) tmp; | | //topic = (Topic) iniCtx.lookup(topic/testDistributedTopic); | topic = (Topic) iniCtx.lookup(topic/testTopic); | | System.out.println(TCF exists); | | conn = tcf.createTopicConnection(); | //conn1 = tcf.createTopicConnection(); | | //conn.setClientID(CLIENT_ID); | | System.out.println(Topic testTopic exists); | | session = conn.createTopicSession(false, TopicSession.AUTO_ACKNOWLEDGE); | | conn.start(); | }catch(Exception e){
[jboss-user] [JBoss Messaging] - Re: Issues w/ JBoss Messging Cluster Environment when using
Are you saying that my setup is correct? Additionally, could you please review my examples and let me know why I am not receiving messages published through the publisher? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4023320#4023320 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4023320 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user