Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (athena.apache.org: domain of tomdzk@gmail.com designates
 209.85.200.170 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=V/7uoaCoMlYxh3oHMIvPSo9j3l5eIIfJLwdSKJGEWoVXMqufb9kNs7Ng+4ZU8vvVEt
         Onm3Ye8q66pwEfk6WCJ2fNxkmAV6kYq2x/5EsMH3/aCB6Ki0golaIsTSp9tNwRcQZZpX
         isTdXFh806SqWKg5OLBGeJayrqOOWi6y/ouUc=
Message-ID: <224f32340901031843t584d775auf2b5553549cb3776@mail.gmail.com>
Date: Sat, 3 Jan 2009 18:43:28 -0800
From: "Thomas Dudziak" <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org, marcel.wagner@gmx.de
Subject: Re: Problem with importing BLOB data
In-Reply-To: <495DD879.3030000@gmx.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <495DD879.3030000@gmx.de>

On Fri, Jan 2, 2009 at 1:03 AM, Marcel Wagner <marcel.wagner@gmx.de> wrote:

> I have some trouble with DdlUtils 1.0 and also trunk. I can't get BLOB data
> imported. I always get
>
> Caused by: java.sql.SQLException: Connection is closed.
>   at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:175)
>   at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
>   at
> org.apache.ddlutils.io.DataToDatabaseSink.end(DataToDatabaseSink.java:217)
>   ... 19 more
>
> As an attachment the schema and data, where the exception occures. Any idea,
> what is the problem??? Verified with MySql and DerbyDB

This error looks like the connection timed out on the database side.
How is the data source configured ? Do you have a validation query ?

Tom