Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RDBMSRealm Error - ResultSet closed

0 views
Skip to first unread message

Kevin

unread,
Mar 23, 2001, 9:01:14 AM3/23/01
to

Hi,
Hopefully this is a simple properties file setting, but I am
trying to get the example RDBMSRealm to work, but am having a big
problem that I can't figure....any insight would be greatly appreciated.
I'm running weblogic 5.1 on Solaris, and here is the error I get
when I try to access a servlet who's permissions have been set
in the aclentries table:

Fri Mar 23 08:27:44 GMT-05:00 2001:<E> <ServletContextManager>
Servlet request terminiated with RuntimeException
java.sql.SQLException: ResultSet has already been closed
at weblogic.jdbcbase.oci.ResultSet.checkIfClosed(ResultSet.java:52)
at weblogic.jdbcbase.oci.ResultSet.next(ResultSet.java:796)
at examples.security.rdbmsrealm.RDBMSDelegate.getGroupInternal(RDBMSDelegate.java:499)
at examples.security.rdbmsrealm.RDBMSDelegate.getGroup(RDBMSDelegate.java:334)
at examples.security.rdbmsrealm.RDBMSDelegate.getPrincipal(RDBMSDelegate.java:734)
at examples.security.rdbmsrealm.RDBMSDelegate.getAclInternal(RDBMSDelegate.java:688)
at examples.security.rdbmsrealm.RDBMSDelegate.getAcl(RDBMSDelegate.java:591)
at examples.security.rdbmsrealm.RDBMSRealm.getAcl(RDBMSRealm.java:275)
at weblogic.security.acl.CachingRealm.getAcl(CachingRealm.java:1549)
at weblogic.security.acl.CachingRealm.getAcl(CachingRealm.java:1633)
at weblogic.security.acl.Security.hasPermission(Security.java:99)
at weblogic.servlet.internal.ServletContextImpl.checkA(ServletContextImpl.java:1832)
at weblogic.servlet.internal.ServletContextImpl.checkAccess(ServletContextImpl.java:1706)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:883)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)
--------------- nested within: ------------------
examples.security.rdbmsrealm.RDBMSException: caught SQL exception
- with nested exception:
[java.sql.SQLException: ResultSet has already been closed]
at examples.security.rdbmsrealm.RDBMSRealm.getAcl(RDBMSRealm.java:282)
at weblogic.security.acl.CachingRealm.getAcl(CachingRealm.java:1549)
at weblogic.security.acl.CachingRealm.getAcl(CachingRealm.java:1633)
at weblogic.security.acl.Security.hasPermission(Security.java:99)
at weblogic.servlet.internal.ServletContextImpl.checkA(ServletContextImpl.java:1832)
at weblogic.servlet.internal.ServletContextImpl.checkAccess(ServletContextImpl.java:1706)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:883)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:129)

Kevin

unread,
Mar 26, 2001, 11:39:26 AM3/26/01
to

Fixed the problem....had to set the getGroupNewStatement=true instead
of the default for Oracle which is false.
0 new messages