offtopic question

[Vilavanh Messien <vi...@agora.ulaval.ca>]

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

Conext root on atg

[Joachim Gjesdal <jo...@ecomda.de>]

Running struts 1.0 on Atg Dynamo 5.1 w/patch 1.1.p2

the context root (myroot) is added twice when the html is written:

I.e.
<html:form action="myaction.do"> is written as : <form name="myForm"
method="POST" action="/myroot/myroot/myaction.do">
or
<html:img page="/images/spacer.gif"/> is written as:  <img
src="/myroot/myroot/images/loginpage_password.gif">

This does not happen in Tomcat, only in Dynamo, has anyone seen this?

thanks,
joachim

RE: offtopic question

[Renzo Toma <re...@xs4all.nl>]

You're right:

MySQL does not have transactional support and does only do table locking (no
row-locking like the big boys).

-----Original Message-----
From: Aapo Laakkonen [mailto:aapo.laakkonen@projectcast.com]
Sent: woensdag 11 juli 2001 18:45
To: struts-user@jakarta.apache.org; vilavanh.messien.1@agora.ulaval.ca
Subject: Re: offtopic question


> message: transaction isolation levels not supported.
>
> That let me suppose that both MS Access and MySql jdbc drivers do not
> support yet well the rowset package.

I think that access and mysql doesn't support transactions or they do not
support
the isolation level that was requested by your application. ANSI SQL defines
4
isolation levels and if application wants to have let's say committed read
isolation
level and db doesn't support it or doens't support higher isolation levels
(e.g.
repeatable read or serializable) then they need to abort the transaction.
Access is
kind of one man db and it doesn't support transactions I think, but I'm not
sure
about MySQL, but what I can remember is that it doesn't support
transactions.

Re: offtopic question

[Aapo Laakkonen <aa...@projectcast.com>]

> message: transaction isolation levels not supported.
>
> That let me suppose that both MS Access and MySql jdbc drivers do not
> support yet well the rowset package.

I think that access and mysql doesn't support transactions or they do not
support
the isolation level that was requested by your application. ANSI SQL defines
4
isolation levels and if application wants to have let's say committed read
isolation
level and db doesn't support it or doens't support higher isolation levels
(e.g.
repeatable read or serializable) then they need to abort the transaction.
Access is
kind of one man db and it doesn't support transactions I think, but I'm not
sure
about MySQL, but what I can remember is that it doesn't support
transactions.

Re: offtopic question

[David Winterfeldt <dw...@yahoo.com>]

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
<vi...@agora.ulaval.ca> 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/