• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

getting error in connection pooling

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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???
 
reply
    Bookmark Topic Watch Topic
  • New Topic