Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

getting error in connection pooling

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
Ranch Hand
Posts: 141
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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???
 
Can't .... do .... plaid .... So I did this tiny ad instead:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic