--- Roman Rokytskyy <rrokytskyy@...> wrote:

> Hi,
>
> This fetaure (PreparedStatemnt.setObject(int,
> Object, int, int)) is
> not implemented yet and most likely will not be
> implemented in the
> nearest future because it depends on some other
> things that are not
> yet implemented.
>
> Aren't there some other way to set parameters using
> Borland's
> database components, so this method is not called?
>

Unfortunately not. The DataSet components create a
PreparedStatement as part of the Resolver mechanism to
allow automatic updates/inserts from the underlying
Select statement through the Borland DataSet classes.
I usually do not work this way (as I like more
transaction control over my data), but for some
stand-alone and FAT Client situations, the Borland way
of doing things works very well and saves a lot of
time when doing Client/Server SWING.

FWIU,the Borland DataSet components use a Resolver
mechanism to create a Prepared Statements on the
underlying Borland DataSet (usually QueryDataSet), and
map the SQL Select's statemment as the defined
Parameters for the auto generated Prepared Statement.
This PreparedStatement is created through the
QueryDataSetResolver Class. Parameter definition(s)
(which are a part of the Prepared Statement), are
defined in the DataSets.ROWIDs through the Query
Designer. When a ROWID is defined in the QueryDataSet
component, each Resolvable ROWID that has been marked
as resolvable, will be automatically mapped to the
Resolver's creation of a Prepared Statement. Whenever
the Database.save(DataSetName) is fired, the JBCL Data
aware controls that are mapped to the Resolvable
RowIDs will be handled as an array of Parameters and
sent to the Borland created Prepared Statement and
executed, returning a pass/fail return code on the
update/insert (probably wrappering the
java.sql.SQLException class).

> BTW, does InterClient driver works with your code?
>

Yes Interclient works fine, but is such a pain in the
arse to get running properly on a client's machine. I
love the Jaybird drivers and much prefer using these.
I have been using them since the beta release, but I
have not tried this type of usage until now. Most of
our development with the Jaybird Drivers have been
restricted to JSP/Servlets, and we have not
experienced any major problems (except some minor
transaction problems) especially since RC1.

Thanks Roman and thank you for the wonderful service
you and your team are performing in creating these
type 4 JDBC Drivers for Firbird. The fast response you
have offered by getting back to me almost immediately,
really means a lot. I only regret we are slammed with
work and deadlines right now, or I would be glad to
try and help implement the needed support for the
Borland DataSets.

Since JB is the #1 Java tool right now, I think that
this service would be beneficial and help to provided
more adoption of Firebird in the Java and JBuilder
Development community. Keep up the excellent work and
thanks again!!







__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com