A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
Joined: Mar 16, 2004
Mar 19, 2007 12:04:00
Over the years I have had two projects that would enrypt/decrypt values for specific columns in a DBMS table from a
class. Once on oracle, and once on DB2. So I know it can be done.
I have just spent about 40 minutes searching the internet for an example of a java
class that uses DBMS_OBFUSCATION_TOOLKIT.DES3[en/de]crypt.
I recall call something about a prepareCall command but that is about it.
similar example of what trying to accomplish.
given a table called APP_USER that contains login id, password, social security number.
insert into APP_USER (u_id, login_id,password, ssn) values (GENERATED_PK,'mylogin', dbms_obfuscation_toolkit.DES3Encrypt (unenrypted_input_string => v_password, key_string => v_key), encrypt ssn);
select dbms_obfuscation_toolkit.DES3decrypt(input_string => app_user.password, key_string => key) from app_user where login = ?
Anyone know of URL references for what I am trying to do
CIAO Peter M. Cooke
Author and ninkuma
Joined: Jan 10, 2002
Mar 19, 2007 12:24:00
Please do not post the same question more than once.
Asking smart questions
Books by Bear
Have you checked out
subject: DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption
Urrgent Pls Advice as soon as possible
how to capture form varibales in JSP and form a html link?
Simple form-based authentication using JAAS
Middlegen and Hibernate
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015