this is what I have in mine
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
>From: Sharon Om <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: JDBC connection
>Date: Fri, 11 May 2001 13:23:25 -0700
>
>Hello. I have the following code for connecting to the jdbc:odbc pool.
>While compiling the Java code, I keep getting an "ClassNotFoundException"
>in
>Class.forName.
>I also tried declaring Class T and have T.forName. I get the similar error
>for "T.forName". How can I get this to work?
>
>Thank you for your help.
>Sharon
>====================
>package property;
>
>
>import java.sql.*;
>import java.io.Serializable;
>
>public class database implements java.io.Serializable
>{
>
> public database() {
>
> }
>
>public String runSql()
>{
> String browserOutput = "";
> Connection sqlca = null;
> Statement sqlStatement = null;
> ResultSet myResultSet=null;
>
>
> /*Connect to database, run SQL and produce output */
>
> try {
> /* Connection to the database */
> Class.forName("sun.jdbc.odbc.JdbcOdbcDrive");
> String theDatabase = "jdbc:odbc:loadtool";
> sqlca =
>DriverManager.getConnection(theDatabase,"loadtool","loadtool");
> }
> catch (SQLException e) {
>
> browserOutput = "Error:SQL error of: "+e.getMessage();
> }
>
> return browserOutput;
>}
>
>}
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
