Hi, I use sybase as the database for my db.For establishing connections I use the Jakarta commons Dbcp.The database URL,username and password are stored in the jocl file like this:
<object class="org.apache.commons.dbcp.PoolableConnectionFactory" xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl"> <!-- The first argument to PoolableConnectionFactory is a ConnectionFactory. We'll use a DriverManagerConnectionFactory, passing in the appropriate connect string for the underlying driver. --> <object class="org.apache.commons.dbcp.DriverManagerConnectionFactory"> <string value="jdbc:sybase:Tds:172.20.65.181:3306/efind_uk01?jconnect_version=6"/> <string value="enh_find_update"/> <string value="m0zart"/> </object> .....
And I establish connection by: Connection conn = DriverManager.getConnection("jdbc:apache:commons bcp:/aolintlDevDriver");
Now i want to invoke a perl script from my servlet and pass the values of the databasename,username and password to the perl script. The problem is how to get the password in the servlet code so that I can pass it to the perl script. I can get the database name and the user name by geting the DatabaseMetaData object from the connection object.But the password is the one whose value I cannot access. Please tell me how i can do that?