Re: Pooling Issue

Sun, 19 Nov 2006 15:19:05 -0800

Good catch and one I thought of earlier. Unfortunately that would generate a java.security.AccessControlException, not a java.net.ConnectionException.
The OPs exception comes from a failure to connection to the port mysql is supposed to be listening on. 

--David

Martin Gainty wrote:

Sorry for jumping in late in the thread but I assume you covered the basics as 
in granting your Socket the ability to connect as in 
$CATALINA_HOME/conf/catalina.policy
grant
{
 permission java.net.SocketPermission "NameOfDBGoesHere:PortNumberGoesHere", 
"accept,connect,listen,resolve";
}
?
Martin--

This e-mail communication and any attachments may contain confidential and privileged information for the use of the 
designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received
this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its 
contents
----- Original Message ----- 
From: "tyju tiui" <[EMAIL PROTECTED]>

To: "Tomcat Users List" <users@tomcat.apache.org>
Sent: Saturday, November 18, 2006 10:32 PM
Subject: Re: Pooling Issue


I do have a firewall, but I tried opening port 3306 and still had the same 
problem.
I don't know what could be impeding the connection since I'm able to connect to 
mysql from the server.
Is there any other way for me to test the connection using from tomcat? Maybe 
an interactive logon or something?

The root cause is:

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 


java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at 
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at 
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at 
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at 
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
at 
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at 
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown
 Source)
at 
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown 
Source)
at org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:100)
at org.apache.jsp.test_jsp._jspService(test_jsp.java:58)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 21 ms ago.)"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown
 Source)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown 
Source)
org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:100)
org.apache.jsp.test_jsp._jspService(test_jsp.java:58)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

----- Original Message ----
From: David Smith <[EMAIL PROTECTED]>
To: Tomcat Users List <users@tomcat.apache.org>
Sent: Saturday, November 18, 2006 9:28:46 PM
Subject: Re: Pooling Issue


Well that's a stumper.  The connection refused exception implies that 
nothing is listening on that port or the port is blocked by a firewall.  
Is there any more to that exception like a root cause?  Given you are 
using the localhost interface, I doubt this has a bearing but would you 
happen to have any iptables or other firewall software active?  In short 
is there anything in your system that might prevent the connection?


--David

tyju tiui wrote:

  

Hi David,

Thank you so much for the response and good advice.
I verified that I was able to connect to MySQL using
the command you suggested (via port 3306). I also
removed the autoReconnect parameter and moved the
pooling config out to Catalina/localhost/DBTest.xml. I
restarted tomcat and I'm still having the same issue.

Do you have any other ideas?

Thanks again,

Ty



--- David Smith <[EMAIL PROTECTED]> wrote:


  
    

For starters, you might want to make a copy of your

server.xml file for 
documentation purposes and then drop all the
comments from the active 
one.  The documentation comments are excellent, but
they make the 
serverl.xml near impossible to read.


At any rate.... the exception is connection refused.

 Are you sure your 
MySQL server is listening on port 3306?  Some
default configurations use 
unix sockets exclusively -- something java JDBC
drivers can't do.  Try 
this from the same machine your server is on:


mysql -h localhost -P 3306 -u rpd -p

The above command forces mysql client to connect via

TCP/IP with userid 
rpd and prompt for a password.  If this works, then
we're looking at 
something else.  If this doesn't, reconfigure your
mysql server to 
listen on tcp/ip port 3306 and try again.
 
Some additional recommendations -- not directly
related to your issue, 
but worth mentioning:


The <Context ...> ... </Context> block should be in

it's own xml file 
under conf/Catalina/localhost, named to match the
context of your webapp 
-- DBTest.xml in your case.  Avoid setting this in
server.xml as it 
requires restarting the tomcat container every time
you want to make a 
change to your webapp's config.



Drop the autoReconnect=true from your database url. 
It isn't 
recommended by MySQL and doesn't make sense in a
database connection 
pool anyway.


--David

tyju tiui wrote:

    
      

I'm having problems setting up connection pooling

      
        

with

    
      

comcat 5.5.2.0 and MySQL 5.0.24 using mysql
connector/J 5.0.

I've setup / populated a test database and

      
        

verified

    
      

that I can login to the server/db using the

      
        

specified

    
      

username/password/host found in the connection

      
        

string.

    
      

My server.xml looks like this:


  
      
        

  <snipped here .... a lot of irrelevant stuff to
the issue at hand. />

    
      

        <!-- ********** Pooling Config **********

      
        

-->

    
      

        <Context path="/DBTest" docBase="DBTest"
                 debug="5" reloadable="true"
crossContext="true">



  
      
        

< snipped again...../>

    
      

            <Resource name="jdbc/TestDB"
                      auth="Container"
                      type="javax.sql.DataSource"

                     

      
        

factory="org.apache.commons.dbcp.BasicDataSourceFactory"

  
    

                      maxActive="100"
                      username="rpd"
                      password="2wERk4rpd"
                      maxIdle="30"
                      maxWait="10000"

                     
driverClassName="com.mysql.jdbc.Driver"

                      removeAbandoned="true"

                     

      
        

url="jdbc:mysql://localhost:3306/phptest?autoReconnect=true"

  
    

                      />

        </Context>
        <!-- ********** End Pooling ********** -->

      </Host>

    </Engine>

  </Service>

</Server>







I'm using the sample web.xml and test.jsp found

      
        

at:

    
      

http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html

  
    



There error I'm getting is:

org.apache.jasper.JasperException: Unable to get
connection, DataSource invalid:
"org.apache.commons.dbcp.SQLNestedException:

      
        

Cannot

    
      

create PoolableConnectionFactory (Server

      
        

connection

    
      

failure during transaction. Due to underlying
exception: 'java.net.SocketException:
java.net.ConnectException: Connection refused'.


** BEGIN NESTED EXCEPTION ** 


java.net.SocketException
MESSAGE: java.net.ConnectException: Connection

      
        

refused

    
      

STACKTRACE:

java.net.SocketException:

      
        

java.net.ConnectException:

    
      

Connection refused
    at


      
        

com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

  
    

    at

      
        

com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

    
      

    at


      
        

com.mysql.jdbc.Connection.createNewIO(Connection.java:2815)

  
    

    at


      
        

com.mysql.jdbc.Connection.<init>(Connection.java:1531)

  
    

    at


      
        

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

  
    

    at


      
        

org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

  
    

    at


      
        

org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

  
    

    at


      
        

org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

  
    

    at


      
        

org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

  
    

    at


      
        

org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

  
    

    at


      
        

org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown

  
    

Source)
    at


      
        

org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown

  
    

Source)
    at


      
        

org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:100)

  
    

    at


      
        

org.apache.jsp.test_jsp._jspService(test_jsp.java:58)

  
    

    at


      
        

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

  
    

    at


      
        

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

  
    

    at


      
        

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)

  
    

    at


      
        

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

  
    

    at


      
        

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

  
=== message truncated ===





 
____________________________________________________________________________________

Sponsored Link


$420k for $1,399/mo. 
Think You Pay Too Much For Your Mortgage? 
Find Out! www.LowerMyBills.com/lre


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  
    



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]









 
____________________________________________________________________________________

Sponsored Link


Mortgage rates near 39yr lows. 
$420k for $1,399/mo. Calculate new payment! 
www.LowerMyBills.com/lre



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]















    











					Reply via email to