BatchUpdateException causes for a trigger

[Adrian Morales]

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 [EMAIL 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