Hi Mark,

Sent the following message but it somehow got rejected by SPAMCOP.

So here it is again in the list.
--------------------------

Hi Mark,

This is re the Eclipse DTP plugins and Firebird as discussed on the Firebird Java Yahoo news group.

Thanks for taking the time to look into this.

I have included an example database's meta data at the bottom of this email (could not see how to attach in this email client).

The steps to reproduce the problem are shown below:

* Step 1: Go to Data Source Explorer in Eclipse (I am using Helios Mac 64 version, have also tested on Galileo Windows 32 bit version)
* Step 2: Create a new Database Connection (I called it TestConnection)
* Step 3: Select Firebird for connection type, and fill in the details (I have tested Jaybird version 2.2.0 and 2.1.6)
* Step 4: Expand the newly created connection:
* TestConnection -> testdb -> Schemas -> USER -> Tables -> TEST_TABLE -> Columns

Result: You will see columns FIELD_1, FIELD_2, FIELD_3 and FIELD_4. You should also see FIELD_5, 6, 7, 8, 9 and FIELD_10, but it stops at FIELD_4 because FIELD_5 is a BLOB (well, that is why I think it stops).

I hope it is a reasonably easy fix, thanks again for providing this functionality, definitely useful.

Regards
Colin
------------------------------
CREATE DATABASE '/Path/To/Database/Test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET NONE;

CREATE TABLE TEST_TABLE (
FIELD_1 INTEGER,
FIELD_2 INTEGER,
FIELD_3 VARCHAR(10),
FIELD_4 VARCHAR(10),
FIELD_5 BLOB SUB_TYPE 1 SEGMENT SIZE 80,
FIELD_6 INTEGER,
FIELD_7 INTEGER,
FIELD_8 VARCHAR(10),
FIELD_9 INTEGER,
FIELD_10 INTEGER
);

--- In Firebird-Java@yahoogroups.com, "reg_hill_labs" <reg_hill_labs@...> wrote:
>
> Sure, thanks Mark,
>
> I will create a simple DB and the steps and fire it through to your email today.
>
> Thanks
> Colin
>
> --- In Firebird-Java@yahoogroups.com, "Mark Rotteveel" <mark@> wrote:
> >
> > > A while ago I looked at using Eclipse DTP with Firebird.
> > >
> > > I have started looking again and found the latest plugins at
> > > http://www.lawinegevaar.nl/firebird a big improvement from what I was
> > > looking at in the past.
> > >
> > > The only issue I seem to have is that the plugin does not seem to list any
> > > Blob fields, in fact, as soon as it comes across one, it seems to stop and
> > > misses out reading the rest of the fields in the table.
> > >
> > > Does anyone know if this is a known problem (that is, it is not just me).
> > > If so, are there any known workarounds, for example, different sub types
> > > or anything I can do to get Blobs working in Eclipse? (I am running on a
> > > Mac, using Helios, but have also tried in a couple of earlier versions.)
> > >
> > > The problem can be seen by expanding up any table in the Data Source
> > > Explorer in Eclipse that has a blob field in it... it lists all fields up
> > > to the first blob field, and none after.
> > >
> > > I also see this release was back in 2009, so am wondering if there have
> > > been any updates since.
> >
> > No, I have not written any updates since 2009 (although I do think there
> > are some minor changes in my local workspace). I have had little time
> > because of study, work, and the new house I bought in 2009, so I haven't
> > looked at the code in some time.
> >
> > I will see if I can reproduce this behavior and post a fix for this. I
> > probably either missed this as I usually don't use blobs, or maybe I
> > didn't even implement it yet.
> >
> > Could you provide a more detailed bug report. Specifically listing the
> > steps that result in the error maybe an example database with content (you
> > can mail it to mark@).
> >
> > Unfortunately I am still very busy with finishing my study and with my
> > job, so I can't guarantee a timely fix, but as I have a day off this
> > Thursday, I might find some time to at least look into it.
> >
> > Mark
> > --
> > Mark Rotteveel
> >
>