Hi,
    If I use EJB, can I use postgresql?  I know that postgresql jdbc driver
is still not jdbc2 complaint.


Louis
----- Original Message -----
From: "Lars Hoss" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Wednesday, November 15, 2000 8:37 AM
Subject: Re: Problems with MySQL and DataSourceUserManager


> hi!
>
> i had the same problem with the WebLogic Server.
> the problem is that MySQL does not support transactions
> as of version 2.22.x.
> there is beta quality transaction support in the
> current development branch (2.23.x) but
> i had very serious problems with the latest version (lost data).
> personally i advice you not to use mysql until
> it is ready for production use. i would have a look
> at the 7.1 version of postgresql which is currently
> available through cvs as far as i know.
>
> yours,
> lars
>
> Am Mittwoch 15 November 2000 12:22 schrieben Sie:
> > Hi
> >
> > Is anyone using DataSourceUserManager with MySQL database?
> > We have been using it with PostgreSQL without any problems,
> > but when we switched to MySQL, DataSourceUserManager throws
> > an exception
> >
> > DataSourceUserManager.getUser
> >
> > 8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
> > java.lang.RuntimeException: SQLException: Can't call commit when
> > autocommit=true
> > at com.evermind.sql.DataSourceUserManager.getUser(JAX)
> > at com.evermind.server.http.EvermindHttpServletRequest.yf(JAX)
> > at com.evermind.server.http.HttpApplication.vk(JAX)
> > at com.evermind.server.http.HttpApplication.uh(JAX)
> > at com.evermind.server.http.ed.sp(JAX)
> > at com.evermind.server.http.ed.so(JAX)
> > at com.evermind.util.f.run(JAX)
> >
> >
> > Is it possible to use MySQL with DataSourceUserManager since MySQL does
not
> > support transactions?
> >
> > Regards,
> > Juha Lehtonen
> > FA Solutions
>


Reply via email to