hi!
we have used postgresql for some projects and it worked.
the only drawback we had is the fact that the current
version does not handle large row data.
that means a the data length of a row cannot be longer
than 32k. if you need to store large objects you have to
put them onto the filesystem. this limitation is said to be removed
in the next version of postgresql.
yours,
lars
> 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
