You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by george georgovassilis <ge...@open.gr> on 2004/12/09 13:52:30 UTC
DatabaseReader + ImageReader --> leak db connections?
Dear All
When using the ImageReader to scale an image retrieved by the
DatabaseReader in the same pipeline then up to N requests are serviced
(where N is the database connection pool size) before the request hangs.
The DatabaseReader alone however does fine.
I have verified that the connection pool cannot provide any further
connections after this. Any ideas?
G.
------ sitemap used ----------
...
<map:readers default="resource">
<map:reader name="databasereader"
logger="sitemap.reader.databasereader"
src="org.apache.cocoon.reading.DatabaseReader">
<use-connection>mypool</use-connection>
</map:reader>
</map:readers>
...
<map:match pattern="resource/*">
<map:read type="databasereader" src="{1}">
<map:parameter name="table" value="IMAGES"/>
<map:parameter name="image" value="CONTENTt"/>
<map:parameter name="key" value="ID"/>
<map:parameter name="content-type" value="mimetype"/>
</map:read>
</map:match>
<map:match pattern="preview/*">
<map:read type="image" src="cocoon:/resource/{1}" mime-type="image/jpeg">
<map:parameter name="width" value="50"/>
<map:parameter name="height" value="50"/>
</map:read>
</map:match>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: DatabaseReader + ImageReader --> leak db connections?
Posted by george georgovassilis <ge...@open.gr>.
An update on that:
It seems that connections are leaked even in a simple internal redirection:
<map:match pattern="preview/*">
<map:read src="cocoon:/resource/{1}"/>
</map:match>
so I guess it doesn't have to do with the ImageReader, at least.
george georgovassilis wrote:
> Dear All
>
> When using the ImageReader to scale an image retrieved by the
> DatabaseReader in the same pipeline then up to N requests are serviced
> (where N is the database connection pool size) before the request
> hangs. The DatabaseReader alone however does fine.
>
> I have verified that the connection pool cannot provide any further
> connections after this. Any ideas?
> G.
>
> ------ sitemap used ----------
>
> ...
> <map:readers default="resource">
> <map:reader name="databasereader"
> logger="sitemap.reader.databasereader"
> src="org.apache.cocoon.reading.DatabaseReader">
> <use-connection>mypool</use-connection>
> </map:reader>
> </map:readers>
> ...
> <map:match pattern="resource/*">
> <map:read type="databasereader" src="{1}">
> <map:parameter name="table" value="IMAGES"/>
> <map:parameter name="image" value="CONTENTt"/>
> <map:parameter name="key" value="ID"/>
> <map:parameter name="content-type" value="mimetype"/>
> </map:read>
> </map:match>
>
> <map:match pattern="preview/*">
> <map:read type="image" src="cocoon:/resource/{1}" mime-type="image/jpeg">
> <map:parameter name="width" value="50"/>
> <map:parameter name="height" value="50"/>
> </map:read>
> </map:match>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org