Cannot open connection

spurcell999 · **Joined:** Thu Dec 15, 2005 12:02 pm **Posts:** 23

Tomcat 5.5 on XP
hibernate3.jar

I have read the book, and this is my first time getting rolling programatically. I just need to get this simple step complete, then I believe I can roll. Is there a way to find out exactly what is failing? Aside from just a Cannot open connection?

I have created a cfg type configuration and placed it under WEB-INF/classes (classpth)
Here it is:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.username">XXXXX</property>
<property name="connection.password">XX</property>
<property name="connection.url">jdbc:oracle:thin:@XXXX.com:1521</property>
<property name="show_sql">true</property>
<property name="">true</property>
<mapping resource="/com/xxxxxx/xx.hbm.xml" />
</session-factory>
</hibernate-configuration>

2) I created a simple Configuration like so in a singleton class.
Configuration cfg = new Configuration();
cfg.configure("/hibernate.cfg");
sessionFactory = cfg.buildSessionFactory();

Nothing blows up until I make this call, and then I get a "Cannot open connection" there at 2 exception.

Session session = ConnectionFactory.getInstance().getSession();

try
{
Query query =
session.createQuery(
"from myclass myclass");
return query.list();

}
catch (HibernateException e)
{
System.err.println("2 Hibernate Exception" + e.getMessage());

jt_1000 · **Posted:** Fri Mar 03, 2006 3:08 pm

what is ConnectionFactory...?

Here is the basic steps, using a properties file... which can be modified cfg.configure() to load the cfg.xml file instead (see this other thread for info on cfg.xml vs. properties loading:
http://forum.hibernate.org/viewtopic.php?t=956099&highlight=hibernate+properties

Code:

Configuration cfg = new Configuration();
Properties p=new Properties();
try {
    p.load(new FileInputStream(new File("hibernate.properties")));
} catch (IOException e) {
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    PrintWriter pw = new PrintWriter(baos);

    System.err.println(e.getMessage());
    e.printStackTrace(pw);
    System.err.println(baos.toString());
    e.printStackTrace();
    System.exit(-1);
}
cfg.buildSettings(p);

cfg.addClass(test.proc.AccountSources.class);

SessionFactory sessionFactory = cfg.buildSessionFactory();
Session session = null;
session = sessionFactory.openSession();

Hope this helps some...