> --On 29. Juli 2005 22:22:38 +0200 Marcin Wudarczyk
> <[EMAIL PROTECTED]> wrote:
>
> > Andreas Jung wrote:
> >>> For the record: the overhead is about 40% on non-cached queries.r
> >>
> >> That's why were are using CCSQL methods :-)
> >
> > Not really - CCSQL caches results of the same query.
>
>
> I have a client using an Oracle 10.1.0 database server and I
> need to access that database from Zope. Which DA should I be using?
>
> mxODBC DA from egenix with and Oracle ODBC Driver (and if so
> what ODBC driver would people recommend)
>
> ZOracleDA
>
> DCOracle2
>
> or something else
let's say your DA 'instance' is located at
/Database/cx1
In your FS Product
code, you'd probably be able to get your hands on it like this:
self.Database.cx1
(This makes some very broad assumptions about how
your Product is structured, but hopefully it's a start for
you)
Personall
> When you do our own connection management, are you able to avoid
> DCOracle2 leaking connections? In our Zope
> 2.6.1/DCOracle2-1.3b server, we accumulate sessions where
> Oracle is waiting for a response from Zope, but Zope
> apparently thinks it closed that connection and opened a new
> one
for functions, you can do something like
select my_function_result() from dual
(assuming your function returns a scalar of some kind.)
for procedures, you can do the DCOracle2 Stored Procedure (might be
called ZOracleDA Stored Procedure in your install...)
OTOH I've found the procedure objec
