Users List
Subject: Re: SQLNestedException: Cannot create PoolableConnectionFactory
Is this the right forum for your question?
It looks like the db isn't running or isn't accessible.
If there's a Tomcat problem, please include exact OS, JVM and Tomcat version
numbers.
p
On 3
;
>maxWait="1"
>username="sa"
>password="sa"
> driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"
>
> url="jdbc:jtds:sqlserver://192.168.90.245:1433/iclose-messenger-
> br
ase suggest me here.
Exception details:org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create PoolableConnectionFactory (Network error IOException: Connection
timed out: connect)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
RayDon,
On 3/1/2010 12:46 PM, RayDon1 wrote:
> Caused by: org.postgresql.util.PSQLException: Connection refused.
Seems pretty straightforward.
> SERVER
> Active Internet connections (servers and established)
> Proto Recv-Q Send-Q Local Address
> From: RayDon1 [mailto:crdoi...@yahoo.com]
> Subject: RE: Cannot create PoolableConnectionFactory
>
>
>
> name="jdbcConnectionString"
> auth="Container"
> type="javax.sql.DataSource"
>
ser and password are valid and I have been able to connect to this same
database via CLI
--
View this message in context:
http://old.nabble.com/Cannot-create-PoolableConnectionFactory-tp27746714p27747350.html
Sent from the Tomcat - User mailing
> From: RayDon1 [mailto:crdoi...@yahoo.com]
> Subject: Cannot create PoolableConnectionFactory
>
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Connection refused. Check that the hostname
> and port are correct and that the postmaste
I am trying to connect a device (on the same network) to my server so that it
can access the PostgreSQL database. When it tries to connect I get this
error at catalina.out:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Connection refused. Check that the
eport:
>
> AbandonedObjectPool is used
> (org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool&b8f8eb)
> LogAbandoned: false
> RemoveAbandoned: true
> RemoveAbandonedTimeout: 120
> org.apache.tomcat.dbcp.dbcp.SQLNestedExce
p;b8f8eb)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 120
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Communications link failure
Last packet sent to the server was 0 ms ago.)
-
pper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:
rt
>>>
>>> message
>>>
>>> description The server encountered an internal error () that prevented
>>> it from fulfilling this request.
>>>
>>> exception
>>>
>>> org
etWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.Se
pServlet.java:329)
>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> root cause
>
> javax.servlet.ServletException: Unable to get connection, DataSource
> invalid: "org.apache.commons.dbcp.SQLNeste
a:802)
root cause
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Unexpected exception encountered during query.)"
org.apache.jasper.runtime.PageConte
Dear guys,
I apologize for the false alarm.
It was my mistake for not providing the correct database name.
Everything works ok !
Nevertheless, the configuration example could be used by those who
Have some trouble into getting these things to work.
Thanks again.
João Brägger
:
org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Database not found or no system
permission.)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource
.java:855)
Any insight ?
Thanks in advance.
João Brägger
Okay, using this blanket statement:
grant {
permission java.net.SocketPermission "localhost", "resolve";
permission java.net.SocketPermission "127.0.0.1:3306",
"connect,resolve";
};
The webapp works when tomcat is started normally. This is acceptable
while the machine is being used
I haven't gotten it working yet, but I think David may be on the right
track. Here's what I did:
I changed my file at '/etc/tomcat5/policy.d/03catalina.policy' to
properly point to my connector.jar and also changed the permissions to
include:
permission java.net.SocketPermission "localhost", "con
java.security.AccessControlException indicates you are running tomcat
with the security manager. You'll need to edit your catalina.policy
file to allow this connection. The policy file itself has a number of
examples, here's just one modified to your situation below:
grant codebase
"jar:fil
Cameron,
> For some reason tomcat can't connect to the database
> and create a
> connection pool, even though a normal client can
> connect just fine. I
> even wrote a small java program to connect using
> JDBC, in case that
> was the problem. I used the same parameters given to
> tomcat and again
Cameron,
> I've tried using the IP address instead, unfortunately that didn't work.
:(
> The entry in the hosts file is defined as you said.
:( :(
> For some reason tomcat can't connect to the database and create a
> connection pool, even though a normal client can connect just fine. I
> even wr
Thanks for the quick replies.
Martin:
No luck with your advice. I'm not sure there's a problem with mysql
permissions, as I can log in with a mysql client from the local
machine and access the database as normal. The original command used
to set the permissions was 'GRANT ALL ON DB.* TO 'User'@'%
Cameron,
You wrote:
> I have a newly installed and configured Ubuntu
> server running
> Tomcat5.5 and Mysql 5.0. This server was created in
> an attempt to
> migrate from a Red Hat server in a similar
> configuration, running the
> exact same webapp. Most of the
> configuration/classpath differen
Cameron,
> When our webapp trys to connect to the database on localhost, an exception
>
> 'java.security.AccessControlException: access denied
> (java.net.SocketPermission localhost resolve)'
In the past, the Connector/J JDBC client would often use
"localhost.localdomain" as the hostname, even t
or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: "Cameron Currie" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 19, 2006 2:23 PM
Subject: Database Connection Error Cannot create PoolableConnectionFactory
> Hello ev
pplets and attempts to connect to different hosts.
This case involves a webapp, connecting to localhost, using a
configuration that is known to work. I am simply baffled.
The following stacktrace is generated:
javax.servlet.ServletException: Database Connection Error
Cannot create PoolableConnect
27 matches
Mail list logo
