Remy Maucherat wrote:
>
> > Indeed. Patch attached.
>
> I just applied it :) Thanks a lot !
Great. It's working well here, with half a dozen different roles.
>
> Sorry about the trouble.
> The other one is indeed temporarily dead (I think I'll remove it to avoid
> confusing people).
>
> The reason for having multiple JDBC stores is the compatibility problems in
> SQL with the advanced types (varchar, ....). I'm not a database guru, so the
> only thing I could come up with is a hSQL ready JDBC store. Apparently, it
> doesn't work with mySQL, and probably others.
I see. We have it working with mySQL, by the way - it's a bit ugly, but
we just create the database and tables before letting slide touch it,
then slide populates the tables as normal.
We just replace the varchars (which mysql limits in size) with blobs.
Probably fairly inefficient, but it does the job, and we don't need to
change any of the slide code, since other than the create tables,
nothing specifically references the type of the variables.
Michael
