I trying to get Hibernate to work, but I get this one (on Sybase). I says I have a column name 'class', but I don't. The schema doesn't have it, nor does the mapping / source files.

Weird?


WARNING: SQL Error: 207, SQLState: ZZZZZ
28.okt.2003 18:56:03 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Invalid column name 'class'.
28.okt.2003 18:56:03 net.sf.hibernate.JDBCException <init>
SEVERE: could not insert: [Person#506]
com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'class'.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1916)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1540)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1523)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:89)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:518)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:493)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:23)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2313)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2267)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2211)
at Test.main(Test.java:43)
28.okt.2003 18:56:03 net.sf.hibernate.impl.SessionImpl execute
SEVERE: Could not synchronize database state with session

You are attempting to use some subclassing in your Hibernate mappings and have not properly set up the discriminator element on one or more of the subclasses. Specifically, you have left off the "column" attribute, which defaults to class.

All in the docs...

Ahh. Not easy for a newbie, because I guess I believed the column was automatically generated by SchemaExport.

How do I specify in the mapping doc that the SchemaExport should create a column for the descriminator???

I never touch the database manually - everything must be generated by SchemaExport.

Example please :-)

...because I assume it is not the meaning that I have to add a <property> for the discriminator column???

No, you need to add a <discriminator> element not a <property> element.

http://www.hibernate.org/hib_docs/reference/html/or-mapping.html#or-mapping-s1-5

but I have done that, I used all default values so it's an empty discriminator tag.

Why isn't the class column generated???

Sorry, I do not use the schema generation tools, so I really cannot say. Sounds like it may not be honoring the DTD default value for that attribute.

Explicitly set it and see what happens.

thank, it works.