Another question about the share group

Openfire Openfire Support
1

This has one BUG, I added 20 groups in the admin console , the webpage shows 15 row of every pages, but it shows that the content of second page is blank. That is to say that I am unable to add users to the following groups. please help me…

it’'s error.log:

2005.01.20 21:38:43 org.jivesoftware.messenger.group.DefaultGroupProvider.getGroups(DefaultGroupProv ider.java:286)

java.sql.SQLException: Invalid operation for forward only resultset : absolute

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.driver.BaseResultSet.absolute(BaseResultSet.java:97)

at org.jivesoftware.database.DbConnectionManager.scrollResultSet(DbConnectionManag er.java:226)

at org.jivesoftware.messenger.group.DefaultGroupProvider.getGroups(DefaultGroupPro vider.java:277)

at org.jivesoftware.messenger.group.GroupManager.getGroups(GroupManager.java:185)

at org.jivesoftware.messenger.admin.group_002dsummary_jsp._jspService(group_002dsu mmary_jsp.java:135)

2

Thanks for the bug report. This issue will be fixed for 2.1.1 and is being tracked as JM-131.

Regards,

Matt

3

today i try messenger2.1.1 ,it’‘s correct a lot of bug about share group,now it’‘s right on the whole,only have a bug, when share group more 20,Pagination can’'t show latter share group in web admin.

it’'s error log:

2005.01.31 10:53:06 org.jivesoftware.messenger.group.DefaultGroupProvider.getGroups(DefaultGroupProv ider.java:286)

java.sql.SQLException: Invalid operation for forward only resultset : relative

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.driver.BaseResultSet.relative(BaseResultSet.java:104)

at org.jivesoftware.database.DbConnectionManager.scrollResultSet(DbConnectionManag er.java:226)

at org.jivesoftware.messenger.group.DefaultGroupProvider.getGroups(DefaultGroupPro vider.java:277)

at org.jivesoftware.messenger.group.GroupManager.getGroups(GroupManager.java:185)

at org.jivesoftware.messenger.admin.group_002dsummary_jsp._jspService(group_002dsu mmary_jsp.java:135)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:816)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:807)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:76)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:807)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:488)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

4

Tom,

Which Oracle JDBC driver are you using?

-Matt

5

i use JDBC Driver Version: 9.2.0.5.0 . my oracle DB is 8.1.7.4.0.

6

Are you using the “thin” driver or another one?

Regards,

Matt

7

there is my database connect info:

Database Connection Info

Database and Version: Oracle Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production

JDBC Driver: Oracle JDBC driver

JDBC Driver Version: 9.2.0.5.0

DB Connection URL: jdbc:oracle:thin:@localhost:1521:jivexmpp

DB User: JIVE

Transaction Support: Yes

Transaction Isolation Level: TRANSACTION_READ_COMMITTED

Supports multiple connections

open at once: Yes

In read-only mode: No