I don't think MS Access and MySql support the
transaction levels that a CachedRowSet needs. I know
that MS Access can't support EJBs for this reason.
David
--- Vilavanh Messien
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am currently building a web application with
> Struts and I am facing the
> following problem.
> I am using the CachedRowSet class to retrieve data
> from my database.
> Actually, I have no trouble when I perform a SELECT
> query. However, when I
> perform an UPDATE, DELETE or INSERT query, I get the
> following error
> message: transaction isolation levels not supported.
>
> This exception seems to be thrown only with MS
> Access and MySql databases.
> With Oracle, no exception is thrown and everything
> seems to work fine ...
>
> That let me suppose that both MS Access and MySql
> jdbc drivers do not
> support yet well the rowset package. Has anyone ever
> had such experience of
> this issue ? or could anyone give me some
> explanations ?
>
> Thanks in advance,
>
> Vilavanh Messien
>
>
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
