Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-22 Thread M.-A. Lemburg
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 interface, right? No

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-21 Thread Matthew T. Kromer
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

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-21 Thread Chris Withers
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

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-20 Thread Chris Withers
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,

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-19 Thread Chris Withers
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

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-13 Thread M.-A. Lemburg
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.

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-12 Thread Matthew T. Kromer
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

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-08 Thread Cynthia Kiser
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