JSF Glassfish jdbcRelam und Oracle-Datenbank - WEB9102: Web Login Failed

[jpond]

Hallo zusammen,

noch einer bei dem jdbcRelam Login nicht funktioniert. Allerdings nur mit Oracle Datenbank. Wenn ich MySql oder fileRelame benutzt, funktioneirt es :wuerg: Daher denke ich, dass es an Oracle bzw. die Kombination Oracle / Glassfish-Relams liegt.
Ich bin seit 2 Tage am googlen und probieren. Vielleicht könnt ihr helfen! ;(

Hier die Fakten:
Server: Glassfish 4.0

Relams: da ich keinen Bild hier hochladen kann hier ein XML Auszug
[XML]<auth-realm name="myProjectJdbcRelam" classname="com.sun.enterprise.security.ee.auth.realm.jdbc.JDBCRealm">
<property name="jaas-context" value="jdbcRealm"></property>
<property name="password-column" value="passwort"></property>
<property name="datasource-jndi" value="jdbc/Oracle"></property>
<property name="group-table" value="view_benutzer_gruppen"></property>
<property name="user-table" value="view_benutzer_gruppen"></property>
<property name="group-name-column" value="gruppenname"></property>
<property name="digestrealm-password-enc-algorithm" value="SHA-256"></property>
<property name="group-table-user-name-column" value="benutzername"></property>
<property name="user-name-column" value="benutzername"></property>
</auth-realm>[/XML]

Datenbankl Connection Pool und Resource funktionieren

web.xml
[XML]<login-config>
<auth-method>FORM</auth-method>
<realm-name>myProjectJdbcRelam</realm-name>
<form-login-config>
<form-login-page>/login/index.jsf</form-login-page>
<form-error-page>/login/index.jsf</form-error-page>
</form-login-config>
</login-config> [/XML]

glassfish-web.xml
[XML]<security-role-mapping>
<role-name>Administrator</role-name><!-- wie in web.xml -->
<group-name>Administrators</group-name><!-- wie in Datenbank -->
</security-role-mapping>
<security-role-mapping>
<role-name>User</role-name><!-- wie in web.xml -->
<group-name>Users</group-name><!-- wie in Datenbank -->
</security-role-mapping>[/XML]

Java Klasse - Controller:

FacesContext fContext =FacesContext.getCurrentInstance();
ExternalContext externalContext = fContext.getExternalContext();
HttpServletRequest request = (HttpServletRequest) externalContext.getRequest();
try {
	// credentials -> aus dem Login-Formular 
	request.login(credentials.getUsername(), credentials.getPassword());
} catch (ServletException e1) {
	fContext.addMessage(null, new FacesMessage("Loginfehler!!: " + e1.getMessage()));
	e1.printStackTrace();
}

Datenbanktabelle:
Benutze Oracle 11g.

-- Die Fremdschlüssel sind entsprechen erstellt.
-- passwort enthält den hashwert des Passwort.
CREATE TABLE Benutzer (
id NUMBER NOT NULL,
benutzername VARCHAR2(255) UNIQUE NOT NULL,
passwort VARCHAR2(255) NOT NULL,
logindatum TIMESTAMP DEFAULT SYSTIMESTAMP,
PRIMARY KEY (id)
);

CREATE TABLE Gruppe (
  id NUMBER NOT NULL,
  gruppenname VARCHAR(255) UNIQUE NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE Benutzer_Gruppe(
  benutzer_id NUMBER NOT NULL,
  gruppen_id NUMBER NOT NULL,
  UNIQUE(benutzer_id, gruppen_id)
);
CREATE OR REPLACE FORCE VIEW VIEW_BENUTZER_GRUPPEN (ID, BENUTZERNAME, PASSWORT, LOGINDATUM, GRUPPENNAME) 
AS 
  SELECT b.ID,b.BENUTZERNAME,b.PASSWORT,b.LOGINDATUM, g.gruppenname
  FROM BENUTZER b
  JOIN BENUTZER_GRUPPE bg ON b.ID = bg.BENUTZER_ID
  JOIN GRUPPE g ON g.ID = bg.GRUPPEN_ID;

Exception

2014-05-19T16:34:23.439+0200|Warnung: WEB9102: Web Login Failed: com.sun.enterprise.security.auth.login.common.LoginException: Login failed: Security Exception
2014-05-19T16:34:23.440+0200|Information: 2014-05-19 16:34:23,440 DEBUG [http-listener-2(5)] [de.demo.myProject.controller.LoginController.login(LoginController.java:86)] console: Login failed
2014-05-19T16:34:23.442+0200|Schwerwiegend: javax.servlet.ServletException: Login failed
	at org.apache.catalina.authenticator.AuthenticatorBase.doLogin(AuthenticatorBase.java:959)
	at org.apache.catalina.authenticator.AuthenticatorBase.login(AuthenticatorBase.java:939)
	at org.apache.catalina.connector.Request.login(Request.java:2245)
	at org.apache.catalina.connector.Request.login(Request.java:2224)
	at org.apache.catalina.connector.RequestFacade.login(RequestFacade.java:1113)
	at de.demo.myProject.controller.LoginController.login(LoginController.java:80)
	at de.demo.myProject.controller.LoginController$Proxy$_$$_WeldClientProxy.login(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.sun.el.parser.AstValue.invoke(AstValue.java:275)
	at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)
	at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40)
	at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50)
	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
	at javax.faces.component.UICommand.broadcast(UICommand.java:315)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)
	at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:646)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:357)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:260)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:188)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:191)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:168)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:189)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:288)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:206)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:136)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:114)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:838)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:113)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:115)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:55)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:135)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)
	at java.lang.Thread.run(Thread.java:745)

Danke im voraus.