> To: Zope-DB@zope.org
> Subject: [Zope-DB] Returning values from Oracle
> function/procedure withZSQLMethod
>
> Hi
>
> I'm using DCOracle2 to connect to Oracle databases, but I
> think that moving to SQLRelay may be a good idea. I haven't
> tried it yet
Quoting Jim Abramson <[EMAIL PROTECTED]>:
> In our experience we ended up needing to do increasingly complex
> things with plsql, and ultimately, we had no choice to move all our
> db access out into ExternalMethods or Products and use DCOracle2
> directly. This does require constructing your own
> for functions, you can do something like
> select my_function_result() from dual
> (assuming your function returns a scalar of some kind.)/
/
Thank you. I think that 'dual' will solve few my problems. I'm not an
oracle developer so I didn't know about this method. Really strange
Chris Withers's branch of DCOracle2 has some changes that help the
connection pooling problem.
The issue basically is that the Zope adapter for DCOracle2 is fairly
old and crusty. I think Jim's correct when he suggests doing your own
pool management from a module.
All that the DA is supposed
Matthew T. Kromer wrote:
Chris Withers's branch of DCOracle2 has some changes that help the
connection pooling problem.
The issue basically is that the Zope adapter for DCOracle2 is fairly old
and crusty. I think Jim's correct when he suggests doing your own pool
management from a module.
All
Hi Cynthia,
Cynthia Kiser wrote:
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
Matthew T. Kromer wrote:
Chris Withers's branch of DCOracle2 has some changes that help the
connection pooling problem.
And rumour has it I'm going to get some serious time to work on this
soon! Matt, you up for fixing any C-level bugs that crawl out of the
woodwork?
You can also consider using
Chris Withers wrote:
> Matthew T. Kromer wrote:
>
>> Chris Withers's branch of DCOracle2 has some changes that help the
>> connection pooling problem.
>
>
> And rumour has it I'm going to get some serious time to work on this
> soon! Matt, you up for fixing any C-level bugs that crawl out of the
M.-A. Lemburg wrote:
This is a no-go if your Oracle people go "huh? ODBC? that's deprecated
rubbish and you ain't using it" ;-)
Depends on what people you're talking to, I guess...
Oracle DBA's who know a helluva lot more than me about Oracle ;-)
Why are they saying ODBC is deprecated? Is it? Is AD
Chris Withers wrote:
> M.-A. Lemburg wrote:
>
>>> This is a no-go if your Oracle people go "huh? ODBC? that's deprecated
>>> rubbish and you ain't using it" ;-)
>>
>>
>> Depends on what people you're talking to, I guess...
>
>
> Oracle DBA's who know a helluva lot more than me about Oracle ;-)
>
M.-A. Lemburg wrote:
Not sure why they think that ODBC is deprecated - Oracle
is happily working on their ODBC driver and it's one
of the best bets you can find out there:
http://www.oracle.com/technology/software/tech/windows/odbc/index.html
Interesting, but people here, even M$ people, haven't
Chris Withers wrote:
> M.-A. Lemburg wrote:
>
>> Not sure why they think that ODBC is deprecated - Oracle
>> is happily working on their ODBC driver and it's one
>> of the best bets you can find out there:
>>
>>http://www.oracle.com/technology/software/tech/windows/odbc/index.html
>
>
> Inte
On Apr 19, 2005, at 4:24 AM, Chris Withers wrote:
Matthew T. Kromer wrote:
Chris Withers's branch of DCOracle2 has some changes that help the
connection pooling problem.
And rumour has it I'm going to get some serious time to work on this
soon! Matt, you up for fixing any C-level bugs that crawl
M.-A. Lemburg wrote:
Would a native Oracle interface help ?
Yeah, and that's what DCOracle2 is, right?
Nope.
Huh? I think you need to provide a little more information there...
If you're telling me you have a real live decent quality native oracle
interface, then I'm all ears :-)
We're considering
Matthew T. Kromer wrote:
And rumour has it I'm going to get some serious time to work on this
soon! Matt, you up for fixing any C-level bugs that crawl out of the
woodwork?
Bugfixing, sure... :)
How about a re-write so it's all squeeky clean? ;-)
Chris
--
Simplistix - Content Management, Zope &
Chris Withers wrote:
> M.-A. Lemburg wrote:
>
Would a native Oracle interface help ?
>>>
>>>
>>> Yeah, and that's what DCOracle2 is, right?
>>
>>
>> Nope.
>
>
> Huh? I think you need to provide a little more information there...
Sorry, I meant that the "native Oracle interface" is not DCOr
M.-A. Lemburg wrote:
Huh? I think you need to provide a little more information there...
Sorry, I meant that the "native Oracle interface" is not DCOracle2,
hinting that at the project I mentioned below.
right, but DCOracle2 is *A* native oracle interface, right?
We're considering working on one o
Chris Withers wrote:
> M.-A. Lemburg wrote:
>
>>> Huh? I think you need to provide a little more information there...
>>
>>
>>
>> Sorry, I meant that the "native Oracle interface" is not DCOracle2,
>> hinting that at the project I mentioned below.
>
> right, but DCOracle2 is *A* native oracle int
M.-A. Lemburg wrote:
We won't have anything ready in the next three months;
that much I can tell you.
If you make DCOracle2 stable enough to use as low-level
interface, we might even consider using DCOracle2 for
the Zope DA, so we wouldn't want to hold you off on fixing
issues in DCOracle2 :-)
Heh,
Chris Withers wrote:
> M.-A. Lemburg wrote:
>
>> We won't have anything ready in the next three months;
>> that much I can tell you.
>>
>> If you make DCOracle2 stable enough to use as low-level
>> interface, we might even consider using DCOracle2 for
>> the Zope DA, so we wouldn't want to hold yo
20 matches
Mail list logo
