Hi
Thank you for reading my post
i have problem with tomcat JDBC realm
I defined a jdbc realm in server.xml also i configured my application to
use Realms
but it never login into system ,it always send me to login_error page
instead of logging in to the syste.
I should say that when i creaete my own realm in server.xml ,i can not
login into admin console anymore.
are these two relevant ?
should i comment or uncomment more stuff in server.xml ?
how an application knows which realm it should use ?
another question that i have is about users / users_role / roles tables
should i create all these tables ?my users allways has one role , so i
create one table and
it contains also role column , i mapped these in server.xml .
can it be a problem for tomcat ? is it manedatory to use 3 tables ?
I attached my web.xml section that is related to security and also
server.xml section that is related to security and realms
I should say that i double check JDBC driver to be in place , double
check connection url ...
thank you very much.
---web.xml begin-
all
*.jsp
manager
user
NONE
FORM
/login.html
/login_error.html
manager
user
--server.xml---
---Database table structure---
CREATE TABLE "HR"."USERS"
("NAME" VARCHAR2(32 CHAR),
"USER_ID" NUMBER,
"LASTNAME" VARCHAR2(32 CHAR),
"USERNAME" VARCHAR2(32 CHAR),
"PASSWORD" VARCHAR2(32 CHAR),
"ROLE_NAME" VARCHAR2(128 CHAR),
CONSTRAINT "USERS_PK" PRIMARY KEY ("USER_ID") ENABLE
) ;
-
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]