I am having a bit of trouble trying to connect to an Oracle database. My configuration xml file looks like this.

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="jndi/ContactsSessionFactory">
<!-- properties -->
<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>

<property name="hibernate.connection.url">
jdbc:oracle://localhost:1521
</property>
<property name="hibernate.connection.username">
system
</property>
<property name="hibernate.connection.password">
password
</property>
<property name="hibernate.dialect">
net.sf.hibernate.dialect.OracleDialect
</property>

<property name="hibernate.connection.pool_size">4</property>
<property name="hibernate.show_sql">true</property>
<mapping resource="contacts/ContactInfo.hbm.xml"/>
</session-factory>
</hibernate-configuration>

Can anyone give me some hints as what the problem is? This is what is being spit out.

log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.

Thank you in advance.

p.s. This is my first time in using this tool, and so I am trying to test is to see if we will be using it in our next project.

Your logging system is not properly configured. Place a log4j.properties in your classpath root (there should be an example log4j.properties) in the hibernate distribution, so you can see the log.

Besides, you should use net.sf.hibernate.dialect.Oracle9Dialect if using Oracle9

First configure logging http://www.hibernate.org/119.html#A15
Don't set your properties on multiple lines and trim your line.


should be

Thanks for the reply gloeglm.

I think that OracleDialect extends Oracle9Dialect so I don't think that is the problem. As far as the Log4J stuff those are all warnings.

Thanks.

Rama

There is a reason why Oracle9Dialect is there, you should use it when using Oracle9.

You have to configure logging to see whats going on and which errors occur. I suggest you do that first.

You both are very correct! Thank you very much for you time.

Rama Ituarte

No Problem :) If you have got logging configured, and can't track the error down yourself, feel free to post some more :)

Thanks, I probably will. ;)