hi matthieu,
ojb does nothing strange here. it's a p6spy feature that allows you to
log access to the result set.
... 818|-1||resultset|SELECT A0.VO_ID,A0.VO_N ....
this is the way to exclude resultset log entries :
#list of categories to exclude: error, info, batch, debug, statement,
#commit, rollback and result are valid values
excludecategories=info,debug,result,batch,resultset,prepared
hth
jakob
[EMAIL PROTECTED] schrieb:
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)
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.17/227 - Release Date: 11.01.2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
