2 Replies Latest reply on Dec 2, 2008 3:52 PM by Seshu Ganugapati

    Getting java.sql.SQLException: ORA-01460: unimplemented or u

    RAJENDRA KAVURI Newbie

      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.