File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Struts and the fly likes getting error in connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "getting error in connection pooling" Watch "getting error in connection pooling" New topic
Author

getting error in connection pooling

lubna kausar
Ranch Hand

Joined: May 06, 2006
Posts: 51
hi all,
i m trying to use connection pooling in my application. it is having connection to Postgres database whose name is "PEASS"
and i also have its driver installed.

my struts-config contains datasource as follows...
<data-sources>
<data-source key="faqPortal" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="org.postgresql.Driver" />
<set-property property="url" value="jdbc ostgresql://192.168.84.88:8080/PEASS" />
<set-property property="maxCount" value="10" />
<set-property property="minCount" value="1" />
<set-property property="user" value="postgres" />
<set-property property="password" value="shail123@12" />
</data-source>

</data-sources>


i dont know wat is the problem... i tried to rebuild all the jars and restart eclipse and all that things...
i checked the log and found the error as follows...

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection attempt failed.)



HTTP Status 503 - Servlet action is currently unavailable


type Status report

message Servlet action is currently unavailable

description The requested service (Servlet action is currently unavailable) is not currently available.


can anyone help me ragarding this???
thanx in advance...
Chris Montgomery
Ranch Hand

Joined: Jan 14, 2004
Posts: 141
at first glance, it appears your sql database and your applicaiton server are sharing the same port.

can you connect to the database using the db client while your application server is running at the same time?
lubna kausar
Ranch Hand

Joined: May 06, 2006
Posts: 51
hi there...
as u suggested i found my mistake and changed the port to suitable port and the restarted tomcat and tried afterwords but even after refresheing aal the things i get the same error
Cannot create JDBC driver of class '' for connect URL 'jdbc ostgresql://192.168.84.88:8080/PEASS', cause: No suitable driver

please NOTE that now i m using port 5432 and not 8080...
still it comes...
any solution???
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting error in connection pooling
 
Similar Threads
Data Source
HTTP Status 503 - Servlet action is currently unavailable
Struts, DBCP weird problem
Connect to MSSQL Server
How to connect a SQL Server database with struts