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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]