my query looks like:
select a.ID, a.xxx, a.yyy,... from A as a where a.name like 'x%'

a.ID should retrieve values from id-column.

my problem is that the value for ID is the same (1) in all returned Object[] in list all others ar right. so how can I retrieve the values from id-column?

Mapping:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.carano.cbf.partner.po.GeschaeftspartnerPO" table ="G_PARTNER">
<jcs-cache usage="read-write"/>
<id name="ID">
<column name="G_PARTNER_ID" sql-type="int"/>
<generator class="com.media_saturn.framework.abo.persistence.hibernate.HibernateIDGenerator"/>
</id>
<property name="debitorenNr">
<column name="DEBITOREN_NR" sql-type="int"/>
</property>
<property name="kreditorenNr">
<column name="KREDITOREN_NR" sql-type="int"/>
</property>

</class>
</hibernate-mapping>

why don't you call
from A as a where a.name like 'x%'

and verify how your objects are filled?


Anthony

because i don't want to retrieve full object but only some properties of it. It's works right if I retrieve the full object

i think id is a protected work try renaming it

try using .id in the query instead of .ID

that doesnt't change anything, still the same id 1 is returned, it is not the same Long object but the same value.

I compared behaviour of scalar and non scalar search:

It seems to be that my scalar search works if I pass some parameters, than returned ids are different. but if there is no parameter it is always the same id.

here is the logfile:

###
### non scalar search with a parameter:
###

