Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: domain of ross_s_larner@homedepot.com
 designates 207.11.29.246 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: [DBCP] mysql authentication
Date: Tue, 14 Jun 2005 12:24:13 -0400
Message-ID: 
 <A4218492DD988B4883AFDFB7A945AB64064F3A43@CPWITA86.amer.homedepot.com>
Thread-Topic: [DBCP] mysql authentication
Thread-Index: AcVwP2T166eZqV0dRpuqs9nGigWSvAAvayog
From: "Larner, Ross S" <Ross_S_Larner@homedepot.com>
To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>

Hey Tom,
Forewarning - I have little knowledge of DBCP, so this may be breaking
the paradigm.

I don't know if you have access to the jdbc drivers for mysql, but if
so, you should be able to pass the password into the call to retrieve
the connection:

      Connection con =3D
                     DriverManager.getConnection(
                                 url,"root", "password");=20

Take a look at this article:
http://www.developer.com/java/data/article.php/3417381

Ross

-----Original Message-----
From: Tom Mathews [mailto:tom-mathews@supanet.com]=20
Sent: Monday, June 13, 2005 10:42 AM
To: Jakarta Commons Users List
Subject: Re: [DBCP] mysql authentication

-p certainly works on the command line, but do you have any hints as to
how to insert this programatically in a connection pool?
My code looks (alot!) like this (please note there may be typo's - the
machine I'm typing this from is isolated from my dev environment so I
can't just copy paste!) ...
try
{
String jdbcname =3D "jdbc/myApp";
String cmd =3D "SELECT * FROM client WHERE clientRef > 0"; Context ctx =
=3D
new InitialContext(); Context envCtx =3D
(Context)ctx.lookup("java:comp/env");
DataSource ds =3D (DataSource)envCtx.lookup(jdbcname);
Connection conn =3D ds.getConnection();
Statement stmt =3D conn.createStatement;
ResultSet rs =3D stmt.executeQuery(cmd);
ResultSetMetaData rsmd =3D rs.getMetaData(); ....
Thanks
Tom

Larner, Ross S wrote:

>Tom,
>If I remember correctly, the -p switch is used to supply the password.
>
>Ross
>
>-----Original Message-----
>From: Tom Mathews [mailto:tom-mathews@supanet.com]
>Sent: Monday, June 13, 2005 4:05 AM
>To: jakarta commons
>Subject: [DBCP] mysql authentication
>
>I'm trying to set up a connection pool to a mysql 5 db using JSP on=20
>Tomcat 5, versions as follows:
>
>mysql-connector-java-3.1.8
>jakarta-tomcat-5.0.28
>Mysql-devel-5.0.3
>Mandrake 10.1 on AMD64
>
>
>
>I've a resource set up which includes username and password elements#=20
>...
>   <!-- MySQL dB username and password for dB connections  -->
>    <parameter>
>     <name>username</name>
>     <value>myUser</value>
>    </parameter>
>    <parameter>
>     <name>password</name>
>     <value>myPassword</value>
>    </parameter>
>...
>but whenever I try and run the pages that use this, I get an error back

>saying 'Cannot create PoolableConnectionFactory (Access denied for user

>'myUser'@'me.mydomain.com' (using password: NO) '
>
>If I create a new database user with no password, then I can connect=20
>fine, but this is obviously not something that I want to do!
>
>Does anyone know how to make tomcat / mysql/J use a password (JSP=20
>rather than a stand alone java class, which is working absolutely
fine).
>
>Thanks
>Tom
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
> =20
>


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org