[jBoss-User] javax.transaction.xa.XAException

[Oscar Radio]

Hi all,

        I have this message error in JBOSS:

javax.transaction.xa.XAException
at java.lang.Throwable.<init>(Throwable.java:84)
at java.lang.Exception.<init>(Exception.java:35)
at javax.transaction.xa.XAException.<init>(XAException.java:61)
at org.jboss.minerva.xa.XAResourceImpl.commit(XAResourceImpl.java:85)
at org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:883)
at org.jboss.tm.TxCapsule.commit(TxCapsule.java:231)
at org.jboss.tm.TxManager.commit(TxManager.java:212)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:84)
at
org.jboss.ejb.plugins.TxInterceptor.runWithTransactions(TxInterceptor.java:2
49)
at org.jboss.ejb.plugins.TxInterceptor.invoke(TxInterceptor.java:96)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:156)
at
org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:
319)
at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:202)
at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:242)
at sun.rmi.transport.Transport$1.run(Transport.java:155)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:152)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:462)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:6
62)
at java.lang.Thread.run(Thread.java:498)

This happens when I call this method:

public Vector actualRegistro() 
  {
    Vector vector = null;
    
    try
    {
      //con = ds.getConnection("jerp", "jerp");
      con = ds.getConnection();
      
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery("select codigo, usuario,
nombre_usuario, situacion, codigo_personalizacion, passwd, gi_codigo,
gtu_codigo from gl_usuarios");
      
      try       
      {
        vector = new Vector();
        while (rs.next())
        {                    
          MapeoUsuario mapeoUsuario = new MapeoUsuario();
          mapeoUsuario.setCodigo(new Integer(rs.getInt("codigo")));
          mapeoUsuario.setUsuario(rs.getString("usuario"));
          mapeoUsuario.setNombreUsuario(rs.getString("nombre_usuario"));
          mapeoUsuario.setSituacion(rs.getString("situacion"));
 
mapeoUsuario.setCodigoPersonalizacion(rs.getInt("codigo_personalizacion"));
          mapeoUsuario.setPassword(rs.getString("passwd"));
          mapeoUsuario.setCodigoIdioma(rs.getString("gi_codigo"));
          mapeoUsuario.setCodigoTipoUsuario(rs.getInt("gtu_codigo"));
          
          Statement stTipoUsuario = con.createStatement();
          ResultSet rsTipoUsuario = stTipoUsuario.executeQuery("select
tipo_usuario from gl_tipo_usuarios where codigo = " +
mapeoUsuario.getCodigoTipoUsuario());
          while (rsTipoUsuario.next())
          {
 
mapeoUsuario.setTipoUsuario(rsTipoUsuario.getString("tipo_usuario"));
          }
          vector.add(mapeoUsuario);
          rsTipoUsuario.close();
          stTipoUsuario.close();
        }
      }
      finally
      {
        rs.close();
        st.close();
      }      
    }
    catch (SQLException e)    
    {
      e.printStackTrace();
    }         
    return (vector);    
  }

        And this is how I het the connection to the data base:

        jndiContext = new InitialContext();
            
      ds = (DataSource) jndiContext.lookup("JERP");

        This works fine before I use Minerva with oracle, when I use jdbc2.0
instead off Minerva with the Standard Extensions this works fine, so I think
that I have miss something in the connection that make the select give this
error.

Thanks, Oscar


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]