my java code is
package pkgs;
import java.lang.*;
import java.sql.*;
public class MyConnection{
public static Statement getCon(int i){
Connection con=null;
Statement stmt=null;
try{
Class.forName("com.informix.jdbc.IfxDriver");
}
catch(Exception e){
System.out.println("Error 1");
System.out.println(e);
}
try{
if (i==0){
//connect with workflow db
con=DriverManager.getConnection
("jdbc:informix-sqli://192.101.11.05:2150/workflow:INFORMIXSERVER=msdp","user","password");
}
else{
//connect with hrms db
con=DriverManager.getConnection
("jdbc:informix-sqli://192.101.11.05:2150/hrms:INFORMIXSERVER=msdp","user","password");
}
stmt = con.createStatement();
}
catch(Exception e){
System.out.println("Error 2");
System.out.println(e);
}
return stmt;
}
public static int doInsert(Statement s, String ins)
{
int rval=0;
try{
s.executeUpdate(ins);
rval=0;
}
catch(Exception e){
rval=1;
}
return(rval);
}
}
jsp code is
MyConnection con = new MyConnection();
Statement stmt = con.getCon(1);
String qry="update hrm_employee_mas set emp_empname = '" +
request.getParameter("ename") + "'";
int rval = con.doInsert(stmt,qry);
it gives me Response has already been committed
===========================================================================
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://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
