Hi,
You will have to load JDBC-ODBC bridge driver, with the following statement,
Class.forName("jdbc.odbc.JdbcOdbcDriver"); //loads the driver
before calling DriverManager.getConnection.Thanks, H.Ananthalakshmi.
From: Thomas Tsang <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Newbie question about jdbc:odbc connection Date: Thu, 2 Dec 2004 20:35:14 -0700
I am using apache + tomcat to do with my jsp project, and I do a jsp page with following codes: ======== <%@ page session="true" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.Date" %> <%@ page import="java.io.*" %> <%@ page import="java.net.*" %> <%@ page import="java.text.*" %> <% java.sql.Connection connBooking; java.sql.Statement sqlStmt;
connBooking = java.sql.DriverManager.getConnection ("jdbc:odbc:onlinebooking","username","password"); sqlStmt = connBooking.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_O NLY); %> ======= Then I create a ODBC source in System DNS with the name onlinebooking, this source is connect to a remote SQL server, I have tested the connection in ODBC interface and it can return ok. However the following error is returned when i load the above jsp page
========= javax.servlet.ServletException: No suitable driver org.apache.jasper.runtime.PageContextImpl.doHandlePageException (PageContextImpl.java:845) org.apache.jasper.runtime.PageContextImpl.handlePageException (PageContextImpl.java:778) org.apache.jsp.Booking.admin.Global_jsp._jspService (org.apache.jsp.Booking.admin.Global_jsp:138) 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 =========
I check the similar post here and someone suggest it is classpath problem. I find the following value is set in the apache tomcat property C:\Program Files\Apache Software Foundation\Tomcat 5.5\bin\bootstrap.jar;
Anyone have suggestion for my case? Thank in advance
=========================================================================== 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
_________________________________________________________________ Cool ringtones, snazzy logos! Funny cards, addictive games! http://www.msn.co.in/Mobile/ Get them all at one place!
=========================================================================== 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
