Hibernate/Spring/Jboss Annotations + Entity Mapping problems

[Bal Mark]

Hi All,

Hopefully someone can help with my problem, I'll give some detailed info below, but the summary is

I'm trying to map an Entity class to a property in another Entity, and I'm not having much luck, there's no error when jboss starts up, but when I try a hql query for example, I get an error 'could not resolve property'

in my applicationContext.xml I have

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property>
        <property name="url"><value>jdbc:mysql://192.168.0.252:3306/mydatab</value></property>
        <property name="username"><value>root</value></property>
        <property name="password"><value>password</value></property>
   </bean>

    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource"><ref local="dataSource"/></property>
        <property name="hibernateProperties">
			<props>
				<prop key="hibernate.query.substitutions">true 1, false 0</prop>			
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<!-- <prop key="hibernate.hbm2ddl.auto">create</prop> -->
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.c3p0.min_size">5</prop>
				<prop key="hibernate.c3p0.max_size">20</prop>
				<prop key="hibernate.c3p0.timeout">1800</prop>
				<prop key="hibernate.c3p0.max_statements">50</prop>
		        <prop key="hibernate.connection.pool_size">10</prop>
			</props>
		</property>
    	
		<property name="packagesToScan">
			<list>
				<value>com.mypackage.**.*</value>
			</list>
		</property>
		<property name="annotatedClasses">
			<list>
			<value>com.mypackage.Device</value>
			<value>com.mypackage.MySession</value>
			</list>
		</property>
    </bean>
	
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory">
			<ref local="sessionFactory" />
		</property>
	</bean>	
	
    <bean id="hibernateInterceptor"
        class="org.springframework.orm.hibernate3.HibernateInterceptor"
        autowire="byName" />

This is fine, seems to pickup the classes

my classes are more or less

Device.java ->

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Embeddable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
//@Embeddable
@Table(name="device")
public class Device implements Serializable{
	public static final long serialVersionUID = 1l;

	@Id
        @GeneratedValue(strategy=GenerationType.AUTO)
        private Integer id;
	
	@Column(name="guid")
	private String guid;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getGuid() {
		return guid;
	}

	public void setGuid(String guid) {
		this.guid = guid;
	}
}

and

MySession.java

import java.io.Serializable;
import java.sql.Timestamp;

import javax.persistence.Column;
import javax.persistence.Embedded;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToOne;
import javax.persistence.Table;
import javax.persistence.Transient;

import org.hibernate.annotations.Target;
import org.hibernate.annotations.Type;


@Entity
@Table(name="my_sessions")
public class MySession implements Serializable{
	public static final long serialVersionUID = 1l;

	@Id
        @GeneratedValue(strategy=GenerationType.AUTO)
        private Integer id;
	
	private Device device = null;
	
	@Column(name="session_id")
	private int sessionId = -1;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	
	public void setSessionId(int sessionId){
		this.sessionId = sessionId;
	}
	public int getSessionId(){
		return sessionId;
	}

	@ManyToOne(fetch=FetchType.EAGER, targetEntity=Device.class)
	@JoinColumn(name="device_id")
	public Device getDevice(){
		return device;
	}
	
	public void setDevice(Device device){
		this.device = device;
	}
}

the fields in the tables are
my_session ->
int id
int device_id
int session_id

device ->
int id
varchar guid


I tried using @Embedded for getDevice in the MySession class, but on queries it complained with something similar to 'cannot find column in field list' and the sql that was generated wasn't doing any join on the devices table, it was looking for device_id in the MySession's table.

When I try to do

    ses = getSessionFactory().openSession();
    Query q = ses.createQuery("from MySession where device.guid = :guid");
    q.setString("guid", guid);
			
    MySession mySession = (MySession)q.uniqueResult();
			

it fails on the createQuery with

11:36:53,070 ERROR [STDERR] org.hibernate.QueryException: could not resolve property: guid of: com.mypackage.MySession [from com.mypackage.MySession where device.guid = :guid]
        at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
        at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
        at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
        at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:302)
        at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:407)
        at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:589)
        at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:264)
        at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:211)
        at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117)
        at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113)
        at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:750)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3525)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
        at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
        at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
        at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
        at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
        at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
        at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
        at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)

Thanks for reading this far, and hopefully you can help ;)
I'm trying to avoid any hbm.xml files (migrating away from all that at the moment) and hoping to use pure annotations

hmm what I'm basically trying to do with Annotations what you could do with

within MySession.hbm.xml ->

	<many-to-one class="com.mypackage.Device" column="device_id" lazy="false" name="device"/>

Do if I did a hql query "from MySession where device.guid = 'testguid' " ... it would return me the MySession with the Device that has guid = 'testguid'


Kindest regards

Bal

[Bal Mark]

Am I way off the mark?

Should I be using @Embedded or just a simple

@Column(name="device_id")
Device device = null;

and my problem lies elsewhere?

Wondering if it's some combination of incompatible jars

Am I wrong in thinking I can do this all through javax.persistence Annotations and settings the annotationclasses in the sessionFactory?

I could really use a few pointers .. so far swapping jars in /jboss/common/lib out and replacing with latest from the 3.6.5-final dist package has made no difference

[Bal Mark]

Using

    @Column(name="device_id")
    public Device getDevice(){
        return device;
    }

I get the error

13:50:55,852 ERROR [STDERR] org.hibernate.QueryException: could not resolve property: guid of: com.mypackage.MySession [from com.mypackage.MySession where device.guid = :guid]

I'd have expected it to say, if it couldnt find the property guid, to complain about not finding it in the Device object, not the MySession object

[Bal Mark]

Right so ..

Turns out its all down to where Iw as putting my annotations,
I thought it'd be ok to put them around the variables or getters or mix and match

but to get it working,

I moved all the @Column annotations before the getters.. hey presto .. works ;)

the

	@ManyToOne(fetch=FetchType.EAGER, targetEntity=Device.class)
	@JoinColumn(name="device_id")
	public Device getDevice(){
		return device;
	}
	

with

		ses = getSessionFactory().openSession();
		Query q = null;
		q = ses.createQuery("from MySession where device.guid = :guid");
		q.setString("guid", guid);
		MySession mySession = (MySession)q.uniqueResult();

works