ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gilles Schlienger <s_gi...@yahoo.com>
Subject Strange behaviour with datasource ?
Date Mon, 11 Aug 2008 14:31:54 GMT
Hi everyone,
I am using iBATIS in my web application with the following versions:
- Spring 2.5.4
- iBATIS 2.3.0.677
- MySQL 5.0
- Tomcat 5.5
- JDK 1.5
I use a DBCP datasource version 1.2.1 (commons-dbcp)

In my search engine, if the search query is longer than a certain time (it seems to be 5 seconds?),
then after receiving the results from the database (I can see the debug logs from the result
set) the application hangs for 25 to 30 seconds!!

But when the query is fast (1 second), then I don't see anything wrong ! (everything is fast)

When I put the DEBUG level in log4j, I can see the following logs (see below)

I am not sure where it comes from, the last log I see before gettiing the results back in
my code is :
<Returning JDBC Connection to DataSource>

If someone had any idea, that would really be nice.
Thanks a lot in advance
Regards
Gilles

I use the Spring template client integration mechanism with the foloowing config in my iBATIS
configuration file:
    <settings cacheModelsEnabled="true" enhancementEnabled="true"
        lazyLoadingEnabled="false" maxRequests="128" maxSessions="10"
        maxTransactions="5" useStatementNamespaces="true"
        statementCachingEnabled="true"
        classInfoCacheEnabled="true" />


2008-08-11 16:26:12,929 DEBUG [java.sql.PreparedStatement] - <{pstm-100079} Executing Statement:
  select STRAIGHT_JOIN distinct MDT_ID, MDH_ID, MDH_EC_NOM, MDH_MODIF_DATE,MDH_FK_CRCC_DESTINATAIRE_CRG_ID,
IFNULL(CONCAT(TIT_PP.USR_NOM,' ', TIT_PP.USR_PRENOM), TIT_PM.CBT_DENOMINATION) AS TITULAIRE,
IFNULL(CONCAT(SUP_PP.USR_NOM,' ', SUP_PP.USR_PRENOM), SUP_PM.CBT_DENOMINATION) AS SUPPLEANT,
IFNULL(CONCAT(SIGN.USR_NOM,' ', SIGN.USR_PRENOM), NULL) MEMBRE_SIGNATAIRE, TIT_PP.USR_ID AS
TIT_PP_ID, SIGN.USR_ID AS SIGN_ID, MDH_FK_CRCC_SIGNATAIRE_CRG_ID AS SIGN_CRG_ID, TIT_PM.CBT_ID
AS TIT_PM_ID from MANDAT_HEADER H left join CABINET TIT_PM on H.MDH_FK_TITULAIRE_PM_CBT_ID
= TIT_PM.CBT_ID left join UTILISATEUR TIT_PP on TIT_PP.USR_ID = H.MDH_FK_TITULAIRE_PP_USR_ID
left join CABINET SUP_PM on H.MDH_FK_SUPPLEANT_PM_CBT_ID = SUP_PM.CBT_ID left join UTILISATEUR
SUP_PP on SUP_PP.USR_ID = H.MDH_FK_SUPPLEANT_PP_USR_ID left join UTILISATEUR SIGN on H.MDH_FK_SIGNATAIRE_USR_ID
 = SIGN.USR_ID    ,MANDAT_PARENT    where MDH_FK_MANDAT_MDT_ID = MDT_ID     AND (( MDT_FK_ETAT_GLOBAL_MDE_ID
= ? ) )   AND MDH_FK_CAMPAGNE_CPG_CODE = ?                                    ORDER BY MDT_ID
       ASC     LIMIT  ?  ,?     >
