tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrés Glez. <andres.gonza...@publicinet.net>
Subject Re: cannot setup JNDI with MySQL
Date Thu, 06 Oct 2005 10:45:50 GMT
The problem is not JDNI. The problem is you can't connect to MySQL. Probably 
it's you have to check your MySQL access permissions...

Can you connect to MySQL using the same parameters with another tool like 
MySQL Control Center?

----- Original Message ----- 
From: "John Cherouvim" <jc@eworx.gr>
To: <tomcat-user@jakarta.apache.org>
Sent: Thursday, October 06, 2005 11:17 AM
Subject: cannot setup JNDI with MySQL


> Hello
>
> I've been trying to setup a mysql connection pool using JNDI as shown in 
> http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
> But no luck.
>
> I never get to see the datasource registered Tomcat Administration Tool.
> I've included in server.xml the following lines somewhere inside the 
> <Host> .. </Host>
> <DefaultContext>
> <Resource name="jdbc/DBTest" auth="Container" 
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/DBTest">
>    <parameter> <name>factory</name> 
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
>    <parameter> <name>driverClassName</name> 
> <value>com.mysql.jdbc.Driver</value> </parameter>
>    <parameter> <name>url</name> 
> <value>jdbc:mysql://localhost:3306/dea?autoReconnect=true</value> 
> </parameter>
>    <parameter> <name>username</name> <value>myusername</value>

> </parameter>
>    <parameter> <name>password</name> <value>mypassword</value>

> </parameter>
>    <parameter> <name>maxActive</name> <value>20</value>
</parameter>
>    <parameter> <name>maxIdle</name> <value>10</value> </parameter>
>    <parameter> <name>maxWait</name> <value>40</value> </parameter>
> </ResourceParams>
> </DefaultContext>
>
> I have Tomcat/5.0.28
>
> And the following files in common\lib
> mysql-connector-java-3.1.10-bin.jar
> commons-collections-3.1.jar
> commons-dbcp-1.2.1.jar
> commons-pool-1.2.jar
> *
>
> *What I get in tomcat\logs\stdout.log is:
> NotifyUtil::java.net.ConnectException: Connection refused: connect
>    at java.net.PlainSocketImpl.socketConnect(Native Method)
>    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:295)
>    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:161)
>    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:148)
>    at java.net.Socket.connect(Socket.java:425)
>    at java.net.Socket.connect(Socket.java:375)
>    at sun.net.NetworkClient.doConnect(NetworkClient.java:139)
>    at sun.net.www.http.HttpClient.openServer(HttpClient.java:366)
>    at sun.net.www.http.HttpClient.openServer(HttpClient.java:582)
>    at sun.net.www.http.HttpClient.<init>(HttpClient.java:292)
>    at sun.net.www.http.HttpClient.<init>(HttpClient.java:253)
>    at sun.net.www.http.HttpClient.New(HttpClient.java:321)
>    at sun.net.www.http.HttpClient.New(HttpClient.java:306)
>    at sun.net.www.http.HttpClient.New(HttpClient.java:301)
>    at 
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:469)
>    at 
> sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:460)
>    at 
> sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:516)
>    at 
> org.netbeans.modules.web.monitor.server.NotifyUtil$RecordSender.run(NotifyUtil.java:237)
>
>
> What did I miss? I've even tried setting up the JNDI in the 
> conf\Catalina\localhost\myapp.xml
> And also tried <Context path="/myapp" docBase="app"> instead of 
> <DefaultContext>
> I also tried all that with the org.gjt.mm.mysql.Driver
>
> Regards,
> I.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 


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


Mime
View raw message