my dog learned polymorphism*
The moose likes JDBC and the fly likes Problem with jakarta commons dbcp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with jakarta commons dbcp" Watch "Problem with jakarta commons dbcp" New topic
Author

Problem with jakarta commons dbcp

Sunetra Sen
Ranch Hand

Joined: Feb 17, 2005
Posts: 43
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?

Thanks in advance,
Sunetra.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

Sunetra,
You can read in the XML file and use a parser to get the password.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
Or another suggestion is to define all of these as name/value paramenters in the application's web.xml i.e.

 
jQuery in Action, 2nd edition
 
subject: Problem with jakarta commons dbcp
 
Similar Threads
my servlet can't initialize: null
Has anyone used the JAKARTA DBCP with JOCL?
Problem with the ajax app
datasource using tomcat in spring
how to make a method in database access class for login