I have created one Connection Pool for oracle database using thin driver. (Just for example,I am using DB user="SCOTT" and DBpassword="Tiger".
weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc

racle:thin:@myServer:1521

ata,\
driver=oracle.jdbc.driver.OracleDriver,\
initialCapacity=1,\
maxCapacity=2,\
capacityIncrement=1,\
props=user=SCOTT;password=TIGER
weblogic.jdbc.DataSource.oracleDataSource=oraclePool
In the context lookup i got the javax.sql.DataSource Object.
My Question is whether can i use the javax.sql.getConnection(
String user,String pwd)
method to get the connection Object.
i.e.
dataSourceObject= ctx.lookup("oracleDataSource");
Connection con= dataSourceObject.getConnection("SCOTT", "TIGER");
)
But it is throwing exception as method not implemented. Please help me to find out the solution so that i can hide the DB userid , DB password information in the weblogic.properties file and i can use it only in the runtime.
I am using weblogic 5.1 Application Server and oracle thin driver (classes12.zip).
Regards,
M.S.Raman.