Exclude Column

vfonger · **Joined:** Wed Sep 10, 2003 5:32 pm **Posts:** 28

To whom it may concern,

If I have a table that I don't want to include all the columns in certain tables for example the guid column in the table that is required by SQL server for replication, is that any way in hibernate that I can exclude those columns. Thanks

Vivian

micho2001 · **Posted:** Tue Nov 25, 2003 3:09 pm

Just don't include the column in your hmb.xml files. You are not obliged to map all your db tables into a java bean property.

DavidNDuffy · **Posted:** Tue Nov 25, 2003 3:10 pm

Just don't map them.
If you don't tell Hibernate about them it won't know about them and it won't care. However, if any "ignored" columns have not null constraints then you would either have to have the database insert a default value or you would have to tell Hibernate about them.

vfonger · **Joined:** Wed Sep 10, 2003 5:32 pm **Posts:** 28

Thank you very much.. Silly me.. :) :)

tjc · **Posted:** Tue Nov 23, 2004 2:38 pm

Hi, I'm having a similar issue caused by SQL Server merge replication. My application works perfectly until I configure the replication. As soon as I reload the app Hibernate throws the following error:

Code:

23-Nov-2004 18:08:05 net.sf.hibernate.impl.SessionImpl execute
SEVERE: Could not synchronize database state with session
net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)

When setting up merge replication on my database it highlights two issues:

1. Uniqueidentifier columns will be added to tables.
2. IDENTITY columns require the NOT FOR REPLICATION option.

It can't be the addition of the extra guid column that's causing the problem, as I've tested adding such a column manually with no issues. As the previous posts correctly state: if you don't tell Hibernate about any extra columns then it will happily ignore them.

The second point is just a recommendation and doesn't seem to affect my tables in any way.

Has anyone had an experience with setting up merge replication and Hibernate? Does Hibernate need to be configured in a particular way to deal with the changes that merge replication causes to the database?

Thanks,

Tim