Subject Re: JBuilder DataSet Components and Firebird
Author Roman Rokytskyy
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?

BTW, does InterClient driver works with your code?

Thanks!
Roman Rokytskyy

--- In Firebird-Java@y..., Paul Nichols <paulwnichols@y...> wrote:
>
> --- Roman Rokytskyy <rrokytskyy@y...> wrote:
> > > Any chance that the Jaybird JDBC driver will work
> > with
> > > the Borland JBuilder DataSets?
> > >
> > > I have tried to use the
> > Database.saveChanges(DataSet)
> > > to no avail. The Error Msg indicates that this
> > > features is not yet supported.
> >
> > What feature? Can you post a stack trace?
> >
> > Thanks!
> > Roman Rokytskyy
> >
>
> Sure, sorry I should have been more descriptive, but I
> thought perhaps others had already experienced this.
>
> We are attempting to use the jaybird.rc1 drivers on a
> stand-alone or fat-client/thin server type solution
> using JB7 and Firebird Build 1.0. We are connecting to
> Firebird using JayBird and a Database comp from the JB
> 7 component palette. QueryDataSets are used to connect
> to the Database comp and the DB Components are used
> from the JB Component pallete (com.borland.dx) to
> connect to the QueryDataSets.
>
> RowIDs have been set in the QueryDatatSets (as
> required), and the QueryDataSets Resolvale is set to
> true. Selects works perfectly, but updates and inserts
> fail. We have tried this using the QueryDataSet's
> default Resolver and by using a QueryDataSetResolver
> and setting the properties ourselves. Both methods
> fail.
>
> The Stack trace is as follows:
>
> java.sql.SQLException: not yet implemented
> at
> org.firebirdsql.jdbc.FBPreparedStatement.setObject
(FBPreparedStatement.java:376)
> at com.borland.dx.sql.dataset.j.setParameter(Unknown
> Source)
> at com.borland.dx.sql.dataset.a.a(Unknown Source)
> at com.borland.dx.sql.dataset.l.a(Unknown Source)
> at
> com.borland.dx.sql.dataset.QueryResolver.updateRow(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.ResolutionManager.a(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.ResolutionManager.e(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.ResolutionManager.e(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.Database.saveChanges(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.SQLResolver.resolveData(Unknown
> Source)
> at
> com.borland.dx.dataset.StorageDataSet.saveChanges(Unknown
> Source)
> at
> com.borland.dx.sql.dataset.QueryDataSet.saveChanges(Unknown
> Source)
> at com.borland.dx.dataset.DataSet.saveChanges(Unknown
> Source)
> at
> com.borland.dbswing.JdbNavToolBar.actionPerformed
(JdbNavToolBar.java:1799)
> at
> javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1445)
> at
> javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1499)
> at
> javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:373)
> at
> javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:245)
> at
> javax.swing.plaf.basic.BasicButtonListener.mouseReleased
(BasicButtonListener.java:211)
> at
> java.awt.AWTEventMulticaster.mouseReleased
(AWTEventMulticaster.java:226)
> at
> java.awt.Component.processMouseEvent(Component.java:3710)
> at
> java.awt.Component.processEvent(Component.java:3539)
> at
> java.awt.Container.processEvent(Container.java:1159)
> at
> java.awt.Component.dispatchEventImpl(Component.java:2588)
> at
> java.awt.Container.dispatchEventImpl(Container.java:1208)
> at
> java.awt.Component.dispatchEvent(Component.java:2492)
> at
> java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)
> at
> java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)
> at
> java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
> at
> java.awt.Container.dispatchEventImpl(Container.java:1195)
> at java.awt.Window.dispatchEventImpl(Window.java:923)
> at
> java.awt.Component.dispatchEvent(Component.java:2492)
> at
> java.awt.EventQueue.dispatchEvent(EventQueue.java:334)
> at
> java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:126)
> at
> java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:93)
> at
> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:88)
> at
> java.awt.EventDispatchThread.run(EventDispatchThread.java:80)
>
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com