Hello Thomas
For my Msql database this connection string is in the datasource definition of
the tomcat configuration (Server.xml).
This is how I configured my datasource:
<Resource name="jdbc/DATASOURCENAME"
auth="Container"
type="javax.sql.DataSource"
maxActive="4"
maxIdle="2"
maxWait="5000"
username="MYSQLUSERNAME"
password="SECRET"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/DATABASENAME?autoReconnect=true"
/>
<ResourceParams name="jdbc/DATASAOURCENAME">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select now();</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
HTH
Claudio
PS: I am not sure if this will solve the problem with your derby and BDB
databases. David already noted that it may be as well any other networking
issue, since the broken pipe message you get only tells us that the connection
has been lost.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Samstag, 2. Februar 2008 15:28
To: [email protected]
Subject: Re: [magnolia-user] ClientAbortException: java.net.SocketException:
Broken pipe
Hello Claudio
Thanks for the input.
Unfortunately I'm not clear where I would configure the connection
string or timeout setting.
Any further explanation is highly appreciated.
File sizes range between 200k to 10MB.
Tx, Thomas
On 31.01.2008, at 09:26, Claudio Greuter wrote:
> Hi Thomas
>
> I use Magnolia in combination with MYSQL, not Derby or BDB. However I
> had a similar exception in my logs once, caused by database
> disconnects.
>
> I managed to get rid of them by specifying "Autoreconnect=true" in the
> connection string. However I don't know if you could do the same on
> Derby or BDB.
>
> Is there some sort of timeout setting for the Derby or BDB? Does it
> only
> happen with bigger files?
>
> Hth
> Claudio
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 25. Januar 2008 15:50
> To: [email protected]
> Subject: [magnolia-user] ClientAbortException:
> java.net.SocketException:
> Broken pipe
>
> Hi List
>
> I have a rather puzzling issue that arises in multiple projects:
> whenever I try to pull downloads from the dms I get a
>
> ClientAbortException: java.net.SocketException: Broken pipe
>
> and as a result a corrupted file in the download. It happens with
> different files (zip/pdf/mov) in different projects.
>
> Magnolia Version: 3.0.2 with BDB and 3.0.5 with derby on different
> OS's (linux/OSX)
>
>
>
> Can someone give me a clue how to avoid this?
>
> TIA for any pointer!
> Thomas
>
>
>
> ----------------------------------------------------------------
> for list details see
> http://documentation.magnolia.info/docs/en/editor/stayupdated.html
> ----------------------------------------------------------------
>
> ----------------------------------------------------------------
> for list details see
> http://documentation.magnolia.info/docs/en/editor/stayupdated.html
> ----------------------------------------------------------------
Mit freundlichen Grüssen
--------------------------
Thomas Martin [tm]
Dipl. Interaktionsleiter FH
St. Johanns-Vorstadt 3
CH 4056 Basel
Switzerland
T +41 61 273 57 72
M +41 76 558 67 90
[EMAIL PROTECTED]
http://www.thomas-martin.ch
skype: thomas-martin.ch
--------------------------------------
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
