• 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
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

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???
 
Are you here to take over the surface world? Because this tiny ad will stop you!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic