Good Morning Gaurav- It is truly Amazing how many managers who want to use Access DB in their production environments I would recommend a migration to true multi-threaded environment with a DB which has full Transaction support such as Oracle Take a look at http://www2.sys-con.com/itsg/virtualcd/Java/archives/0312/callahan/index.html specifically I would look at breaking single-tier to three tier architecture to decouple the application,business and DB to differing structures More immediate concerns would be migrating Type 1 (NonMultiUserAccess JDBCToOdbcBridge) to Type4 (True ThinCLient) JDBC driver
Please keep us apprised on your progress, Martin -- This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents ----- Original Message ----- From: "Caldarale, Charles R" <[EMAIL PROTECTED]> To: "Tomcat Users List" <users@tomcat.apache.org> Sent: Saturday, November 18, 2006 11:33 AM Subject: RE: Tomcat Performance Concerns > From: Gaurav Kushwaha [mailto:[EMAIL PROTECTED] > Subject: Tomcat Performance Concerns > > I have a simple JSP-application that makes use of an ODBC database > (access). Try using a real database with JDBC drivers. Access and ODBC are pretty much just toys and inappropriate for any kind of production environment. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]