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

[Marc Portier]

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 :-)

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

regards,
-marc=


> On Tue, 2006-11-21 at 13:23 +0100, Marc Portier wrote:
>> just wanted to give the merged workflow stuff a spin
>>
>> - emptied/recreated the data_dirs en databases (daisyrepo and activemq)
>> - stepped through the README carefully...
>> - took all defaults
>>
>> When starting the repository I see an error
>>> "Data truncation: Out of range value adjusted for column 'ISTERMINATIONIMPLICIT_' at row 1"
>> occuring during the generation of the jbmp dataschema...
> <snip/>
> 

-- 
Marc Portier                            http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
Read my weblog at                http://blogs.cocoondev.org/mpo/
mpo at outerthought.org                              mpo at apache.org