You need to close the connection at the end of your method. I
suggest a "finally" block.
Aaron
On Thu, 14 Sep 2000, Oscar Radio wrote:
> 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]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
