This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes DB connection in webapplication. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB connection in webapplication." Watch "DB connection in webapplication." New topic
Author

DB connection in webapplication.

raju sangam
Ranch Hand

Joined: Jun 19, 2007
Posts: 38
Hi All,
I am working on webapplication which is developed using Servlets,jsp and some simple java classes.
This application needs to interact with multiple databases ( few databases from another server machine), and all JDBC stuff done in one java class and that class is using accessed in servlets.
Though its working well but it takes lot of time to run from page to page.

please give feasable solution to improve the performance.
(Alternate way to access the database)

Thanks,
Sangam
Eric Pascarello
author
Rancher

Joined: Nov 08, 2001
Posts: 15376
    
    6
Um, write better SQL? If it is taking a long time look at where the bottle necks are. Look at whta you are doing to help the user and see if you really need to display all of that data or if there is another way to do it.

Eric
Eric Pascarello
author
Rancher

Joined: Nov 08, 2001
Posts: 15376
    
    6
Moving to JDBC.

Eric
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB connection in webapplication.