Calling Oracle's Cryptit.encrypt()/Cryptit.decrypt() from Java?
Posted on 2005-05-07
Is there a way to call Oracle's Cryptit.encrypt()/Cryptit.decrypt() from Java?
I need to do something like
Insert into x values(a,b,c,Cryptit.encrypt(passwd,'key');
But my problem is that I don't get to create the query myself.
I only get to pass a String vector to this Java method which would create and run the query based the String query using preparedStatement and setString()
So, I figured if there is a way to call that Cryptit.encrypt() function in Java, I could just pass the resulting encryped String to the method...
Also, is there a way to run a Oracle function on ResultSet in Java?
Because I need to retrieve the encrypted password and then decrypt it before use... and again, I don't get to create the query such as "select Cryptit.decrypt(passwd, 'key')...", I only get the ResultSet