Philippe Durieux wrote:
> Dmitry Melekhov wrote:
> >
> > Philippe Durieux wrote:
> > >
> > > JOnAS 1.5 is available on the web site (http://www.bullsoft.com/ejb)
> > >
> > > You can now choose between 3 tar files:
> > > - jonas source code
> > > - jonas binary distribution for JDK 1.2
> > > - jonas binary distribution for JDK 1.1
> >
> > Still there is problem with transactions :(
> > Still set chained not allowed with Sybase.
> > Is it too hard to add commit call?
> > Other servers like Oracle or MS SQL do commit,
> > when changin autocommit state, Sybase not!!!
> The problem is that if you add a commit here, it will probably
> work for Sybase, but I guess it will not work for other databases.
> It seems not a good thing to do a commit with no current transaction, or
No current transaction? Hmm,
if so, I don't know such rdbms...
But I know at least one database,
which don't commit transaction on changin
autocommit state...
In faq you wrote, that JOnAS is tested with Sybase!
Why not write in faq about this problem with Sybase?
>
> with a transaction that may be rolled back later! The driver is not the right place
> to decide for commiting the transaction.
Transaction can't be rolled back, if we change AutoCommit state.
Again, Oracle and MS SQL _do_ commit in this case,
I can send you examples, if you don't belive ;))
>
> > There id little bug in transaction management,
> > if you can't find it ( I can't :) ) why
> > not produce workaround?
> Could you tell me what the bug is exactly ??? If I knew it, I could try to fix it
> or to produce a workaround...
Bug is that JOnAS try to change autocommit state
on not commited transaction. You can't see this,
because oracle commit previuos transaction.
>
> > Well, now I downloading source :((
> Good luck!
> >
OK. I send patch to this mail list about week ago.
Is there anybody, who can try it with other
(not Sybase ASE) rdbms?
--
Dmitry Melekhov
http://www.aspec.ru/~dm
2:5050/11.23@fidonet
