Subject Re: [Firebird-Java] Re: JBuilder DataSet Components and Firebird
Author Leonardo Vieira Cervo
Hi,

I have the same problem, in InterClient this method behaves like
PreparedStatement.setObject(int, Object); in Jaybird it throws an exception.

Leo.

Roman Rokytskyy 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?
>
>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
>>
>>
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>