Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ADO,ODBC and transaction
I think what he means by database independence is independence from any
non-Microsoft database.
Jim
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3d3c6602$0$8510$cc9e4d1f_at_news.dial.pipex.com...
> <rant>
> Then the simple solution is to create a one column table with a datatype
of
> number, lock the whole table and update it for each transaction. This is
> entirely database independent and doesn't even require changing the
> definition of the database across platforms.
> </rant>
>
> Your solution is already not database independent because you don't have
> triggers in access or autonumber in oracle. use the power of the platform.
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> "Sheridan" <gh_at_hakom.at> wrote in message
> news:EzV_8.3$Eh.163_at_stuart.coltnet.at...
> > Sorry, I have forgotton to explaine that I do not won't to use oracle
> > specific things like SET TRANSACTION LEVEL SERIALIZABLE
> > because our libraries should be independent from the used database.
> >
> > Therefore I want to use "SELECT Max(ID) FROM Table" in combination with
> the
> > isolation level to get the ID
> > because Access uses AutoValue to genarte an unique key
> > and Oracle use a trigger for that.
> >
> >
> >
> >
>
>
Received on Mon Jul 22 2002 - 23:45:42 CDT