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
