Hi Roman,

My memory may be faulty, I couldn't find the message I was thinking of
(imagining?).

The version of JayBird I was using was the most current as of July 3,
04, when I first tried Creator.

A new update to Creator came out recently and I tried it with the same
result.

Creator uses Sun's Application Server version 8 as the built-in J2EE
server for web app testing.

The symptom was that Creator could set up the DataSource and retrieve
the database schema, but when any query was tried (SELECT * FROM
MYTABLE), Creator threw an exception saying that the "ResultSet is
closed."

When I went into Creator's log file the exception that was listed was
a failure to connect to localhost. This was odd since the driver had
succesfully connected to get the schema from the database.

When I substituted JayBird 1.5.5 on the same Creator setup, the error
went away. I have been able to pull ResultSets out with Creator with
no problem both from localhost on a WinXP system and from a Linux
server on the local net. I have not tried Type 2 on localhost yet,
but I'm not sure if Creator supports Type 2.

I haven't got around to trying database updates yet, but so far no
problems.

When I do a little more testing, I'll post a report.

If it works OK, it will validate JayBird for both Creator and at least
partly for Sun's Application Server (Version 8 anyway).

I think this could be good for Firebird/JayBird. Although almost
nobody uses Sun's J2EE server ;-), Creator is pretty slick.

Once you get the hang of it, you can create, and test a Web App with a
JSP page that pulls database info into an HTML table and allows you to
scroll through the ResultSet in about 10 minutes. With no Java coding
(or HTML for that matter). You edit all the HTML properties (color,
fonts, Titles, alignment, etc. in the same editor.

It uses Java Server Faces components and has some built-in web
services components.

The resulting web app will run in Tomcat.

It is cheap too, $99 (USD) for a license and support for a year. It
has a 30 day free trial also.

Being able to use Firebird/Jaybird with it is a real plus.


Rick

--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > After messing around with this for awhile I think the problem was
> > simply the "ResultSet is closed" problem that was encountered with
> > other applications.
>
> Is "ResultSet is closed" believed to be a JayBird bug? Can you point

me to

> the messages where it was discussed (I do not remember such bug, sorry)?
>
> Roman