[
https://issues.apache.org/jira/browse/GERONIMO-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470276
]
Hernan Cunico commented on GERONIMO-2799:
-----------------------------------------
I verified this issue, the Security Realm portlet is not retrieving any
connection data from the specified database pool.
> Creating SQL-based security realm fails via combobox-database-pool-selection
> ----------------------------------------------------------------------------
>
> Key: GERONIMO-2799
> URL: https://issues.apache.org/jira/browse/GERONIMO-2799
> Project: Geronimo
> Issue Type: Bug
> Security Level: public(Regular issues)
> Affects Versions: 2.0-M2
> Environment: Windows XP, Tomcat
> Reporter: Torsten Krall
> Priority: Minor
>
> I created and deployed a global database pool "tkldienstplanpool", the
> test worked fine.
> Now I want to use this database pool within a sql-security-realm but the
> test throws following exception:
> java.lang.IllegalArgumentException: interface
> org.tranql.connector.DissociatableConnectionHandle is not visible from
> class loader
> Creating a security-realm by copy&paste of all parameters of the deployed
> golbal database-pool works finde.
> Due to this workaround I set this bug-report to minor-priority.
> Best regards,
> Torsten Krall
> Entire stacktrace:
> 13:17:26,455 INFO [DatabasePoolPortlet] Deployment completed successfully!
> 13:31:56,477 WARN [SecurityRealmPortlet] Testing with options
> {groupSelect=SELECT d1.username, d2.name as gruppe FROM
> dp_realm_user_group d
> INNER JOIN dp_realm_user d1 ON d1.id=d.user INNER JOIN dp_realm_group
> d2 ON d2.id=d.group WHERE d1.username=?, org.apache.geronimo.security
> .realm.GenericSecurityRealm.CLASSLOADER=[org.apache.geronimo.kernel.classloader.JarFileClassLoader
> id=org.apache.geronimo.configs/webconsole
> -tomcat_standard.war/2.0-M2/car], dataSourceApplication=null,
> userSelect=select username, password from dp_realm_user where
> username=?, data
> SourceName=tkldienstplanpool3}
> 13:32:10,276 WARN [SecurityRealmPortlet] Test login failed
> javax.security.auth.login.LoginException: SQL error
> at
> org.apache.geronimo.security.realm.providers.SQLLoginModule.login(SQLLoginModule.java:257)
> at
> org.apache.geronimo.console.util.KernelManagementHelper.testLoginModule(KernelManagementHelper.java:423)
> at
> org.apache.geronimo.console.util.PortletManager.testLoginModule(PortletManager.java:160)
> at
> org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortlet.actionAttemptLogin(SecurityRealmPortlet.java:334)
> at
> org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortlet.processAction(SecurityRealmPortlet.java:215)
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
> at
> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
> at
> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:687)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
> at
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
> at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
> at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:338)
> at
> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:517)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: java.sql.SQLException
> at
> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:61)
> at
> $javax.sql.DataSource$FastClassByCGLIB$6525cafd.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
> at
> org.apache.geronimo.connector.ConnectorMethodInterceptor.intercept(ConnectorMethodInterceptor.java:54)
> at
> $javax.sql.DataSource$EnhancerByCGLIB$8b609c1.getConnection(<generated>)
> at
> org.apache.geronimo.security.realm.providers.SQLLoginModule.login(SQLLoginModule.java:194)
> ... 38 more
> Caused by: javax.resource.ResourceException: Unable to construct
> connection proxy
> at
> org.apache.geronimo.connector.outbound.connectiontracking.ConnectionTrackingCoordinator.proxyConnection(ConnectionTrackingCoordin
> ator.java:238)
> at
> org.apache.geronimo.connector.outbound.connectiontracking.ConnectionTrackingCoordinator.handleObtained(ConnectionTrackingCoordina
> tor.java:157)
> at
> org.apache.geronimo.connector.outbound.connectiontracking.ConnectionTrackingCoordinator$FastClassByCGLIB$5d33aabf.invoke(<gener
> ated>)
> at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
> at
> org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethodInvoker.java:38)
> at
> org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:127)
> at
> org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:820)
> at
> org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:57)
> at
> org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperationInvoker.java:35)
> at
> org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(ProxyMethodInterceptor.java:96)
> at
> org.apache.geronimo.gbean.GBeanLifecycle$EnhancerByCGLIB$51d42e0c.handleObtained(<generated>)
> at
> org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:67)
> at
> org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:61)
> at
> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
> ... 43 more
> Caused by: java.lang.IllegalArgumentException: interface
> org.tranql.connector.DissociatableConnectionHandle is not visible from
> class loader
> at java.lang.reflect.Proxy.getProxyClass(Proxy.java:353)
> at java.lang.reflect.Proxy.newProxyInstance(Proxy.java:581)
> at
> org.apache.geronimo.connector.outbound.connectiontracking.ConnectionTrackingCoordinator.proxyConnection(ConnectionTrackingCoordin
> ator.java:230)
> ... 56 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
