[Firebird-devel] Re: [client-java] My suggested changes to driver

[Alejandro A. A. <alb...@bi...>]

Hi,

> Yesterday I tried the project I'm currently working on with driver and got
> couple of exceptions during the data type conversion. I'm not saying that
> something is wrong with current implementation, that might be our
> application too (for example, setInt() on the VARCHAR column). Today I
> integrated my old FBField stuff with the current version of the driver, and
> was really surprised - our application started to work. There are some
> issues with transactions, I'm investigating them.

Roman, the JDBC specs says that the setXXX methods don't have to make
any type conversions as the getXXX methods do. So the behaviour that you
have observed is correct. I think that is not good to rely on non
standad features because you can get into troubles if you want to
migrate to another JDBC.

But, if you think that your approach to the data type conversion is
better we could adopt it.

> In attachment you will find the result of my today's work. I subclassed
> FBResultSet and FBPreparedStatement, and made integration there. However I
> had to make some changes in the FBResultSet (changed private access to
> protected and corrected some bugs in fetchers). Please review them, and if
> you have no objection, I can commit this code to CVS.

I am going review it.
 
> Also I changed the FBConnection. Specs say that there's always transaction
> associated with the connection. However, if you open the connection and then
> rollback, you get an SQLException that there's no local transaction. Strange
> case, but that's how our home-grown JDBC pool works (not my code).

Have you solved that bug ?

The pool produces some funny behaviours:

- If you try to commit a transaction without executing any SQL statement
  you also get that SQLException.
- If you connect to a non existent database you don't get any
  SQLException,you get it once you try to execute any statement.

> I already commited couple of fixes to FBEscapedParser, but that's probably
> the stuff nobody uses.

Great.

Bye.
-- 

+--------------------------+
| Alejandro Alberola Arias |
|    Boix i Oltra, S.L.    |
|  email: alb...@bi...  |
+--------------------------+