aspose file tools*
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB connection in webapplication.