Re: Set connection to read only and back to writable?
- From: Tim.Bunce@xxxxxxxxx (Tim Bunce)
- Date: Tue, 18 Oct 2005 13:18:56 +0100
On Mon, Oct 17, 2005 at 06:11:53PM +0200, Gert wrote:
> Tim Bunce wrote:
>
> > On Fri, Oct 14, 2005 at 05:15:36PM +0200, Gert wrote:
>
> >> is it possible to switch a dbi-connection between read-only and writable?
> >
> > It's not a standard part of the DBI API, but it is possible with some
>
> Hmm, ok. If it is not a standard feature I can only use it while developing
> for debugging.
No, it just means that no database-independant API has been defined
so you'll need to use database-specific code.
> > drivers. Knowing which driver you're using might help us...
>
> It is mysql and perhaps Oracle.
Umm, now I come to look at it I see that mysql's "SET READ_ONLY=1"
command only works at the global level ("SET GLOBAL READ_ONLY=1")
and that's probably not what you want. I've no time to dig further.
Anyone know how a connection can be set to read-only in MySQL and/or Oracle?
Tim.
.
- Follow-Ups:
- Re[2]: Set connection to read only and back to writable?
- From: Wieland Pusch
- Re[2]: Set connection to read only and back to writable?
- References:
- Set connection to read only and back to writable?
- From: Gert
- Re: Set connection to read only and back to writable?
- From: Tim Bunce
- Re: Set connection to read only and back to writable?
- From: Gert
- Set connection to read only and back to writable?
- Prev by Date: RE: Oracle/DBI
- Next by Date: Re[2]: Set connection to read only and back to writable?
- Previous by thread: Re: Set connection to read only and back to writable?
- Next by thread: Re[2]: Set connection to read only and back to writable?
- Index(es):
Relevant Pages
|
|
