cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas SANDRI <nicolas.san...@free.fr>
Subject Re: "No buffer space available"
Date Wed, 04 Jun 2003 14:39:23 GMT
ok, it works now !
I must think about a good way to join the two SQL request in only one  
now !

thanks a lot.

Nicolas

Le mercredi, 4 juin 2003, à 13:29 Europe/Paris, Geoff Howard a écrit :

> You can (and should) use one esql:connection for your entire page.
>
> Geoff
>
> At 04:48 AM 6/4/2003, you wrote:
>> I don't know esql, but is it useful  to open a connection for each  
>> row ?
>>
>> What's happening if you do not open a connection for your second  
>> request ?
>>
>> At 19:28 03/06/2003 +0200, you wrote:
>>> Yeah, buffer is full !
>>>
>>> I open one connection for every rows, and another connection in each
>>> one :
>>> <?xml version="1.0"?>
>>>
>>> <xsp:page language="java"
>>>           xmlns:xsp="http://apache.org/xsp"
>>>           xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>>>           xmlns:esql="http://apache.org/cocoon/SQL/v2">
>>>
>>> <Root>
>>> <xsp:comment>Extraction catalogue (c)2003 MediaXtend</xsp:comment>
>>> <esql:connection><esql:dburl>jdbc:mysql://localhost/my_db</  
>>> esql:dburl><esql:username>log</esql:username><esql:password>pass</
 
>>> esql:password>
>>> <esql:execute-query>
>>> <esql:query>SELECT
>>> a.cle,a.refcomplete,a.titreindex,a.soustitre,a.resume,a.nsupports,s.s 
>>> upp ort,a.cab,lcase(a.ref) AS image,l.label,c.publicTTC,a.motscles  
>>> FROM
>>> article AS a LEFT JOIN label AS l ON l.cle=a.label LEFT JOIN codeprix
>>> AS c ON c.cle=a.codeprix LEFT JOIN support AS s ON s.cle=a.support
>>> WHERE a.catalogue=7 AND a.dispo=1 AND a.supprime=0 AND a.parution  
>>> &lt;
>>> '2003-05-31' AND genre=2 AND catalogue=7 ORDER BY a.titreindex,
>>> a.motscles, a.soustitre</esql:query>
>>> <esql:results>
>>> <esql:row-results>
>>>  <disque>
>>>   <ref><esql:get-string column="refcomplete"/></ref>
>>>   <titre><esql:get-string column="titreindex"/></titre>
>>>   <soustitre><esql:get-string column="soustitre"/></soustitre>
>>>   <resume><esql:get-string column="resume"/></resume>
>>>   <label><esql:get-string column="label"/></label>
>>>   <prix><esql:get-string column="publicTTC"/></prix>
>>>   <support><esql:get-string column="nsupports"/> <esql:get-string
>>> column="support"/></support>
>>>   <xsp:logic>
>>>     String lbl = <esql:get-string column="label"/>;
>>>     lbl = lbl.toLowerCase();
>>>     lbl = lbl.replace( ' ' ,'_' );
>>>     lbl = lbl.replace( '\'' ,'_' );
>>>   </xsp:logic>
>>>   <xsp:element name="codebarre"><xsp:attribute
>>> name="href">file:///Scrat/abeille/images/codes-barres/ 
>>> <xsp:expr>lbl</ xsp:expr>/<esql:get-string column="cab"/>.eps</xsp\
>>> :attribute></xsp:element>
>>>   <xsp:element name="image"><xsp:attribute
>>> name="href">file:///Scrat/abeille/images/references/<esql:get-string
>>> column="image"/>.tiff</xsp:attribute></xsp:element>
>>>
>>> <recompenses><esql:connection><esql:dburl>jdbc:mysql://localhost/
 
>>> my_db</esql:dburl><esql:username>log</  
>>> esql:username><esql:password>pass</esql:password><esql:execute-
 
>>> query><esql:query>SELECT ra.article,r.code FROM recompensearticle AS
 
>>> ra
>>> LEFT JOIN recompense AS r ON r.cle = ra.recompense WHERE ra.article =
>>> <esql:get-string column="cle"/> LIMIT
>>> 0,8</esql:query><esql:results><esql:row-results>
>>>    <xsp:element name="recompense"><xsp:attribute
>>> name="href">file:///Scrat/abeille/images/recompenses/couleurs/  
>>> <esql:get-string
>>> column="code"/>.eps</xsp:attribute></xsp:element></esql:row-

>>> results></ esql:results></esql:execute-query></esql:connection>
>>>   </recompenses>
>>>  </disque>
>>> </esql:row-results>
>>> </esql:results>
>>> </esql:execute-query>
>>> </esql:connection>
>>> </Root>
>>>
>>> </xsp:page>
>>>
>>> Le mardi, 3 juin 2003, à 16:53 Europe/Paris, Lionel Crine a écrit :
>>>
>>>> It seems that the buffer is full.
>>>>
>>>> Do you open a connection for every rows ?
>>>>
>>>>
>>>> At 15:28 03/06/2003 +0200, you wrote:
>>>>> Hi,
>>>>>
>>>>> I'm trying to extract rows from my MySQL database and convert it to
>>>>> an XML file, using Tomcat/Cocoon.
>>>>> I'm running :
>>>>>   FreeBSD 5.0R
>>>>>   Sun JRE 1.3.1 (patchset 8)
>>>>>   Tomcat 4.1.18
>>>>>   Cocoon 2.0.4
>>>>>   MySQL 3.23.54
>>>>>   MySQL J/Connector 3.0.6
>>>>>
>>>>> When I start loading my page (a simple XSP/ESQL), I get the normal
>>>>> XML datas but after a moment download stops and a HTML page is  
>>>>> added
>>>>> at end of file. All of my other pages work but this one that  
>>>>> extract
>>>>> a lot of rows (more than 4,000) doesn't work.
>>>>> In the html part, I got an error page with this message :
>>>>> [...]
>>>>> org.apache.cocoon.ProcessingException: Exception in
>>>>> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
>>>>> opening connection to dburl: jdbc:mysql://localhost/my_db: Unable  
>>>>> to
>>>>> connect to any hosts due to exception: java.net.SocketException: No
>>>>> buffer space available
>>>>> [...]
>>>>>
>>>>> Any ideas ?
>>>>>
>>>>> Thanks
>>>>>
>>>>> Nicolas SANDRI
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------- 
>>>>> --
>>>>> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>>>>> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>>>>
>>>>
>>>> -------------------------------------------------------------------- 
>>>> -
>>>> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>>>> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>>> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message