From: Dovan N. <dn...@xs...> - 2001-05-15 22:55:28
|
> > 2) *** CONNECTION CREATION > > InitialContext jndiContext = new InitialContext(); > > XAPoolDataSource ds = (XAPoolDataSource) > > jndiContext.lookup("java:/OracleDS"); > > Connection conn = ds.getConnection(); > > Don't reference Minerva classes in your code. Just use javax.sql.DataSource. If you don't reference to Minerva class, could you tell us what is the alternative to cast the objref in PortableRemoteObject.narrow( objref, ? ) method ? dovan > > > Also, you should use java:comp/env/ lookups, but that's not relevent here. > > > 3) *** static methods for closing rs/conn/stmt ( I will place the entire > > class here -- sorry if the readability is a little bad, tried to crunch it > > all in ) > > import java.sql.*; > > public class DatabaseUtility { > > Looks fine. > > > 4) *** RMI ServerException Stack Trace ( this is thrown and the connection > > is NOT returned to the pool ) > > This is thrown when I try to call DatabaseUtility.closeConnection( > > connection ); (notice I catch _everything_ in that method) and is _not_ > > thrown in the DatabaseUtility, but seems like it is thrown on the attempt to > > call the method. > > java.rmi.ServerException: Transaction rolled > > back:com/bebee/recommender/utility/DatabaseUtility > > at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:300) > > Ok, you're missing out some details. Are you calling an EJB from a servlet? > > You haven't mentioned anything about what this EJB is doing. What are you > doing with transactions? Are you getting the connection in the servlet > and trying to close it from the EJB or something? > > > 5) *** NullPointerException stack trace (sorry for the log format) this is > > thrown on the preparedStatement.close() call inside the bean at the end of > > the transaction (which is directly after the call to connection.close() -- > > when I change the order of the calls, i.e. first close the prepared > > statement then close the connection it works fine) > > This is a bug. I'll look at this kind of fragility at some point. > > Toby. > > _______________________________________________ > JBoss-user mailing list > JBo...@li... > http://lists.sourceforge.net/lists/listinfo/jboss-user |