Subject Re: [Firebird-Java] Re: JBuilder DataSet Components and Firebird
Author Paul Nichols
--- Roman Rokytskyy <rrokytskyy@...> 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