• 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
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

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???
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!