BatchUpdateException causes for a trigger

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