• 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

QN about connetion pool usage in JSP

 
Ranch Hand
Posts: 1934
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We need to incorporate a connection pool usage(for JDBC stuff) on the frontend. This is more of a refactoring to avoid using third party conneciton pool pooling that is used for sometime, on this project.

Since this is refactoring(there is no time to move db access to backend) any suggestions regarding best practise for frontend connection pooling is appreciated.(We are aware of changing from model-1 to MVC, but for this project there is no time for it. We just need to remove prior connectionpool setup and use a generic one)
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Kishore,
What application server are you using? You can use DataSource instead of DriverManager and let the app server do the work.
 
Kishore Dandu
Ranch Hand
Posts: 1934
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Using Weblogic.

Can u give some insights on it.
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think it is the time to switch to Weblogic Forum.
 
drifter
Posts: 1364
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Kishore,

Please provide more details. Are you trying to get away from using weblogic-specific features or some other third party? What version of weblogic are you using?

Check the BEA documentation on JDBC Programming.
 
Kishore Dandu
Ranch Hand
Posts: 1934
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We are presently moving from WL6.1 to 8.1.

Weblogic does suggest to use DataSource compared to connection pools when it comes to JDBC from front-end. But the reason for this choice is not clear.

Can some one put their insights into it?
 
reply
    Bookmark Topic Watch Topic
  • New Topic