but if the tyrex guys are retired who's changed this in TC4.0.4? BTW what is DBCP?
Kevin Jones Developmentor www.develop.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Lev Assinovsky > Sent: 03 April 2002 09:08 > To: Tomcat Developers List > Subject: Re: Tyrex exception when using tomcat 4.0.4 (b1 and b2) > > > Hi! > I experienced the same problem. > The matter is that TC 4.0.4bX has slightly modified > org.apache.naming.factory.TyrexDataSourceFactory > class. Old one returned EnabledDataSource (didn't work > properly either), new one - ServerDataSource. I tried to > complain to Tyrex guys, but seems they are retired (a year > ago at least). That's why I switched to DBCP and happy now. > > Kevin Jones wrote: > > > > I've been using TC4 for a while now. I'm using the MS SQL > Server JDBC > > drivers (and have been for a while), and install them as a > resource in > > TC using the Tyrex JNDI implementation. In TC 4.0.3 > everything works > > fine, however in TC 4.0.4 (b1 and b2) I get exceptions. > > > > I'm simply doing the following > > > > ctx = new javax.naming.InitialContext(); > > ds = > > (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/WhitePages"); > > conn = ds.getConnection(); > > conn.setAutoCommit(false); > > > > and I'm getting an exception > > > > java.sql.SQLException: Commit not supported in enlisted connections. > > at > tyrex.jdbc.EnlistedConnection.commit(EnlistedConnection.java:154) > > at > > > com.develop.ewebjava.lab.GetPessimistic.doGet(GetPessimistic.java:60) > > > > If I look at the class returned through getConnection I get this > > hierarchy > > > > tyrex.jdbc.EnlistedConnection tyrex.jdbc.AbstractTyrexConnectionImpl > > java.lang.Object > > > > and for the interface hierarchy > > > > java.sql.Connection > > tyrex.tm.EnlistedResource > > > > If I run the same code in TC 4.03 then it all works fine > and the class > > hierarchy looks like this > > > > com.microsoft.jdbc.sqlserver.SQLServerConnection > > com.microsoft.jdbc.base.BaseConnection > > java.lang.Object > > > > so it looks like tyrex in 4.0.4 is wrapping the JDBC > connection with > > its own class. There is no change to the tyrex.jar file, > however the > > TyrexDataSourceFactory and TyrexTransactionFactory classes in > > TC/lib/naming-factory.jar have changed. > > > > I've just added this into Bugzilla, although I'm not sure > it's a bug > > (http://nagoya.apache.org/bugzilla/show_bug.cgi?id=7693). > > > > If anybody could say 'do this' and it would fix the problem I'd be > > grateful, > > > > Kevin Jones > > Developmentor > > www.develop.com > > > > -- > > To unsubscribe, e-mail: > <mailto:tomcat-dev-> [EMAIL PROTECTED]> > > For > additional commands, > e-mail: > > <mailto:[EMAIL PROTECTED]> > > -- > Lev Assinovsky Peterlink Web > Programmer St. Petersburg, Russia > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á > E-mail: [EMAIL PROTECTED] > > -- > To unsubscribe, e-mail: > <mailto:tomcat-dev-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>