You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-user@db.apache.org by Marcel Wagner <ma...@gmx.de> on 2009/01/02 10:03:53 UTC

Problem with importing BLOB data

Hi,

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

Thanks for the help,

Marcel

Re: Problem with importing BLOB data

Posted by Thomas Dudziak <to...@gmail.com>.

On Fri, Jan 2, 2009 at 1:03 AM, Marcel Wagner <ma...@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