Set the RollingLoggedFileAppender filter to DEBUG rather than INFO. You'll see the queries in conf/server.log
If you know log4j you can pipe org.jboss.ejb.cmp.jdbc to its own appender. Regards, Adrian On Tue, 2003-09-02 at 21:50, Carsten Hammer wrote: > Adrian Brock schrieb: > > Looks like it lost the connection to the db? > > > > Regards, > > Adrian > > > > > Yes, I think so too. The question is can this happen because of a > deadlock solved by the SQLServer? > > I now have the the table the finder gets entities from filled that way > that I get 53 entities from it without problems. If I add one row and > have 54 entities that the finder gets back from it it fails when it > accesses an entity bean from the collection the finder returns. > This is completely reproducable. > > This behaviour happens using Microsofts latest jdbc driver servicepack 1 > and MSSQL Server 2000 with ServicePack 3a. > Accessing a second MSSQL Server with exactly the same version of the > driver and SQL Server works. The difference of the two servers is that > one is configured to host SAP. Because of this it uses a different > codepage (cp850 instead of latin1) and differs between uppercase and > lowercase in *all* sql statements. > > Is it possible to log all sql queries jboss generates and feeds to the > jdbc driver? > I can see what comes out of the jdbc driver using the MSSQL Profiler. > All I can see there is totally valid sql that can be proved to be ok for > MSSQL by the MSSQL Query Analyzer. The missing piece for me is what goes > into the jdbc driver... > > Best reagards, > Carsten > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
