problem with jdbc in jsp

**nishant.4545** · 08-17-2009, 08:45 AM

I have created a simple form using html as

Java Code:

<html>
<center>
<b>
Enter the data
</b>

<form action="Insert.jsp" method="get">

Name:  <input type="text" name="firstName">
    <input type="text" name="lastName"><br>
Sex:
    <input type="radio" checked name="sex" value="male">Male
    <input type="radio" name="sex" value="female">Female
<br>
<input type="submit">
</center>
</html>

Then I want to store this data in a database for which I have created a jsp as

Java Code:

<html>
<head>
<title>inserting to table</title>
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<%String firstName = request.getParameter("firstName");
    String lastName = request.getParameter("lastName");
    String sex = request.getParameter("sex");
    
   try{
		       	   
 	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   		
   	String database = 
              "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Data.mdb;";
              Connection conect= DriverManager.getConnection(database, "","");
   		
   		Statement stm=conect.createStatement();
   		
   		stm.execute("insert into Cinfo values('"+firstName+"','"+lastName+"','"+sex+"')");
        stm.close();
        conect.close();   		
   	
   	
   		
 	   }	catch(ClassNotFoundException cnf){
		out.println("Class not found error"+cnf);
		}catch(SQLException sqe){
   		out.println("SQL ERROR 2:"+sqe);
   		
   	    }


%>
</body>
</html>

I use tomcat to run jsp files. I have placed all the three files- Info.html, Insert.jsp and Data.mdb(database) in the folder-
C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ROOT
I access the html file from my browser by directing it to:
localhost:8080/Info.html

The html file is displayed perfectly well. But when I try to insert data in database by clicking on "submit" button, I get the following exception-

SQL ERROR 2:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

I guess it is because it is unable to find the database. But my database is there in the same folder.

Please help me.
Thanx in advance.

**RamyaSivakanth** · 08-17-2009, 10:40 AM

Hi,
Ur database connectivity information is wrong. Have u created the dsn name?.

Say if u create ur dsn for example as

"Test" then

u need to give like this below
Connection conect = DriverManager.getConnection("jdbc:odbc:Test");

**r035198x** · 08-24-2009, 11:15 AM

Then you also need to put all that database connection code in separate pure Java class. You should use JSPs for presentation only.

**serjant** · 08-29-2009, 01:31 PM

To make connection use these lines:

Java Code:

// Load the database driver
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;

      // Get a connection to the database Data.mdb
      Connection conn = DriverManager.getConnection( "jdbc:odbc:Data" ) ;