To quote a fellow from the J2EE List Using MS Access with CMP enterprise beans is like putting a moped engine in a Mercedes-Benz.
At one time I worked for a company that was using the Jdbc-Odbc bridge for connecting to SQL Server DB. This was fine for 20 records. We experienced serious performance issues when 5000 records needed to be displayed with joins on 3 different tables using a single non-pooled Jdbc thin driver implementation.
Yes you can design your own Connection Pool (info available at) http://www.devx.com/Java/Article/20891/0/page/2 Provided you would be willing to manage the thread initiation life and starvation at your end Not a pleasant task as you would be essentially managing a number of different thin client hard connects..with each connection being the most difficult and expensive way to connect to the DB
If you want speed and performance you will probably want to start thinking about Transaction Management and for Transactions I would strongly suggest Third Party tools Take a look at http://www.bcs-corp.com/java/aveconnect/aveconnect25.html and download the eval and see is this works for you,
Please keep me apprised,
Martin Gainty
(cell) 617-852-7822
From: Darshan Kashi <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Newbie question about jdbc:odbc connection Date: Fri, 3 Dec 2004 04:51:36 -0700 Received: from mc12-f13.hotmail.com ([65.54.167.149]) by mc12-s10.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Fri, 3 Dec 2004 04:05:12 -0800 Received: from swjscmail2.java.sun.com ([192.18.99.108]) by mc12-f13.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 3 Dec 2004 04:04:43 -0800 Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by swjscmail2.java.sun.com (Postfix) with ESMTPid AF99D226CB; Fri, 3 Dec 2004 04:57:08 -0700 (MST) Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8e) with spool id 48106262 for [EMAIL PROTECTED]; Fri, 3 Dec 2004 04:51:52 -0700 Received: from swjscmail2.java.sun.com (swjscmail2.Sun.COM [192.18.99.108]) by swjscmail1.java.sun.com (Postfix) with ESMTP id 2BBFD49AB for <[EMAIL PROTECTED]>; Fri, 3 Dec 2004 04:51:52 -0700 (MST) Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107]) by swjscmail2.java.sun.com (Postfix) with ESMTP id 7D2122139B for <[EMAIL PROTECTED]>; Fri, 3 Dec 2004 04:56:45 -0700 (MST) X-Message-Info: WCnvqBl1Q3iLE2NqPDoQVBaKtZKDi7g1OmD6TzHaYYo= X-Original-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Precedence: list Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 03 Dec 2004 12:04:43.0973 (UTC) FILETIME=[469F7750:01C4D930]
Hi ,
It should be Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Regards Darshan
On Fri, 3 Dec 2004 03:11:08 -0700, Thomas Tsang <[EMAIL PROTECTED]> wrote:
>Thank for your information. > >However, the following error is display after the line Class.forName >("jdbc.odbc.JdbcOdbcDriver"); is add before the line connBooking = ... >============= >javax.servlet.ServletException: jdbc.odbc.JdbcOdbcDriver > org.apache.jasper.runtime.PageContextImpl.doHandlePageException >(PageContextImpl.java:845) > org.apache.jasper.runtime.PageContextImpl.handlePageException >(PageContextImpl.java:778) > org.apache.jsp.Booking.Global_jsp._jspService >(org.apache.jsp.Booking.Global_jsp:139) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service >(JspServletWrapper.java:325) > org.apache.jasper.servlet.JspServlet.serviceJspFile >(JspServlet.java:295) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) >============= >Do I miss any setting in the tomcat? > > ========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP- INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > >Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com
=========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
=========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
