[daisy] jbpm causes sql error when launching repo 2.0-dev

[Bruno Dumon]

On Wed, 2006-11-22 at 09:33 +0100, Marc Portier wrote:
> 
> Bruno Dumon wrote:
> > If you were using MySQL 4.1 before, check your myconfig.xml (I'm
> > assuming it's a dev setup, thus in repository/server/myconfig.xml) to
> > see if the URL is correct:
> > 
> > <url>jdbc:mysql://localhost/daisyrepository?characterEncoding=UTF-8</url>
> > 
> > More specifically, the "useServerPrepStmts=false" should *not* be in
> > there.
> > 
> > This is probably not mentioned in the README.txt, and I see the template
> > myconfig.xml doesn't contain the characterEncoding parameter yet either.
> > 
> > Looking forward to hear if this was the problem.
> > 
> 
> actually it was the solution :-)

OK, I should look into updating the README then.

> 
> and to be more precise: one of the solutions, by the time I read your
> answer I also tried by just upgrading the mysql connector/j (jdbc
> driver) -->  most recent one is 5.0.4 (fyi: they skipped from 3.1.15
> right to 5.0.0-beta, probably to align numbers with the server version)
> 
> but I did revert all changes I made and gave your suggestion a try as
> well, and can verify it is a valid answer to the issue.
> 
> for my personal environment I'm settling for the combination of both
> (using server side prepared statements should be better now that they
> seem to work, and upgrading to the latest released connector doesn't
> sound like a bad habit either)
> 
> makes me wonder though if someone should be trying out which connector
> param-settings/version combo works best on mysql 4.1

The current driver version and connection parameter settings have been
chosen exactly to work on both 4.1 and 5. Of course, this was done some
time ago, it might be good to do an update of this.

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org