[ZCM] [ZC] 50/ 4 Reject "DCO2 based ZOracle Adapter does not use bind variables"

[Collector: Zope Bugs, Features, and Patches ...]

Issue #50 Update (Reject) "DCO2 based ZOracle Adapter does not use bind variables"
 Status Rejected, Zope/feature critical
To followup, visit:
  http://zope.org/Collectors/Zope/50

==============================================================
= Reject - Entry #4 by chrisw on Jul 30, 2004 6:56 am

 Status: Deferred => Rejected

DCOracle2 is not part of the Zope core.

Please discuss on zope-db at zope.org.
________________________________________
= Defer - Entry #3 by matt on Nov 30, 2001 2:30 pm

 Status: Accepted => Deferred

This is very true *but* actually requires reworking parts of the core SQL methods to fix, ie the DA can't do it alone.

Its on the back burner at this time for resource allocation reasons.  However, Shai Berger may have a replacement set of SQL methods which do use binds.
________________________________________
= Assign - Entry #2 by matt on Nov 30, 2001 2:29 pm

 Status: Pending => Accepted

 Supporters added: matt


________________________________________
= Request - Entry #1 by dlkita on Nov 26, 2001 4:54 am

The current implementation of ZOracle DA based on DCO2 does not use bind variables when issuing queries to Oracle, causing the Oracle SGA to quickly fill up and degrading performance substantially since Oracle cannot use it's SQL caching features.

This only affets the DA, since DCO2 itself uses bind variables.

==============================================================