[dbunit-developer] [ dbunit-Bugs-2999084 ] Add support for Postgresql 8 Blobs.

[SourceForge.net <no...@so...>]

Bugs item #2999084, was opened at 2010-05-10 01:46
Message generated for change (Comment added) made by dfghi
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=2999084&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Feature Request
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: dfghi (dfghi)
Assigned to: Roberto Lo Giacco (rlogiacco)
Summary: Add support for Postgresql 8 Blobs.

Initial Comment:
Recent versions of Postgresql prefer to handle blobs (large objects or "lo", as posgresql documentation calls them) in a separate system table, leaving only a reference (oid) in the original table. This means that it's not possible to use DbUnit to insert Blobs directly in tables. The attached file provides a patch to the existing DataTypeFactory and a new DataType for Postgresql Blobs.
It's a draft because I'm not totally sure of a couple of things, but it's better than nothing.

----------------------------------------------------------------------

>Comment By: dfghi (dfghi)
Date: 2010-11-02 10:14

Message:
The version of PostgresqlBlobDataType in the zip file should be used with
dbcp version 1.2, newer versions should use the attached one, but that
requires to set the property "accessToUnderlyingConnectionAllowed" to true
in the data source.
A good solution would be to get an entirely new connection in another way,
getting the datasource from the factory (if possible) or from some other
source that should be clearly accessible from the PostgresqlBlobDataType
class.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=2999084&group_id=47439