Subject Re: [Firebird-Java] Re: JBuilder DataSet Components and Firebird
Author herbert.augustiny@sptroth.com
Post date 2002-12-07T18:43:37Z
"Roman Rokytskyy <rrokytskyy@...>" wrote on 07.12.2002 19:28:54:

> Hi,
> Your problem with XSQLDA version seems to be related to database
> server v.0.9.4. Firebird 1.0 was released a long time ago, and it
> fixed a lot of bugs in 0.9.4. So, I would recommend to upgrade your
> database server.

You are absolutely right, but we are also using IBReplicator and unfortunately, the stupid thing does not work with Firebird 1 on linux and they are not able to provide me with the updated version the promissed me for several months now. So unless I write my own replication engine I'm stuck using 0.9.4 :-(

> If you want a same workaround as InterClient has, you can patch your
> sources. Look into the file client-
> java/src/main/org/firebirdsql/jdbc/FBPreparedStatement.java, in
> method setObject(int, Object, int, int) you comment out throwing an
> exception and change it like this:
> public void setObject(int colIndex, Object value, int sqlType, int
> scale) throws SQLException {
> // this is a workaround, we ignore sqlType and scale
> // hoping that nothing bad happens
>
> setObject(colIndex, value);
> }

Sounds great, I will try this on tomorrow (I will need to set up FB 1...)
> I do not think that we will add this code to the CVS version, because
> ignoring some parameters is not very nice, but you can keep your CVS
> snapshot and synchronize with main tree. Since we do not plan to
> change this method, there should be no conflicts, but even if they
> are you can patch code from the CVS.
> In general, it would be great if somebody can provide a list
> unimplemented methods that are used by JBuilder components and post
> them in a bug tracker and here. This will help us prioritize features.

I will let you know as soon as I find more such things
Regards,

Herbert