[ebxmlms-develop] MSH v.0.9.3.0-sp1 / MySQL Bug

[Jean-Baptiste G. <jbg...@re...>]

Hi,

we are currently building an ebxml platform.
I'm interested in your project, as it seems to be an
excellent basis for our project.
So I'm currently evaluating it, in order to see if it fullfull
our requirements.

Using msh 0.9.3.0 / Tomcat 4.1.18 / MySQL 4.0
I had a error during msh initialization.
Here is the exact error msg :
"Cannot insert into database: New database connections created are invalid"

I had a look in DbConnectionPool.java :
the function isValid(Connection connection) cannot work under MysQL
as MySQL is case sensitive regarding table names.

So I changed "select distinct 1 from mshconfig" with
"select distinct 1 from MSHConfig" and it solved my problem.

Hope this helps...

By the way  : can we use the current version of MSH for production use
or is it to early as it seems to be alpha state ?

Tkx

jb