commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henri Yandell <>
Subject RE: [dbutils][OT]Test case approach
Date Fri, 24 Jan 2003 15:54:39 GMT

It's a hypothetical example of mine :)

There are some 'bugs' in Oracle's driver.

Ones I know of:

TIMESTAMP fields in the db are painful to work with without using Oracle's
specific timestamp class. This could be fixed to make the
java.sql.Timestamp map to Oracle's TIMESTAMP properly.

Getting Primary Keys for a table. The last column throws an Exception, so
you have to make sure you don't get the last column out of the primary key
result set.

ResultSet.isLast is not implemented.

By wrapping the real oracle driver in a bugfix driver that dealt with the
above and more, I could ignore the bugs and pretend I have a working
driver :) At the moment I just code around the bugs.


On Fri, 24 Jan 2003 wrote:

> Excuse me for butting in here, but I've seen a couple of references to
> OracleBugFixDriver and that has got my curiosity up. We are using Oracle 9i
> in a web environment with OJB for persistence. We are using the latest
> driver from Oracle (ojdbc14.jar) and we keep getting IO errors on our demo
> server. I just couldn't help wondering what this OracleBugFixDriver is
> fixing, and where it can be found.
> Thanks,
> Dave Derry
>                       "Steven Caswell"
>                       <steven@caswell.         To:      "'Henri Yandell'" <>,
"'Jakarta Commons
>                       name>                    Developers List'" <>
>                                                cc:
>                       01/24/2003 10:08         Subject: RE: [dbutils] Test case approach
>                       AM
>                       Please respond
>                       to "Jakarta
>                       Commons
>                       Developers List"
> Sounds like option 4 could be written once and then configured for
> different test cases. I suspect option 3 with a Mock object would
> require more per-test effort. If this is the case, I'd definitely go for
> option 4. And for driver-specific tests (i.e., OracleBugFixDriver), I'd
> expect to have to write one-off tests for that anyway.
> Do you already have a TestDriver written? I can take a shot at an
> initial cut if not.
> Have you put together a TestDriver scenario for the ResultSet wrapper?
> If not, I can take a shot at that one also.
> Steven Caswell
> --
> To unsubscribe, e-mail:   <>
> For additional commands, e-mail: <>

To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message