Is possible to make a jsp script work with oracle wallet?
Have a jsp script that connects to oracle database. Since I wants to hide the username/password to oracle schema, I would like to use oracle wallet to achieve it. Is it possible? Can any guru shed some lights on how to do that or point to a link? The connection portion using wallet is critical for me. (Oracle database version v11.2)
If it is not possible, is there any way to hide the username/password somewhere?
If it is not possible, is there any way to hide the username/password somewhere?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the tip.
For a plain java program, this is no problem. I already worked out. However if you put in jsp script running on Tomcat, that always complains the wrong password no matter hard hard I tried. I am really interested in the link or example for jsp script with wallet.
Can any guru find it or show some more tips for me?
For a plain java program, this is no problem. I already worked out. However if you put in jsp script running on Tomcat, that always complains the wrong password no matter hard hard I tried. I am really interested in the link or example for jsp script with wallet.
Can any guru find it or show some more tips for me?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
johnsone, Thanks a lot for your tips again. I tried it. It says the wrong username/password, and tried other similar things, not been successful yet. I am wondering that usually Tomcat is installed and owned by one user (U1), but the wallet owner is different. Usually it is a normal oracle database user (U2). Without any wallet password involvement, how can U1 get known the info in wallet via jsp page? Do you have a test env? Maybe I am asking too much.
Recently I read something on jndi, can I use it instead of wallet? The purpose is that in jsp page, there should not be a schema password there? Maybe I need to open another ticket for it after this one.
Recently I read something on jndi, can I use it instead of wallet? The purpose is that in jsp page, there should not be a schema password there? Maybe I need to open another ticket for it after this one.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your tips.
ASKER