Hello all.
I am using hibernate 3.2.4 sp1,mysql5.0,jdk1.6,and mysql-connector-java-5.0.7.
When has not increased the joined-subclass fragment, this method can worked fine,after adding joined-subclass, presents the

following mistake(Below is the tomcat console output message).

Hibernate: select * from metadata as m where m.sort_id=? and m.city_id IN (select m2.city_id from metadata m2 where

m2.meta_id in (select t1.meta_id from tag t1 where t1.name in (?))) group by m.meta_id limit
03-26 17:37:44 INFO [http-80-1] (NullableType.java:182) - could not read column value from result set: clazz_; Column 'clazz_' not found.
03-26 17:37:44 WARN [http-80-1] (JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: S0022
03-26 17:37:44 ERROR [http-80-1] (JDBCExceptionReporter.java:78) - Column 'clazz_' not found.
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
.........


Caused by: java.sql.SQLException: Column 'clazz_' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:987)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2749)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:237)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:189)
at org.hibernate.loader.Loader.getInstanceClass(Loader.java:1442)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1284)
at org.hibernate.loader.Loader.getRow(Loader.java:1206)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
at org.hibernate.loader.Loader.doQuery(Loader.java:701)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 42 more



Hibernate version: 3.2.4.sp1

Mapping documents:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="net.yumt.model.Metadata" table="metadata">
<id name="metaId" type="java.lang.String">
<column name="meta_id" length="48" />
<generator class="uuid" />
</id>
<many-to-one name="sort" class="net.yumt.model.Sort" fetch="select" lazy="false">
<column name="sort_id" length="48" not-null="true" />
</many-to-one>
<many-to-one name="city" class="net.yumt.model.City" fetch="select" lazy="false">
<column name="city_id" length="48" />
</many-to-one>
<property name="title" type="java.lang.String">
<column name="title" />
</property>
<set name="tags" inverse="true">
<key>
<column name="meta_id" length="48" />
</key>
<one-to-many class="net.yumt.model.Tag" />
</set>


<joined-subclass name="net.yumt.model.Hotel" table="hotel">
<key column="meta_id"/>
<property name="ranking" type="java.lang.Integer">
<column name="ranking" />
</property>
<property name="address" type="java.lang.String">
<column name="address" />
</property>
<set name="rooms" inverse="true" cascade="all">
<key>
<column name="hotel_id" length="48"/>
</key>
<one-to-many class="net.yumt.model.Room" />
</set>
</joined-subclass>

<joined-subclass name="net.yumt.model.Room" table="room">
<key column="meta_id"/>
<property name="bed" type="java.lang.Integer">
<column name="bed" />
</property>
<many-to-one name="hotel" class="net.yumt.model.Hotel">
<column name="hotel_id" length="48" />
</many-to-one>
</joined-subclass>
</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():
StringBuffer sb = new StringBuffer();
sb.append("select * from metadata as m where");
if (!StringUtil.isNull(sortId)) {
sb.append(" m.sort_id=? and");
}
sb
.append(" m.city_id IN (select m2.city_id from metadata m2 where m2.meta_id in (select t1.meta_id from tag t1 where t1.name in (?))) group by m.meta_id");
SQLQuery sql = getSession().createSQLQuery(sb.toString()).addEntity(Metadata.class);

sb.delete(0, sb.length());
System.out.println(sb);
for (String t : tags) {
sb.append(t);
sb.append(",");
}
if (!StringUtil.isNull(sortId)) {
sql.setString(0, sortId);
sql.setString(1, sb.deleteCharAt(sb.length() - 1).toString());
} else {
sql.setString(0, sb.deleteCharAt(sb.length() - 1).toString());
}
if (perPage > 0) {
sql.setFirstResult((page - 1) * perPage);
sql.setMaxResults(perPage);
}


return sql.list();