DEBUG[net.sf.hibernate.hql.QueryTranslator] HQL: SELECT GeschaeftspartnerPO
FROM
com.carano.cbf.partner.po.GeschaeftspartnerPO AS GeschaeftspartnerPO,
com.carano.cbf.partner.po.AdressePO AS adresse
WHERE
GeschaeftspartnerPO.adresse = adresse.ID AND
( adresse.name LIKE 'test%')
DEBUG[net.sf.hibernate.hql.QueryTranslator] SQL: select geschaefts0_.G_PARTNER_ID as G_PARTNE1_, geschaefts0_.KONZERN_ID as KONZERN_ID, geschaefts0_.MANDANTEN_NR_ID as MANDANTE3_, geschaefts0_.RECHTSFORM_ID as RECHTSFO4_, geschaefts0_.GP_STATUS_ID as GP_STATU5_, geschaefts0_.GP_ROLLE_ID as GP_ROLLE6_, geschaefts0_.GP_WIRT_BEZ_ID as GP_WIRT_7_, geschaefts0_.DEBITOREN_NR as DEBITORE8_, geschaefts0_.KREDITOREN_NR as KREDITOR9_, geschaefts0_.KUNDEN_NR as KUNDEN_NR, geschaefts0_.KENN_NR as KENN_NR, geschaefts0_.VERSICH_NR as VERSICH_NR, geschaefts0_.ADRESSE_ID as ADRESSE_ID, geschaefts0_.VERKAUFSLEITER_ID as VERKAUF14_, geschaefts0_.KUNDENBETREUER_ID as KUNDENB15_, geschaefts0_.MITARBEITER_ID as MITARBE16_, geschaefts0_.MITARB_ID_INS as MITARB_17_, geschaefts0_.MITARB_ID_UPD as MITARB_18_, geschaefts0_.TS_INSERT as TS_INSERT, geschaefts0_.TS_UPDATE as TS_UPDATE from G_PARTNER geschaefts0_, ADRESSE adressepo1_ where (geschaefts0_.ADRESSE_ID=adressepo1_.ADRESSE_ID )AND((adressepo1_.NAME LIKE 'test%' ))
DEBUG[net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
DEBUG[net.sf.hibernate.connection.DriverManagerConnectionProvider] total checked-out connections: 0
DEBUG[net.sf.hibernate.connection.DriverManagerConnectionProvider] using pooled JDBC connection, pool size: 0
DEBUG[net.sf.hibernate.SQL] select geschaefts0_.G_PARTNER_ID as G_PARTNE1_, geschaefts0_.KONZERN_ID as KONZERN_ID, geschaefts0_.MANDANTEN_NR_ID as MANDANTE3_, geschaefts0_.RECHTSFORM_ID as RECHTSFO4_, geschaefts0_.GP_STATUS_ID as GP_STATU5_, geschaefts0_.GP_ROLLE_ID as GP_ROLLE6_, geschaefts0_.GP_WIRT_BEZ_ID as GP_WIRT_7_, geschaefts0_.DEBITOREN_NR as DEBITORE8_, geschaefts0_.KREDITOREN_NR as KREDITOR9_, geschaefts0_.KUNDEN_NR as KUNDEN_NR, geschaefts0_.KENN_NR as KENN_NR, geschaefts0_.VERSICH_NR as VERSICH_NR, geschaefts0_.ADRESSE_ID as ADRESSE_ID, geschaefts0_.VERKAUFSLEITER_ID as VERKAUF14_, geschaefts0_.KUNDENBETREUER_ID as KUNDENB15_, geschaefts0_.MITARBEITER_ID as MITARBE16_, geschaefts0_.MITARB_ID_INS as MITARB_17_, geschaefts0_.MITARB_ID_UPD as MITARB_18_, geschaefts0_.TS_INSERT as TS_INSERT, geschaefts0_.TS_UPDATE as TS_UPDATE from G_PARTNER geschaefts0_, ADRESSE adressepo1_ where (geschaefts0_.ADRESSE_ID=adressepo1_.ADRESSE_ID )AND((adressepo1_.NAME LIKE 'test%' ))
DEBUG[net.sf.hibernate.impl.BatcherImpl] preparing statement
DEBUG[net.sf.hibernate.loader.Loader] processing result set
DEBUG[net.sf.hibernate.type.LongType] returning '10307102' as column: G_PARTNE1_
DEBUG[net.sf.hibernate.loader.Loader] result row: 10307102
DEBUG[net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 10307102
DEBUG[net.sf.hibernate.loader.Loader] Hydrating entity: com.carano.cbf.partner.po.GeschaeftspartnerPO#10307102
DEBUG[net.sf.hibernate.type.LongType] returning null as column: KONZERN_ID
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MANDANTE3_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: RECHTSFO4_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: GP_STATU5_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: GP_ROLLE6_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: GP_WIRT_7_
DEBUG[net.sf.hibernate.type.IntegerType] returning '1839' as column: DEBITORE8_
DEBUG[net.sf.hibernate.type.IntegerType] returning null as column: KREDITOR9_
DEBUG[net.sf.hibernate.type.IntegerType] returning null as column: KUNDEN_NR
DEBUG[net.sf.hibernate.type.StringType] returning null as column: KENN_NR
DEBUG[net.sf.hibernate.type.StringType] returning null as column: VERSICH_NR
DEBUG[net.sf.hibernate.type.LongType] returning '8547' as column: ADRESSE_ID
DEBUG[net.sf.hibernate.type.LongType] returning null as column: VERKAUF14_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: KUNDENB15_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MITARBE16_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MITARB_17_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MITARB_18_
DEBUG[net.sf.hibernate.type.TimestampType] returning '27 Oktober 1997 19:17:08' as column: TS_INSERT
DEBUG[net.sf.hibernate.type.TimestampType] returning '27 Oktober 1997 20:00:04' as column: TS_UPDATE
DEBUG[net.sf.hibernate.type.LongType] returning '1010344801' as column: G_PARTNE1_
DEBUG[net.sf.hibernate.loader.Loader] result row: 1010344801
DEBUG[net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 1010344801
DEBUG[net.sf.hibernate.loader.Loader] Hydrating entity: com.carano.cbf.partner.po.GeschaeftspartnerPO#1010344801
DEBUG[net.sf.hibernate.type.LongType] returning null as column: KONZERN_ID
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MANDANTE3_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: RECHTSFO4_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: GP_STATU5_




###
### non scalar search without a parameter:
###

DEBUG[net.sf.hibernate.impl.SessionImpl] find: SELECT GeschaeftspartnerPO
FROM
com.carano.cbf.partner.po.GeschaeftspartnerPO AS GeschaeftspartnerPO
DEBUG[net.sf.hibernate.engine.QueryParameters] named parameters: {}
DEBUG[net.sf.hibernate.hql.QueryTranslator] compiling query
DEBUG[net.sf.hibernate.impl.SessionImpl] flushing session
DEBUG[net.sf.hibernate.impl.SessionImpl] Flushing entities and processing referenced collections
DEBUG[net.sf.hibernate.impl.SessionImpl] Processing unreferenced collections
DEBUG[net.sf.hibernate.impl.SessionImpl] Scheduling collection removes/(re)creates/updates
DEBUG[net.sf.hibernate.impl.SessionImpl] Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
DEBUG[net.sf.hibernate.impl.SessionImpl] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
DEBUG[net.sf.hibernate.impl.SessionImpl] Dont need to execute flush
DEBUG[net.sf.hibernate.hql.QueryTranslator] HQL: SELECT GeschaeftspartnerPO
FROM
com.carano.cbf.partner.po.GeschaeftspartnerPO AS GeschaeftspartnerPO
DEBUG[net.sf.hibernate.hql.QueryTranslator] SQL: select geschaefts0_.G_PARTNER_ID as G_PARTNE1_, geschaefts0_.KONZERN_ID as KONZERN_ID, geschaefts0_.MANDANTEN_NR_ID as MANDANTE3_, geschaefts0_.RECHTSFORM_ID as RECHTSFO4_, geschaefts0_.GP_STATUS_ID as GP_STATU5_, geschaefts0_.GP_ROLLE_ID as GP_ROLLE6_, geschaefts0_.GP_WIRT_BEZ_ID as GP_WIRT_7_, geschaefts0_.DEBITOREN_NR as DEBITORE8_, geschaefts0_.KREDITOREN_NR as KREDITOR9_, geschaefts0_.KUNDEN_NR as KUNDEN_NR, geschaefts0_.KENN_NR as KENN_NR, geschaefts0_.VERSICH_NR as VERSICH_NR, geschaefts0_.ADRESSE_ID as ADRESSE_ID, geschaefts0_.VERKAUFSLEITER_ID as VERKAUF14_, geschaefts0_.KUNDENBETREUER_ID as KUNDENB15_, geschaefts0_.MITARBEITER_ID as MITARBE16_, geschaefts0_.MITARB_ID_INS as MITARB_17_, geschaefts0_.MITARB_ID_UPD as MITARB_18_, geschaefts0_.TS_INSERT as TS_INSERT, geschaefts0_.TS_UPDATE as TS_UPDATE from G_PARTNER geschaefts0_
DEBUG[net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
DEBUG[net.sf.hibernate.connection.DriverManagerConnectionProvider] total checked-out connections: 0
DEBUG[net.sf.hibernate.connection.DriverManagerConnectionProvider] using pooled JDBC connection, pool size: 0
DEBUG[net.sf.hibernate.SQL] select geschaefts0_.G_PARTNER_ID as G_PARTNE1_, geschaefts0_.KONZERN_ID as KONZERN_ID, geschaefts0_.MANDANTEN_NR_ID as MANDANTE3_, geschaefts0_.RECHTSFORM_ID as RECHTSFO4_, geschaefts0_.GP_STATUS_ID as GP_STATU5_, geschaefts0_.GP_ROLLE_ID as GP_ROLLE6_, geschaefts0_.GP_WIRT_BEZ_ID as GP_WIRT_7_, geschaefts0_.DEBITOREN_NR as DEBITORE8_, geschaefts0_.KREDITOREN_NR as KREDITOR9_, geschaefts0_.KUNDEN_NR as KUNDEN_NR, geschaefts0_.KENN_NR as KENN_NR, geschaefts0_.VERSICH_NR as VERSICH_NR, geschaefts0_.ADRESSE_ID as ADRESSE_ID, geschaefts0_.VERKAUFSLEITER_ID as VERKAUF14_, geschaefts0_.KUNDENBETREUER_ID as KUNDENB15_, geschaefts0_.MITARBEITER_ID as MITARBE16_, geschaefts0_.MITARB_ID_INS as MITARB_17_, geschaefts0_.MITARB_ID_UPD as MITARB_18_, geschaefts0_.TS_INSERT as TS_INSERT, geschaefts0_.TS_UPDATE as TS_UPDATE from G_PARTNER geschaefts0_
DEBUG[net.sf.hibernate.impl.BatcherImpl] preparing statement
DEBUG[net.sf.hibernate.loader.Loader] processing result set
DEBUG[net.sf.hibernate.type.LongType] returning '1' as column: G_PARTNE1_
DEBUG[net.sf.hibernate.loader.Loader] result row: 1
DEBUG[net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 1
DEBUG[net.sf.hibernate.loader.Loader] Hydrating entity: com.carano.cbf.partner.po.GeschaeftspartnerPO#1
DEBUG[net.sf.hibernate.type.LongType] returning '10' as column: KONZERN_ID
DEBUG[net.sf.hibernate.type.LongType] returning '6' as column: MANDANTE3_
DEBUG[net.sf.hibernate.type.LongType] returning '3' as column: RECHTSFO4_
DEBUG[net.sf.hibernate.type.LongType] returning '1' as column: GP_STATU5_
DEBUG[net.sf.hibernate.type.LongType] returning '2' as column: GP_ROLLE6_
DEBUG[net.sf.hibernate.type.LongType] returning '2' as column: GP_WIRT_7_
DEBUG[net.sf.hibernate.type.IntegerType] returning '1581' as column: DEBITORE8_
DEBUG[net.sf.hibernate.type.IntegerType] returning '0' as column: KREDITOR9_
DEBUG[net.sf.hibernate.type.IntegerType] returning '0' as column: KUNDEN_NR
DEBUG[net.sf.hibernate.type.StringType] returning '2' as column: KENN_NR
DEBUG[net.sf.hibernate.type.StringType] returning '2' as column: VERSICH_NR
DEBUG[net.sf.hibernate.type.LongType] returning '7310' as column: ADRESSE_ID
DEBUG[net.sf.hibernate.type.LongType] returning '1' as column: VERKAUF14_
DEBUG[net.sf.hibernate.type.LongType] returning '1' as column: KUNDENB15_
DEBUG[net.sf.hibernate.type.LongType] returning '9' as column: MITARBE16_
DEBUG[net.sf.hibernate.type.LongType] returning null as column: MITARB_17_
DEBUG[net.sf.hibernate.type.LongType] returning '0' as column: MITARB_18_
DEBUG[net.sf.hibernate.type.TimestampType] returning '12 Januar 1997 10:27:35' as column: TS_INSERT
DEBUG[net.sf.hibernate.type.TimestampType] returning '08 M

who could hepl me?