2008-08-11 16:26:12,929 DEBUG [java.sql.PreparedStatement] - <{pstm-100079} Parameters:
[0, 2008, 200, 20]>
2008-08-11 16:26:12,929 DEBUG [java.sql.PreparedStatement] - <{pstm-100079} Types: [java.lang.Integer,
java.lang.Integer, java.lang.Integer, java.lang.Integer]>
2008-08-11 16:26:16,601 DEBUG [org.apache.catalina.session.ManagerBase] - <Start expire
sessions StandardManager at 1218464776601 sessioncount 1>
2008-08-11 16:26:16,601 DEBUG [org.apache.catalina.session.ManagerBase] - <End expire sessions
StandardManager processingTime 0 expired sessions: 0>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} ResultSet>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Header: [MDT_ID, MDH_ID,
MDH_EC_NOM, MDH_MODIF_DATE, MDH_FK_CRCC_DESTINATAIRE_CRG_ID, TITULAIRE, SUPPLEANT, MEMBRE_SIGNATAIRE,
TIT_PP_ID, SIGN_ID, SIGN_CRG_ID, TIT_PM_ID]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001860, 37120,
LATREUILLE ETS, 2008-06-25 18:26:51.0, 3, CABINET RAMPNOUX & ASSOCIES SA, DURAND Philippe,
BISTUER Frédéric, 0, 3000009, 3, 3090004]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001861, 37118,
VILQUIN ETS, 2008-06-25 18:26:51.0, 3, CABINET RAMPNOUX & ASSOCIES SA, BERSANS Alain,
BISTUER Frédéric, 0, 3000009, 3, 3090004]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001862, 37115,
MIDATEST, 2008-06-25 18:26:51.0, 3, CABINET RAMPNOUX & ASSOCIES SA, BISTUER Frédéric,
BISTUER Frédéric, 0, 3000009, 3, 3090004]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001864, 37112,
SUPRANORD, 2008-06-25 18:26:51.0, 3, CABINET GOUL SAS, FABRE Didier, MANNECHEZ Roger, 0, 3000122,
3, 3090001]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001886, 37087,
CLAUNI, 2008-06-25 18:26:51.0, 3, MAZAT Jean-Noël, SP COMMISSARIAT AUX COMPTES  SARL, null,
3000036, 0, 0, 0]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001892, 37076,
HORTI INVESTISSEMENTS, 2008-06-25 18:26:51.0, 3, CABINET BAROUH SA, SILVA Philippe, FREZALS
Serge, 0, 3253830, 3, 3090023]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001896, 37070,
LESCOS, 2008-06-25 18:26:51.0, 3, CABINET BAROUH SA, MILLARD Claude, BONPUNT Marianne, 0,
3000096, 3, 3090023]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001898, 37067,
PRIMEURS DU SUD-OUEST, 2008-06-25 18:26:51.0, 3, ASTOUX CRESTIA & ASSOCIES  SA, VERDES
Michel, ASTOUX Eric, 0, 3000002, 3, 3090018]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001903, 37056,
CIE PRODUITS GASCONS, 2008-06-25 18:26:51.0, 3, DRAPIER Bernard, DUCASSE Gilbert, null, 3000059,
0, 0, 0]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001904, 37053,
METAL, 2008-06-25 18:26:51.0, 3, DRAPIER Bernard, ACQS EXPERTISE CONSEIL SARL, null, 3000059,
0, 0, 0]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001911, 37043,
C.I.B.C. 47, 2008-06-25 18:26:51.0, 3, CABINET HUSSON SA, PANOUILLERES Patrick, DRAPE Pierre,
0, 3000019, 3, 3090002]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001913, 37039,
SUD MANAGEMENT ENTREPRISE, 2008-06-25 18:26:51.0, 3, CABINET HUSSON SA, JCB AUDITEURS CONSEILS
ASSOCIES, PANOUILLERES Patrick, 0, 3000093, 3, 3090002]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001914, 37038,
SA GARRIGUES, 2008-06-25 18:26:51.0, 3, CABINET HUSSON SA, CABINET GOUL SAS, PANOUILLERES
Patrick, 0, 3000093, 3, 3090002]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001917, 37034,
TAQUIPNEU, 2008-06-25 18:26:51.0, 3, CABINET HUSSON SA, null, DRAPE Pierre, 0, 3000019, 3,
3090002]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001919, 37031,
BRUNO VOLPATO SA, 2008-06-25 18:26:51.0, 3, LOUIT Dominique, BOURDIL Claude, null, 3000080,
0, 0, 0]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001923, 37027,
PARNASSE PATRIMOINE, 2008-06-25 18:26:51.0, 3, KPMG SA, BOROTRA Xavier, FEIGNA Bernard, 0,
3000021, 3, 90090019]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001931, 37019,
CENTRALE HYDROELECTRIQUE, 2008-06-25 18:26:51.0, 3, DRAPE Madeleine, GOULINAT Jean-Philippe,
null, 3000018, 0, 0, 0]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001936, 37011,
COLLONGUES ET FILS, 2008-06-25 18:26:51.0, 3, A.C.E. SA, DRAPIER Bernard, CASSAGNE Jacques,
0, 3000056, 3, 3090007]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001939, 37006,
JEAN CUGINI, 2008-06-25 18:26:51.0, 3, A.C.E. SA, DRAPE Madeleine, CASSAGNE Jacques, 0, 3000056,
3, 3090007]>
2008-08-11 16:26:20,898 DEBUG [java.sql.ResultSet] - <{rset-100080} Result: [3001943, 37001,
SICA APPROVISIONNEMENT RURAL, 2008-06-25 18:26:51.0, 3, A.C.E. SA, CASSAGNE Jacques, GOULINAT
Jean-Philippe, 0, 3000027, 3, 3090007]>
2008-08-11 16:26:20,898 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - <Returning
JDBC Connection to DataSource>
2008-08-11 16:26:47,148 DEBUG [fr.cncc.gestionmandats.service.impl.GestionMandatsServiceImpl]
- <rechercherMandats returning : 20 elements>


      _____________________________________________________________________________ 
Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr
Mime
View raw message