apr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Donovan <donov...@bellatlantic.net>
Subject Re: sqlite3 dbd provider question
Date Mon, 19 May 2008 21:38:34 GMT
William A. Rowe, Jr. wrote:
> Tom Donovan wrote:
>>> And a related question, any prepared statement can be portably used 
>>> across
>>> any of the databases open within the specific provider.  Correct?
>>
>> In general no. Most databases consider a prepared statement to be 
>> associated with a single database. This would seldom make sense, but 
>> if both databases happen to have the same table names and field names, 
>> a SQL statement could be valid for two databases - so a database 
>> vendor could choose to allow this.  I think Oracle might allow this - 
>> but I have never tried it.
> 
> Then if we consider this non-portable, the prepared statement cache
> certainly should not be a static, but scoped per apr_dbd_t?
> 
> I would prefer we /not/ offer dbd specific features, as the hacks around
> the initial row offset illustrate we contribute to per-platform hackery
> instead of resolving it for the user.
> 
> Bill
> 
I don't quite follow you here.

  Are you referring to the Oracle dbd driver prepared-statement cache?

-tom-


Mime
View raw message