Hi all!,
I don't know if my problem must be sent the list, I apologize in advance,
but I think that maybe there some problem in my configuration of Apache
Tomee, and maybe you could give some help.
Recently I added Jdbc Realm to application and this work but when I try to
execute some jpa query I obtain nothing.
I Believe that all in the connection is ok, I put all in the file
context.xml of application:
<?xml version="1.0" encoding="UTF-8"?>
<Context path="">
<Resource name="jdbc/Corral"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/CoopCorralitoWeb"
username="myuser"
password="mypassword"
maxTotal="20" maxIdle="10" maxWaitMillis="-1"/>
<Realm className="org.apache.catalina.realm.JDBCRealm"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost:5432/CoopCorral"
connectionName="myuser" connectionPassword="mypassword"
userTable="cliente" userNameCol="username"
userCredCol="password"
userRoleTable="clienterol" roleNameCol="rol">
<CredentialHandler
className="org.apache.catalina.realm.MessageDigestCredentialHandler"
algorithm="SHA-256" />
</Realm>
</Context>
Also I enabled logs of Apache Tomee to see was happening:
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate
Authenticating username '01652'
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
sun.reflect.DelegatingMethodAccessorImpl.invoke Intentando autentica al
usuario [01652] con el reino [org.apache.catalina.realm.JDBCRealm]
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
sun.reflect.DelegatingMethodAccessorImpl.invoke Usuario autenticado [01652]
con reino [org.apache.catalina.realm.JDBCRealm]
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate
Authentication of '01652' was successful
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.AuthenticatorBase.register Authenticated
'01652' with type 'FORM'
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.AuthenticatorBase.changeSessionID Session
ID changed on authentication from [C5A2BDB72274F71B59C2DDF4C2362B68] to
[3F66ED486C51317146EEF8B63CBB3DEB]
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate
Redirecting to original '/'
19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Failed
authenticate() test
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Security
checking request GET /
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke We have cached
auth type FORM for principal GenericPrincipal[01652(usuario,)]
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling
hasUserDataPermission()
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling
authenticate()
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate Restore
request from session '3F66ED486C51317146EEF8B63CBB3DEB'
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate Proceed
to restored request
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling
accessControl()
19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17]
org.apache.catalina.authenticator.AuthenticatorBase.invoke Successfully
passed all security constraints
But, when I execute to some queries these not returning values and neither
any error :
[EL Fine]: 2024-07-19
11:34:02.788--ServerSession(23048368)--Connection(142695858)--Thread(Thread[http-nio-8080-exec-17,5,main])--SELECT
ID, ADMIN, CUIT, DOMICILIO, LOCALIDAD, MAIL, NOMBRE, PASSWORD, TELEFONO,
USERNAME FROM cliente
Of course Table has values and user and password of connection are correct.
Any Idea where I can found the problem?
Regards!
