Dear ojb user, i've got a question about the behavior of OJB (1.0.3). If i ask for a collection of vehicule OJB fetch the data from the database to build the collection the expect bellow show what P6SPY catch : [11/01/06 12:13:23:808 CET] 78faf5a0 SystemOut O 1136978003808|60|7|statement|SELECT A0.VO_ID,A0.VO_NUMPOLICE,...AND '2007-01-01' ORDER BY 30 [11/01/06 12:13:23:808 CET] 78faf5a0 SystemOut O 1136978003808|-1||resultset|SELECT A0.VO_ID,A0.VO_NUMPOLICE,..., 5 = 3215511129887689 , 6 = null After, OJB fetch the relations that i asked to be prefetched; till there OJB works as expected. But if i iterate on the collection, it seems that OJB is doing something with the database as resultsets (without statement just above) appear in the log (see the log file attached to this email) and with an external trace tool i see a DSNHTTR SENSITIVE SCROLL command issued from the JDBC driver. Thoses two traces looks like OJB is doing a cursor scroll to fetch the data. But i don't understand the interest of this since it has already fetched (or seems to) the data when it has built the collection. For more information, the file below is a copy of the p6spy trace. (See attached file: tracep6spy.zip) Regards Matthieu PATOU DINQ/DSIN/SIDM/VNVO/VOIN Téléphone 01 30 19 17 91 (29 17 91)
<<attachment: tracep6spy.zip>>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