Debug level Hibernate log excerpt:
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:366) - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:401) - select * from metadata as m where m.sort_id=? and m.city_id IN (select m2.city_id from metadata m2 where m2.meta_id in (select t1.meta_id from tag t1 where t1.name in (?))) group by m.meta_id limit ?
Hibernate: select * from metadata as m where m.sort_id=? and m.city_id IN (select m2.city_id from metadata m2 where m2.meta_id in (select t1.meta_id from tag t1 where t1.name in (?))) group by m.meta_id limit ?
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:484) - preparing statement
03-26 17:57:46 DEBUG [http-80-1] (NullableType.java:133) - binding '4' to parameter: 1
03-26 17:57:46 DEBUG [http-80-1] (NullableType.java:133) - binding 'Architecture' to parameter: 2
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:382) - about to open ResultSet (open ResultSets: 0, globally: 0)
03-26 17:57:46 DEBUG [http-80-1] (Loader.java:694) - processing result set
03-26 17:57:46 DEBUG [http-80-1] (Loader.java:699) - result set row: 0
03-26 17:57:46 DEBUG [http-80-1] (NullableType.java:172) - returning 'ff8080811762fafb01176cc63c750906' as column: meta_id
03-26 17:57:46 DEBUG [http-80-1] (Loader.java:1173) - result row: EntityKey[net.yumt.model.Metadata#ff8080811762fafb01176cc63c750906]
03-26 17:57:46 INFO [http-80-1] (NullableType.java:182) - could not read column value from result set: clazz_; Column 'clazz_' not found.
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:389) - about to close ResultSet (open ResultSets: 1, globally: 1)
03-26 17:57:46 DEBUG [http-80-1] (AbstractBatcher.java:374) - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
03-26 17:57:47 DEBUG [http-80-1] (AbstractBatcher.java:533) - closing statement
03-26 17:57:47 DEBUG [http-80-1] (JDBCExceptionReporter.java:69) - could not execute query [select * from metadata as m where m.sort_id=? and m.city_id IN (select m2.city_id from metadata m2 where m2.meta_id in (select t1.meta_id from tag t1 where t1.name in (?))) group by m.meta_id]
java.sql.SQLException: Column 'clazz_' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:987)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2749)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:237)




I has never add clazz_ to my object.It's grotesque.

btw:The generated SQL has been executed on mysql shell console.

I'm confused.has any inadequate configuration?

thanks.

I'm sorry to my english.

Can you check if you have a property mapped to field 'clazz_' ?

the "clazz_" has not been used never.the field "clazz_" generated by hibernate.so I'm confused.

If you have property='adsfa' column='clazz_', and there isn't a column named 'clazz_' in the database. That will cause this problem, I think.

to:lcbdl.thank you.
maybe you are not earnest to read my post message.my mapping file is posted above.
thanks again.

Similar problem here... Difference I use annotations and postgres 8.3. I'm trying to execute this SQL Query:


The thing is, I tested this SQL and it worked pretty well, but when trying to execute it with hibernate (code above), I got this exception:


I don't have any column called "clazz_", for sure. It seems that Hibernate is assuming that this column exists because I use a Joined Inheritance class. Here some code of the classes involved:

Class Procedimento:


Class PlanoProcedimento:


Class Plano:


Basically, Plano and Procedimento have a n-to-n relationship with extra attributes, and that's why I use the PlanoProcedimento class. Procedimento can be extended, and as I already sayed, this is done using Joined Inheritance. My mapping works well and that's the only problem I had till the moment.

Any ideas? Is this a bug? I'm doing something wrong? Any help will be appreciated! If any futher information is need, please let me know. And sorry for the bad english.

Thanks in advance,
Marcelo.

-------------------------
Brazil

Hi,
I'm referring to the original query at the beginning of this post. My question is: what exactly should return from the query? metadata entities? If so, change the query from:
select * from metadata m...
to
select m from metadata m...

let me know if it helped.

I'm having the same problem and hoping you found a solution to your problem after all this time. If so can you share with us what was done?

I'm also wondering what was done to get the debug output shown in the original post. I have log4j.logger.org.hibernate=DEBUG set in my log4.properties file, but I'm not seeing the same amount of information as you are and I'm having a hard time tracking down which column the error is against.

Thanks for any information you can provide.