fellows, I need to make XPlanner run with Oracle 9 db. XPlanner uses hibernate for that, so that's why I'm here trying to get hibernate work with oracle.

I've browsed the forum and I find many users referring to this hibernate.cfg.xml file, in order to configure hibernate to work with oracle.

what I've done is:

1) enabled hibernate.properties oracle's stuff

hibernate.dialect cirrus.hibernate.sql.OracleDialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username ora
hibernate.connection.password ora
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test

2) what else do I need to do?

why is this hibernate.cfg.xml needed for?

thanks!

hibernate.cfg.xml is a replacement for hibernate.properties. Instead of manually assempling your SessionFactory at startup of your application, the Configuration can build you a SessionFactory from your hibernate.cfg.xml file.

Much more convenient. It is possible that you can do this with hibernate.properties as well, but somehow I have always seen hibernate.cfg.xml as an easier way of doing it.