problem with servlets

I am unable to guess why you are creating Statement object as you are working with PreparedStatement. This one should work fine but i would like to advice you that for such data base access and insertion you should go for Java Beans.

You better create a DAO on the server you are working with either tomcat or weblogic etc. And use DAO object instead of hard coded database connection.

Or you may be working with the databse client sometimes that causes problem.

Rest of the stuff, I feel is absolutely fair and it should work without any issues.

sk.zubaira at 2007-7-16 13:29:21 >

Hi!

Thanks a lot....SHud i also privide servlet mapping in web.xml.....here is my code and web.xml.i hav placed DbInsert in classes folder under web-inf

<web-app>

<servlet>

<servlet-name>DbInsert</servlet-name>

<jsp-file>DbInsert</jsp-file>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>DbInsert</servlet-name>

<url-pattern>/DbInsert/*</url-pattern>

</servlet-mapping>

</web-app>

import java.io.*;

import java.util.Enumeration;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

import java.net.*;

public class DbInsert extends HttpServlet{

Connection theConnection;

private ServletConfig config;

public void init(ServletConfig config)

throws ServletException{

this.config=config;

try{

//Loading Sun's JDBC ODBC Driver

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

//Connect to emaildb Data source

theConnection = DriverManager.getConnection("jdbc:oracle:thin:@11.3.4.26:1521:TEST","TEST","guthrie");

String sql = "INSERT INTO temp VALUES (?)";

PreparedStatement pstmt = theConnection.prepareStatement(sql);

pstmt.setString(1 , "TEST");

pstmt.executeUpdate();

theConnection.commit();

pstmt.close();//Close the result set

theConnection.close(); //Close database Connection

}catch(Exception e){

System.out.println(e);

}

}

public void service (HttpServletRequest req, HttpServletResponse res)

throws ServletException, IOException {

HttpSession session = req.getSession(true);

res.setContentType("text/html");

PrintWriter out = res.getWriter();

}

public void destroy(){

}

}

anu idea on what im doin wrong...the data doesnt get inderted on starting the webserver :-( mean while ill check if there is log....i hav a error log in admin page....but it doesnt print out any messages....pertaining to this....

Thanks

Vivek

vivek.shankara at 2007-7-16 13:29:21 >

The class should be packaged.

package myPackage;

public class DbInsert{

...........

}

the .class file should be in the following path

WEB-INF/classes/myPackage/DBInsert.class

and your web.xml should have

<servlet-class>myPackage.DbInsert<servlet-class>

ram.

Madathil_Prasada at 2007-7-16 13:29:21 >

Hi,

I did out.println and i got the following message :

java.sql.SQLException: No suitable driver

how shud i rectify it...i guess i hav set the classpath and i can rub a standalone application to insert data.....shud i place any jar file inside the webserver....if so where shud i place it?

THANKS A LOT FOR ALL YOUR HELP :-)

Regards

Vivek

vivek.shankara at 2007-7-16 13:29:21 >

HI,

I have plaed classes12.jar in lib folder. But when I tried to connect to database using it as stand alone application , i used ojdbc14.jar....also which i hav placed it in lib directory.But still i am facing the problem......Any help would be of great use ....thanks a o lot!!!

Regards

Vivek

vivek.shankara at 2007-7-16 13:29:21 >