Problem in connecting to Access Database.
Hi,
I am new to this Java/JSP Concepts. I am using IBM Websphere Studio(Application Developer 5.1.2). I am facing a problem to connect to the Access database. I have written a java file to connect to the Access Database. When i compile my java code and run it. It was working fine and i am able to insert into the Access database.The java file is working fine without errors. But when i create an object in the jsp and called the methods through that object i am getting "java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver", "java.sql.SQLException: No suitable driver", "java.lang.NullPointerExceptionexceptions" exceptions.
Please help me in solving the problem.
My Java code is :
package myPack;
import javax.sql.*;
import java.sql.*;
import java.io.*;
import java.util.*;
public class DB_Connect {
private Connection con;
private Driver driver;
//private String connectStr ="jdbc:odbc:MS Access Database;DBQ=C:\\Movie_Club.mdb";
public void initialiseDrivers(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("driver found");
}
catch (ClassNotFoundException e){
e.printStackTrace();
System.out.println("driver not found");
}
try{
con = DriverManager.getConnection("jdbc:odbc:MS Access Database;DBQ=C:\\Movie_Club.mdb","","");
System.out.println("database found");
//"jdbc:odbc:MS Access Database;DBQ=C:\\156761\\Movie_Club.mdb");
//"jdbc:odbc:MC","",""); I have tried with both of them they are working.
}
catch (SQLException ce){
ce.printStackTrace();
System.out.println("database not found");
}
}
public int insertDB(String empno, String empname, String action, String adventure, String animation, String comedy, String horror, String romantic, String thriller, String sci_fic) throws SQLException {
int i=0;
Statement stmt = null;
try {
if(!con.equals(null))
{
stmt = con.createStatement();
i = stmt.executeUpdate("insert into Movie_Flavour values("+empno+","+empname+","+action+","+adventure+","+animation+","+comedy+","+horror+","+romantic+","+thriller+","+sci_fic+")");
stmt.close();
con.close();
}
else
System.out.println("con not made");
}
catch (java.sql.SQLException exception) {
exception.printStackTrace();
}
return i;
}
public ResultSet getDetails(){
Statement stmt = null;
ResultSet rs = null;
try{
stmt = con.createStatement();
rs = stmt.executeQuery("select * from Movie_Flavour where empno = 1");
}
catch(Exception e){
e.printStackTrace();
}
return rs;
}
public static void main(String[] args) {
int i=0;
DB_Connect db = new DB_Connect();
try{
db.initialiseDrivers();
i = db.insertDB("1","2","3","4","5","6","7","8","9","10");
System.out.println(i);
}
catch(Exception e){
e.printStackTrace();
}
}
}
and my JSP code is:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" %>
<%@ page import="myPack.DB_Connect" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.sql.*" %>
<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="IBM WebSphere Studio">
<TITLE>User_Input</TITLE>
</HEAD>
<BODY>
<%
DB_Connect db = new DB_Connect();
try
{
db.initialiseDrivers();
db.insertDB("1","1","1","1","1","1","1","1","1","1");
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</BODY>
</HTML>
Websphere shows the following messages in the console.
[3/1/06 16:35:27:986 IST] 57687dab WebGroupI SRVE0180I: [RTSC_MCWeb] [/RTSC_MCWeb] [Servlet.LOG]: /User_Input.jsp: init
[3/1/06 16:35:28:002 IST] 57687dab SystemErrR java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
[3/1/06 16:35:28:002 IST] 57687dab SystemErrR at com.ibm.ws.classloader.CompoundClassLoader.findClass(CompoundClassLoader.java:390)
[3/1/06 16:35:28:002 IST] 57687dab SystemErrR at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:300)
[3/1/06 16:35:28:002 IST] 57687dab SystemErrR at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
[3/1/06 16:35:28:002 IST] 57687dab SystemErrR at java.lang.Class.forName1(Native Method)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at java.lang.Class.forName(Class.java(Compiled Code))
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at myPack.DB_Connect.initialiseDrivers(DB_Connect.java:28)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at org.apache.jsp._User_5F_Input._jspService(_User_5F_Input.java:126)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:344)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:669)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:767)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[3/1/06 16:35:28:049 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[3/1/06 16:35:28:064 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)[3/1/06 16:35:28:111 IST] 57687dab SystemOutO driver not found
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR java.sql.SQLException: No suitable driver
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at java.sql.DriverManager.getConnection(DriverManager.java:558)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at java.sql.DriverManager.getConnection(DriverManager.java:188)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at myPack.DB_Connect.initialiseDrivers(DB_Connect.java:38)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at org.apache.jsp._User_5F_Input._jspService(_User_5F_Input.java:126)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:344)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:669)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:767)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[3/1/06 16:35:28:111 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[3/1/06 16:35:28:127 IST] 57687dab SystemErrR at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
[3/1/06 16:35:28:127 IST] 57687dab SystemOutO database not found
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR java.lang.NullPointerException
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at myPack.DB_Connect.insertDB(DB_Connect.java:54)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at org.apache.jsp._User_5F_Input._jspService(_User_5F_Input.java:127)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:344)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:669)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:767)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
[3/1/06 16:35:28:143 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[3/1/06 16:35:28:158 IST] 57687dab SystemErrR at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
