No, the sqllite trick cannot be used with Oracle... And even if it was
possible, it is not a serious option because it would kill the driver
performance.... People are still coding DB apps in C because it's faster...
If a C driver has to use exotics and slow behaviors to work, what's the
point ?
The fact libdbi has to know the number of rows returned by a query, before
any fetch, is already a performance bottleneck for some DB, such as Oracle.
>From Oracle 9i, it's possible to know that, with some big performance
loss...(eg. Oracle 8i can't be supported)
In the end, the only thing that i need to finish the ocilib based libdbi
driver is to solve this problem of integer flags and bits..
Any ideas ?
Vincent
2009/5/3 Markus Hoenicka <markus.hoeni...@mhoenicka.de>
> vincent rogier writes:
> > So, i'm still suck in the ocilib based libdbo driver to set the integer
> type
> > bit... For example, a column created as "INT" (4 bytes integer range) or
> > "NUMBER" (38 digits for scale and precision that can holds integer,
> numeric,
> > real, etc..) will be reported by Oracle client library (OCI) as
> "NUMBER"...
> > There's no way to make nay difference...
> >
> > So my question : how to deal with that into an libdbi driver ?
> >
>
> The sqlite/sqlite3 drivers have to deal with a similar problem. sqlite
> is essentially typeless, so you can't even distinguish between numbers
> and text. sqlite3 has something like "sticky types" but these
> distinguish only between text and numeric data. The sqlite/sqlite3
> drivers have to retrieve the command which was used to create a table
> (this is fortunately stored in each sqlite database) and figure out
> which type to use as a return value. This approach has its problems
> (think functions which mangle values retrieved from several columns)
> but it mostly works ok. Would that approach be useful for an ocilib
> based driver?
>
> > PS : about the actual oracle libdbi driver : the driver can't even
> compile
> > (syntax problems) and is wrong (LONG types, etc..) and buggy. I'm sure
> no
> > one has tested it...
> >
>
> AFAIK there is no current oracle driver maintainer. Several people
> have fiddled with the code in the past, but at this time hardly anyone
> is able to even run the tests in lack of an Oracle installation. It
> may very well be true that the driver is broken. I can't verify this.
>
> regards,
> Markus
>
> --
> Markus Hoenicka
> markus.hoeni...@cats.de
> (Spam-protected email: replace the quadrupeds with "mhoenicka")
> http://www.mhoenicka.de
>
--
Vincent Rogier
------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel