Abhilash Chandran
2013-01-23 15:27:58 UTC
Abhilash Chandran [https://community.jboss.org/people/chotamail] created the discussion
"ERROR Queue[null, name=XYZ.QUEUE] startService java.sql.SQLException: Invalid argument(s) in call: setFetchSize"
To view the discussion, visit: https://community.jboss.org/message/793821#793821
--------------------------------------------------------------
Hi Together,
Currently I am working on a migration activity where we migrate from Jboss 4.2.2 Ga to Jboss 5.1.
During this, somehow i am unable to proceed with the Queue configurations and stuck up with the setFetchSize Error.
I configured my Queues as follows.
<mbean code="org.jboss.jms.server.destination.QueueService"
     name="jboss.messaging.destination:service=Queue,name=XYZ"
     xmbean-dd="xmdesc/Queue-xmbean.xml">
          <attribute name="JNDIName">queue/XYZ</attribute>
     <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
     <depends>jboss.messaging:service=PostOffice</depends>    Â
  </mbean>
and my topic as follows.
 <mbean code="org.jboss.jms.server.destination.TopicService"
     name="jboss.messaging.destination:service=Topic,name=XYZTopic"
     xmbean-dd="xmdesc/Topic-xmbean.xml">
     <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
     <depends>jboss.messaging:service=PostOffice</depends>
          <attribute name="JNDIName">topic/XYZTopic</attribute>
  </mbean>
And am using the Oracle-persistence-service.xml, Oracle-ds.xml instead HSQl Db..
I have removed the cluster related properties from my oracle-persitence-service.xml file to avoid the null pointer exception facedd while trying to get the postoffice instances.
But currently i am facing the following issue- Any kind of adivce or suggestion is welcome. Thanks a lot in advance.
*Topics are deploying* :) while *the Queues are not deploying :-/* and giving away the following exception
23 Jan 13 13:25:37, ERROR Queue[null, name=XYZ] startService
java.sql.SQLException: Invalid argument(s) in call: setFetchSize
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
         at oracle.jdbc.driver.OracleStatement.setPrefetchInternal(OracleStatement.java:2384)
         at oracle.jdbc.driver.OracleStatement.setFetchSize(OracleStatement.java:3323)
         at org.jboss.resource.adapter.jdbc.WrappedStatement.setFetchSize(WrappedStatement.java:647)
         at org.jboss.messaging.core.impl.JDBCPersistenceManager.loadFromStart(JDBCPersistenceManager.java:1069)
         at org.jboss.messaging.core.impl.PagingChannelSupport.load(PagingChannelSupport.java:213)
         at org.jboss.messaging.core.impl.MessagingQueue.load(MessagingQueue.java:519)
         at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:109)
         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
         at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
         at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:597)
         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
         at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
         at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
         at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
         at $Proxy38.start(Unknown Source)
         at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
         at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
         at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
         at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
         at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
         at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
         at org.jboss.system.ServiceController.start(ServiceController.java:460)
         at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
         at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
         at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
         at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
         at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
         at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
         at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
         at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
         at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
         at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
         at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
         at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
         at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
         at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
         at org.jboss.Main.boot(Main.java:221)
         at org.jboss.Main$1.run(Main.java:556)
         at java.lang.Thread.run(Thread.java:662)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/793821#793821]
Start a new discussion in JBoss Messaging at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042]
"ERROR Queue[null, name=XYZ.QUEUE] startService java.sql.SQLException: Invalid argument(s) in call: setFetchSize"
To view the discussion, visit: https://community.jboss.org/message/793821#793821
--------------------------------------------------------------
Hi Together,
Currently I am working on a migration activity where we migrate from Jboss 4.2.2 Ga to Jboss 5.1.
During this, somehow i am unable to proceed with the Queue configurations and stuck up with the setFetchSize Error.
I configured my Queues as follows.
<mbean code="org.jboss.jms.server.destination.QueueService"
     name="jboss.messaging.destination:service=Queue,name=XYZ"
     xmbean-dd="xmdesc/Queue-xmbean.xml">
          <attribute name="JNDIName">queue/XYZ</attribute>
     <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
     <depends>jboss.messaging:service=PostOffice</depends>    Â
  </mbean>
and my topic as follows.
 <mbean code="org.jboss.jms.server.destination.TopicService"
     name="jboss.messaging.destination:service=Topic,name=XYZTopic"
     xmbean-dd="xmdesc/Topic-xmbean.xml">
     <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
     <depends>jboss.messaging:service=PostOffice</depends>
          <attribute name="JNDIName">topic/XYZTopic</attribute>
  </mbean>
And am using the Oracle-persistence-service.xml, Oracle-ds.xml instead HSQl Db..
I have removed the cluster related properties from my oracle-persitence-service.xml file to avoid the null pointer exception facedd while trying to get the postoffice instances.
But currently i am facing the following issue- Any kind of adivce or suggestion is welcome. Thanks a lot in advance.
*Topics are deploying* :) while *the Queues are not deploying :-/* and giving away the following exception
23 Jan 13 13:25:37, ERROR Queue[null, name=XYZ] startService
java.sql.SQLException: Invalid argument(s) in call: setFetchSize
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
         at oracle.jdbc.driver.OracleStatement.setPrefetchInternal(OracleStatement.java:2384)
         at oracle.jdbc.driver.OracleStatement.setFetchSize(OracleStatement.java:3323)
         at org.jboss.resource.adapter.jdbc.WrappedStatement.setFetchSize(WrappedStatement.java:647)
         at org.jboss.messaging.core.impl.JDBCPersistenceManager.loadFromStart(JDBCPersistenceManager.java:1069)
         at org.jboss.messaging.core.impl.PagingChannelSupport.load(PagingChannelSupport.java:213)
         at org.jboss.messaging.core.impl.MessagingQueue.load(MessagingQueue.java:519)
         at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:109)
         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
         at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
         at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:597)
         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
         at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
         at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
         at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
         at $Proxy38.start(Unknown Source)
         at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
         at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
         at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
         at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
         at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
         at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
         at org.jboss.system.ServiceController.start(ServiceController.java:460)
         at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
         at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
         at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
         at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
         at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
         at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
         at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
         at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
         at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
         at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
         at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
         at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
         at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
         at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
         at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
         at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
         at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
         at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
         at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
         at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
         at org.jboss.Main.boot(Main.java:221)
         at org.jboss.Main$1.run(Main.java:556)
         at java.lang.Thread.run(Thread.java:662)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/793821#793821]
Start a new discussion in JBoss Messaging at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042]