[Datasource Configuration] - "Cursor state not valid" while paging through table
by Alexander Varakin
Alexander Varakin [https://community.jboss.org/people/avarakin] created the discussion
""Cursor state not valid" while paging through table"
To view the discussion, visit: https://community.jboss.org/message/716036#716036
--------------------------------------------------------------
Hi,
I am having a problem with an application which runs under AS 7.0.2 (7.1.0CR1 as well). It connects to database on AS400 using JPA interface and is able to read data from table on AS400 starting from row 0, but if I specify starting row more than 0 using query.setFirstResult, then I am getting an exception:
Caused by: java.sql.SQLException: Cursor state not valid.
at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:819)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:411)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1282)
at com.ibm.as400.access.AS400JDBCResultSet.absolute(AS400JDBCResultSet.java:1086)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.absolute(WrappedResultSet.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_29]
at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104) [hibernate-core-4.0.0.Final.jar:4.0.0.Final]
Same code works fine under Tomcat 7 and Hybernate 3.6.9.
I guess this is related to scrollable result set, it seems that Hibernate does not make result set as scrollable. Is there any way to make result set scrollable?
Would appreciate any help....
Alex
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/716036#716036]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 11 months
[JBoss Tools] - Extending JBoss Server
by Kamesh Sampath
Kamesh Sampath [https://community.jboss.org/people/kamesh_sampath] created the discussion
"Extending JBoss Server"
To view the discussion, visit: https://community.jboss.org/message/648618#648618
--------------------------------------------------------------
Hi,
I am trying to write a JBoss AS7 Adapter for my custom server which is an extension JBoss AS7. When i try to write adapter for i face few issues bacause at many places i see the JBoss AS plugin uses the checking for ServerUtil#isJBoss7 where it checks for the severTypes only from JBossServerCore plugins, thereby my custom serverType is not getting processed and few intiailizations and other stuff fails, rather than checking by serverTypeId can we not check to see if the server is an instance of JBoss7Server ?
is there any way to overcome this ?
My Platform details is
*Eclipse Platform --* Version: 3.7.1Build id: M20110909-1335
*JBoss Tools* -- 2.3.0.qualifier (Development Build)
--Kamesh
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/648618#648618]
Start a new discussion in JBoss Tools at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 11 months
[Datasource Configuration] - Re: How to configure Oracle with my application in jboss 5.0
by Ramazan YILDIRIM
Ramazan YILDIRIM [https://community.jboss.org/people/ryildirim] created the discussion
"Re: How to configure Oracle with my application in jboss 5.0"
To view the discussion, visit: https://community.jboss.org/message/715952#715952
--------------------------------------------------------------
[JmsActivation] Unable to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@7b682f(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter(a)185cb87 destination=queue/JbpmCommandQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=30000 useDLQ=true DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=10)
javax.naming.NameNotFoundException: queue not bound
This is due to default oracle-persistence-service.xml . jboss.messaging:service=PostOffice bean can not be deployed. You have to remove the jgroups properties if you are not using it as clustered or deploy jgroups ChannelFactory...
<attribute name="Clustered">false</attribute> remove the lines below this line....
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/715952#715952]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 11 months