Running Example RDBMS Realm error
Tim Uy
Hi,
I was trying to run the example RDBMS realm on an Oracle database on WLS6.0 sp2.
I got the users and the groups from the database but when I was trying to access
the ACLs, I got the following exception on the WebLogic Console:
An unexpected error was encountered in processing your request.
Exception
weblogic.management.configuration.RealmException: RealmManager.listAcls - with
nested exception:
[examples.security.rdbmsrealm.RDBMSException: RDBMSEnumeration.nextElement failed
- with nested exception:
[java.sql.SQLException: ResultSet has already been closed]]
at weblogic.management.configuration.RealmManager.listAcls(RealmManager.java:203)
at weblogic.management.console.pages._panels._mbean._acltable._jspService(_acltable.java:213)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
Current Date
Tue Jun 12 09:37:31 PDT 2001
Console Release Build
6.0 Service Pack 2
Console Build
6.0 Service Pack 2 05/24/2001 11:55:28 #117037
Server Release Build
6.0 Service Pack 2
Server Build
6.0 Service Pack 2 05/24/2001 11:55:28 #117037
All Server Product Versions
WebLogic Server Build: 6.0 Service Pack 2 05/24/2001 11:55:28 #117037
WebLogic XML Module: 6.0 Service Pack 2 05/24/2001 12:34:27 #117037
Request Info
Protocol: HTTP/1.1
ServerName: localhost
ServerPort: 7001
Secure: false
ContextPath: /console
ServletPath: /common/error.jsp
QueryString: null
PathInfo: null
PathTranslated: null
RequestURI: /console/common/error.jsp
AuthType: null
ContentType: null
CharacterEncoding: null
Locale: en_US
Method: GET
Session: weblogic.servlet.internal.session.MemorySessionData@166179
RequestedSessionId: OyZEYmagLdHQZCc8zduXEcLaxw3v88qDGwnlIVMyIv1vlx5G5UBr/console
RequestedSessionIdFromCookie: true
RequestedSessionIdFromURL: false
UserPrincipal: null
RemoteUser: null
RemoteAddr: 127.0.0.1
RemoteHost: localhost
Parameters
mbean = examples:Type=Domain,Name=examples
Attributes
console.original./console/common/error.jsp.ContextPath = /console
console.original./console/common/error.jsp.Method = GET
console.original./console/common/error.jsp.RequestURI = /console/common/error.jsp
console.original./console/common/error.jsp.ServletPath = /common/error.jsp
console.original./console/panels/mbean/AclTable.jsp.ContextPath = /console
console.original./console/panels/mbean/AclTable.jsp.Method = GET
console.original./console/panels/mbean/AclTable.jsp.QueryString = mbean=examples%3AType%3DDomain%2CName%3Dexamples
console.original./console/panels/mbean/AclTable.jsp.RequestURI = /console/panels/mbean/AclTable.jsp
console.original./console/panels/mbean/AclTable.jsp.ServletPath = /panels/mbean/AclTable.jsp
javax.servlet.include.context_path = /console
javax.servlet.include.request_uri = /console/common/requestinfo.jsp
javax.servlet.include.servlet_path = /common/requestinfo.jsp
javax.servlet.jsp.jspException = weblogic.management.configuration.RealmException:
RealmManager.listAcls - with nested exception:
[examples.security.rdbmsrealm.RDBMSException: RDBMSEnumeration.nextElement failed
- with nested exception:
[java.sql.SQLException: ResultSet has already been closed]]
weblogic.management.console.tags.ContentTag = java.lang.Object@23af64
weblogic.management.console.tags.HeaderTag = java.lang.Object@4fed14
Headers
Accept = image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel,
application/msword, application/vnd.ms-powerpoint, application/pdf, */*
Accept-Encoding = gzip, deflate
Accept-Language = en-us
Connection = Keep-Alive
Cookie = JSESSIONID=OyZEYmagLdHQZCc8zduXEcLaxw3v88qDGwnlIVMyIv1vlx5G5UBr!922164551288998595!-1502865397!7001!7002
Host = localhost:7001
User-Agent = Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
BrowserInfo
User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
IE: true
Netscape: false
Supported: true
JavscriptHrefs: false
TableCellClick: true
DocumentReloadedOnResize: false
DropdownStretchable: true
CellSpacingBlank: false
EmptyCellBlank: false
ImgOnclickSupported: true
TableBorderFancy: true
PartialToWideTables: false
Server System Properties
awt.toolkit = sun.awt.windows.WToolkit
bea.home = C:\weblogic
cloudscape.system.home = ./samples/eval/cloudscape/data
file.encoding = Cp1252
file.encoding.pkg = sun.io
file.separator = \
java.awt.fonts =
java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
java.awt.printerjob = sun.awt.windows.WPrinterJob
java.class.path = .;.\lib\weblogic_sp.jar;.\lib\weblogic.jar;.\samples\eval\cloudscape\lib\cloudscape.jar;.\config\examples\serverclasses
java.class.version = 47.0
java.ext.dirs = C:\weblogic\jdk130\jre\lib\ext
java.home = C:\weblogic\jdk130\jre
java.io.tmpdir = C:\TEMP\
java.library.path = C:\weblogic\jdk130\bin;.;C:\WINNT\System32;C:\WINNT;.\bin;C:\weblogic\wls6.0sp1\bin;C:\weblogic\jdk130\bin;D:\Oracle\Ora81\bin;C:\Program
Files\Oracle\jre\1.1.7\bin;c:\tuxedo65\bin;D:\Visigenic\vbroker\bin;c:\winnt\system32;c:\winnt;C:\WLEDIR\bin;c:\mercator;C:\Program
Files\Rational\common;C:\Program Files\Mercury Interactive\LoadRunner\bin;D:\Oracle\Ora81\orb\bin;.\bin\oci816_8
java.naming.factory.initial = weblogic.jndi.WLInitialContextFactory
java.naming.factory.url.pkgs = weblogic.jndi.factories
java.protocol.handler.pkgs = weblogic.utils|weblogic.utils|weblogic.net|weblogic.management|weblogic.net|weblogic.net|weblogic.utils
java.runtime.name = Java(TM) 2 Runtime Environment, Standard
Edition
java.runtime.version = 1.3.0-C
java.security.policy = =C:\weblogic\wls6.0sp1/lib/weblogic.policy
java.specification.name = Java Platform API Specification
java.specification.vendor = Sun Microsystems Inc.
java.specification.version = 1.3
java.vendor = Sun Microsystems Inc.
java.vendor.url = http://java.sun.com/
java.vendor.url.bug = http://java.sun.com/cgi-bin/bugreport.cgi
java.version = 1.3.0
java.vm.info = mixed mode
java.vm.name = Java HotSpot(TM) Client VM
java.vm.specification.name = Java Virtual Machine Specification
java.vm.specification.vendor = Sun Microsystems Inc.
java.vm.specification.version = 1.0
java.vm.vendor = Sun Microsystems Inc.
java.vm.version = 1.3.0-C
javax.rmi.CORBA.PortableRemoteObjectClass = weblogic.iiop.PortableRemoteObjectDelegateImpl
javax.rmi.CORBA.UtilClass = weblogic.iiop.UtilDelegateImpl
javax.xml.parsers.DocumentBuilderFactory = weblogic.xml.jaxp.RegistryDocumentBuilderFactory
javax.xml.parsers.SAXParserFactory = weblogic.xml.jaxp.RegistrySAXParserFactory
jmx.implementation.name = JMX RI
jmx.implementation.vendor = Sun Microsystems
jmx.implementation.version = 1.0
jmx.specification.name = Java Management Extensions
jmx.specification.vendor = Sun Microsystems
jmx.specification.version = 1.0 Final Release
line.separator =
os.arch = x86
os.name = Windows NT
os.version = 4.0
path.separator = ;
sun.boot.class.path = C:\weblogic\jdk130\jre\lib\rt.jar;C:\weblogic\jdk130\jre\lib\i18n.jar;C:\weblogic\jdk130\jre\lib\sunrsasign.jar;C:\weblogic\jdk130\jre\classes
sun.boot.library.path = C:\weblogic\jdk130\jre\bin
sun.cpu.endian = little
sun.cpu.isalist = pentium_pro+mmx pentium_pro pentium+mmx
pentium i486 i386
sun.io.unicode.encoding = UnicodeLittle
user.dir = C:\weblogic\wls6.0sp1
user.home = C:\WINNT\Profiles\tuy.000
user.language = en
user.name = tuy
user.region = US
user.timezone = America/Los_Angeles
weblogic.Domain = examples
weblogic.Name = examplesServer
weblogic.security.jaas.Configuration = weblogic.security.internal.ServerConfig
weblogic.security.jaas.Policy = ./lib/Server.policy
Has any one seen this before? It only occured when I loaded the database.
Thanks,
Tim
Mary Ann Slavin
Tom Moreau
Actually, the RDBMSRealm partially supports ACLs.
The RDBMSRealm reads ACL information from the database
therefore supports permission checking.
However, the RDBMSRealm does not support
creating/editing/removing ACLs from the console.
Instead, it relies on the administrator putting
the ACLs into the database using sql scripts.
-Tom
Serhii Sokolenko
I had a similar problem. The solution is to set the getGroupNewStatement
Realm property to true.
Serhii
"ananya" <ana...@indiaserver.com> wrote in message
news:<3b32...@newsgroups.bea.com>...
> Hi Narin,
> I seem to have forgotten to mention that the problem got fixed when I set
getGroupNewStatement
> to true.
> Anu
>
"Tim Uy" <ti...@yahoo.com> wrote in message
news:3b2647ff$1...@newsgroups.bea.com...