[ hibernate ]composite

[Hocinema amir]

Hello,
Is there someone having a full example using composite-id(table with primary composed with 3 fields).
<composite-id name="id" class="CompositeID">
<key-property name="vl" column="city"/>
<key-property name="cp" column="post"/>
<key-property name="adr" column="adr"/>
</composite-id>
I rewrite the equals and hashcode methode, but it is not work.
Thanks

[Paul Sturrock]

I rewrite the equals and hashcode methode, but it is not work

What's the stacktrace?
There are good examples in the Hibernate docs. http://www.hibernate.org/hib_docs/reference/html/or-mapping.html#or-mapping-s1-4b and http://www.hibernate.org/hib_docs/reference/html/components.html#components-s2-3
Hibernate is not too helpful for composite id support - I think the developers hold the opinion that a database with composite ids need remodelled, which is not always possible.

[Hocinema amir]

I have no trace errors, but i can not insert data in database.
Thanks

[Hocinema amir]

Have you example using this:
<class name="eg.Foo" table"FOOS">
<composite-id name="compId" class="eg.FooCompositeID">
<key-property name="string"/>
<key-property name="short"/>
<key-property name="date" column="date_" type="date"/>
</composite-id>
<property name="name"/>
....
</class>
Thanks

[Paul Sturrock]

but i can not insert data in database

No mapping error? So what is the SQL error - or is it just failing silently? You might want to enable Hibernates JDBC logging in hibernate.properties (see docs) which shows you the actual SQL it is trying to run, if any at all.

[Hocinema amir]

Thanks for your reply.
My error is:

[03/05/04 22:02:14:549 CEST] 667981ec PropertyMessa I org.apache.struts.util.PropertyMessageResources  Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
[03/05/04 22:02:22:451 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  Hibernate 2.1.2
[03/05/04 22:02:22:491 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  loaded properties from resource hibernate.properties: {hibernate.connection.username=sa, hibernate.connection.password=, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:hsqldb:f:/data/PRODUCTS, hibernate.connection.driver_class=org.hsqldb.jdbcDriver}
[03/05/04 22:02:22:531 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  using CGLIB reflection optimizer
[03/05/04 22:02:22:551 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  JVM does not support Statement.getGeneratedKeys()
[03/05/04 22:02:22:561 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  JVM does not support LinkedHasMap, LinkedHashSet - ordered maps and sets disabled
[03/05/04 22:02:22:561 CEST] 667981ec Environment   I net.sf.hibernate.cfg.Environment  using workaround for JVM bug in java.sql.Timestamp
[03/05/04 22:02:22:591 CEST] 667981ec Configuration I net.sf.hibernate.cfg.Configuration  Mapping resource: hibernate/test/Rloxane.hbm.xml
[03/05/04 22:02:24:063 CEST] 667981ec Binder        I net.sf.hibernate.cfg.Binder  Mapping class: hibernate.test.Rloxane -> rloxane
[03/05/04 22:02:27:127 CEST] 667981ec Configuration I net.sf.hibernate.cfg.Configuration  processing one-to-many association mappings
[03/05/04 22:02:27:558 CEST] 667981ec Configuration I net.sf.hibernate.cfg.Configuration  processing one-to-one association property references
[03/05/04 22:02:27:558 CEST] 667981ec Configuration I net.sf.hibernate.cfg.Configuration  processing foreign key constraints
[03/05/04 22:02:27:898 CEST] 667981ec Dialect       I net.sf.hibernate.dialect.Dialect  Using dialect: net.sf.hibernate.dialect.HSQLDialect
[03/05/04 22:02:27:908 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  Use outer join fetching: false
[03/05/04 22:02:28:029 CEST] 667981ec DriverManager I net.sf.hibernate.connection.DriverManagerConnectionProvider  Using Hibernate built-in connection pool (not for production use!)
[03/05/04 22:02:28:029 CEST] 667981ec DriverManager I net.sf.hibernate.connection.DriverManagerConnectionProvider  Hibernate connection pool size: 20
[03/05/04 22:02:28:239 CEST] 667981ec DriverManager I net.sf.hibernate.connection.DriverManagerConnectionProvider  using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:f:/data/PRODUCTS
[03/05/04 22:02:28:299 CEST] 667981ec DriverManager I net.sf.hibernate.connection.DriverManagerConnectionProvider  connection properties: {user=sa, password=}
[03/05/04 22:02:28:419 CEST] 667981ec TransactionMa I net.sf.hibernate.transaction.TransactionManagerLookupFactory  No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
[03/05/04 22:02:34:718 CEST] 667981ec SystemOut     O writeScript
[03/05/04 22:02:34:948 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  Use scrollable result sets: true
[03/05/04 22:02:34:948 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  Use JDBC3 getGeneratedKeys(): false
[03/05/04 22:02:34:948 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  Optimize cache for minimal puts: false
[03/05/04 22:02:34:948 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  Query language substitutions: {}
[03/05/04 22:02:34:948 CEST] 667981ec SettingsFacto I net.sf.hibernate.cfg.SettingsFactory  cache provider: net.sf.ehcache.hibernate.Provider
[03/05/04 22:02:35:039 CEST] 667981ec Configuration I net.sf.hibernate.cfg.Configuration  instantiating and configuring caches
[03/05/04 22:02:35:449 CEST] 667981ec SessionFactor I net.sf.hibernate.impl.SessionFactoryImpl  building session factory  

[ May 03, 2004: Message edited by: Hocinema amir ]
[ May 03, 2004: Message edited by: Hocinema amir ]

[Paul Sturrock]

Hmm. This stack trace doesn't seem to relate to an insert operation, or am I misunderstanding soemthing? I can see that there is one Hibernate class (Rloxane) mapped without errors and added to the Configuration, but I don't see any operations on then session (which would usually be logged, unless you have configured the logging ignore these? As you say, there are no errors - turn on Hibernate's JDBC debugging (see docs), write a unit test which adds a new Rloxane object, run it and check:
- that an insert statement is created and run
- that no mapping errors are being generated and silently ignored (unlikely).

[Hocinema amir]

thanks For reply.
I don't know why but my program has stopped on:
SessionFactory sf = cfg.buildSessionFactory();