Hi,
I use the element <loader> in my mapping to call a sql-query that does a ST_ASTEXT(SHAPE).
My mapping is like that:
Code:
<class table="TMYTABLE" name="MyTable" lazy="false">
<id column="idTable" name="idTable" type="string">
[...]
</id>
<property column="shape" name="shape" type="string"/>
<property column="objectId" name="objectId" type="string"/>
<loader query-ref="loadMyTable"/>
</class>
<sql-query name="loadMyTable">
<return alias="myTable" class="MyTable" lock-mode="none"/>
SELECT ST_ASTEXT(SHAPE) AS {myTable.shape},
OBJECTID AS {myTable.objectId},
IDTABLE AS {myTable.idTable}
FROM TMYTABLE WHERE IDTABLE =?
</sql-query>
My problem is when I try to get my myTable pojo by objectId, the sql query retrieve SHAPE and not ST_ASTEXT(SHAPE).
The code is:
Code:
return (List) getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
Query query = session.createQuery("FROM MyTable myTable WHERE MyTable.idObject= :idObject");
query.setParameter("idObject", idObject, Hibernate.STRING);
return query.list();
}
});
Does anyone know how to retrieve correctly my object?
Actually I'll prefere not to write the all select statement as this mapping is a sample of the real mapping and there are more columns and relation between tables. There is a table TPARENT that have a one-to-many relation with this table. and this table has a many-to-one relation with another table which has also a "SHAPE" column.
thanks in advance
Login
FAQ
Search
