Hi,
I'm using Jdeveloper 11.1.1.6.0, and wls 10.3.5.0.
I have developer a fusion web application. For this application, I need login functionality. I need to have the users and their roles stored in the database.
I have followed the example in this blog:
http://biemond.blogspot.ro/2008/12/using-database-tables-as-authentication.html
I have completed the steps until needed to create a new used in wls, where I receive this error message:
This is how the settings look like:
Also, this is how my user table looks like:
CREATE TABLE USER_INVENTAR
(
ID_USER NUMBER NOT NULL,
USER_NAME VARCHAR2(200 BYTE) NOT NULL,
EMAIL_USER VARCHAR2(50 BYTE) NOT NULL,
PASSWORD VARCHAR2(30 BYTE) NOT NULL
);
My email_user column is mandatory. Is it possible that the error when creating new user comes from here? that the email field is mandatory, but i don't provide any value for it?
If this is the case, what is the workaround? how and from where can i add other fields when creating users in wls.
Thank you!