Skip to Content
0
Former Member
Aug 25, 2010 at 02:01 AM

Other options to connect to an oracle database

13 Views

Hi All,

We have a wd application connected to oracle database using JDBC:

Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@oracle server ip:port:sid", "user name", "password");

However, the user name and password to connect to the database were hard-coded. We wanted to remove this from the code. Thus, we need to find other way to connect to an oracle database.

We tried to create an oracle datasource in the VA. However, this is not an option anymore as the datasource was deleted during our system's upgrade. This could be an issue on going as we have to re-create it after each upgrade in the system.

Is there any other way to connect to oracle database without exposing the user name and password?