BatchUpdateException causes for a trigger 2003-12-09 - By Adrian Morales
Back
Hi all.
Can you help me.
I need to do a program to update, insert or delele information using
sybase and batch statement. The sybae's table has a trigger for insert
operation, when I try to insert a new row the trigger is laucher , this
cause that my program throws this BatchUpdateException:
Error causado por SQLException: JZ0BE: BatchUpdateException: Error
occurred while executing batch statement: JZ0P1: Unexpected result type.
if I try to insert a row without use batch statement, not throw the
BatchUpdateException. Any body has had the same problem, could you help
me ?
Thanks for your help.
the code for my jsp program example is :
try {
InitialContext env = new InitialContext();
ds = (DataSource) env.lookup("jdbc/Envios");
} catch(NamingException ne) {
out.println("No pudo obtener conexi�n a la base de datos: " +
ne + "<BR>");
}
//crea la conexion
cnx = Sql.getCnx(ds, 5000);
Statement stmt = cnx.createStatement();
try{
stmt.addBatch("INSERT INTO cdHistoria
VALUES('1234567880','MEX',getDate(),'1234567','MLOC','123',NULL,NULL,NULL)");
stmt.addBatch("INSERT INTO cdHistoria
VALUES('1234567881','MEX',getDate(),'1234567','MLOC','123',NULL,NULL,NULL)");
reg = stmt.executeBatch();
}catch(SQLException bue){%>
Error causado por SQLException: <%=bue.getMessage()%>
<%}
//Obtiene los datos enviados por la forma de consulta o
//men� principal
//IdGuia SiglasPlaza FechaEvento Ruta TipoMov ClaveEx NumOR
IdTransporte IdEmpleado
String SQL = "INSERT INTO cdHistoria
VALUES(?,'MEX',getDate(),'1234567','MLOC','123',NULL,NULL,NULL)";
try{
cnx.setAutoCommit(false);
PreparedStatement st = cnx.prepareStatement(SQL);
st.setString(1,"12345678910");
st.addBatch();
st.setString(1,"12345678911");
st.addBatch();
reg = st.executeBatch();
cnx.commit();
cnx.setAutoCommit(true);
st.close();
for (int i=0;1<reg.length;i++){ %>
Registros agregados: <%=i%>
<% }
}catch(BatchUpdateException sqle){
%>
Error causado por SQLException: <%=sqle.getMessage()%>
<%}catch(SQLException bue){%>
Error causado por SQLException: <%=bue.getMessage()%>
<%}%>
--
TSU Adri�n Morales Ruaro
Tecnolog�a Virtual S.A. de C.V.
www.tvirtual.com.mx
5 661 45 45
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
|
|
