tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Cherouvim ...@eworx.gr>
Subject cannot setup JNDI with MySQL
Date Thu, 06 Oct 2005 09:17:45 GMT
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


Mime
View raw message