Hi,

I couple of days I downloaded a cvs snapshot of hibernate 3.0
The reason I did this was because I wanted to use the improved
startup code (serialized mapping documents) in order
to reduce the startup time in my program.

I changed few lines in the source code in order to have hibernate
generate and load serialized mapping files. Please note that these
changes did not trigger the following bug, which also occurs with
the original sources:

When loading my ressources hibernate generates a faulty SQL
statement. The errors lies in a missing comma in the select
statement before a "case when". I am using MySQL 4.0.18.

This is generated:

"select ressourcec0_.id as id0_case when....."

Should probably be:

"select ressourcec0_.id as id0_, case when....."

As I cannot influence the generated sql, I don't think it's a user
error. I could work around the error by "hacking" the
SelectFragment.java source:

public String toFragmentString() {

.....

if (extraSelectList!=null) {
// if ( columns.size()>0 ) // !!I added the comment!!
buf.append(", ");
buf.append(extraSelectList);
}
return buf.toString();
}

As I am new to this forum, please advise me how to report this
possible bug.

Bernd

submit a testcae to JIRA that reproduces the problem.

thanks for reporting it.

Ok,
I will isolate the bug and post some source to JIRA.

Bernd

Did the JIRA entry now.
If the form is not appropriate please correct me.

Bernd