sun.jdbc.odbc.JdbcOdbcDriver worked a minute ago

**edwardtisdale** · March 2nd, 2011 12:59 PM

After adding in a few lines of code I got this error:
javax.servlet.ServletException: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

I am using MySQL on Ubuntu 10.10.
What am I missing?

Code:

<!-- simple email login page -->

<?xml version="1.0"?>

<!DOCTYPE html PUBLIC "-//W3C//DTD Xhtml 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>



</head>

<!-- use sql query to store password  -->
<%@ page import="java.sql.*" %>






<body bgcolor="beige">





<table>

<dd><font size="4">EMAIL</font></dd>







<!-- form: when submitted information is sent to Logged-in page -->

<form action="http://192.168.1.100:8081//LoggedinToEmail.jsp" method="get" name="EmailtoJSP">

<tr>

<td>Username:</td>



<!-- user enters data -->

<td><input type="text" name="userName" width="20" size="20" maxlength="50"></td>

</tr>

<tr>

<td>Password:</td>

<td><input type="password" name="password" width="20" size="20" maxlength="50"></td>

</tr>



<!-- user submits -->

<tr>

<td><input type="submit" value="Log In"></td>

</tr>

</table>

<% 

String UnameToDatabase=request.getParameter("userName");

String PwordToDatabase=request.getParameter("password");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:DSN"); // connects to database named 'Authenticate'

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sqlstatement = "INSERT INTO passwords (username, password) VALUES (UnameToDatabase, PwordToDatabase)";

con.close();

%>



<br>Need To <a href="http://192.168.1.100:8080/RegisterForEmail.jsp">Register?</a><br>

<br><a href="http://192.168.1.100:8081//SendClientPassword.jsp">Trouble</a> Logging In?<br>



</body>

</html>

**Xeel** · March 2nd, 2011 07:35 PM

Your application can't find driver JAR. Make sure it goes inside the WAR or that your application server has it in its shared libs.

Thread: sun.jdbc.odbc.JdbcOdbcDriver worked a minute ago

Thread Tools

Display

sun.jdbc.odbc.JdbcOdbcDriver worked a minute ago

Re: sun.jdbc.odbc.JdbcOdbcDriver worked a minute ago

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions