Hi All,
I am getting an
Communications link failure error when connecting to my database, so I changed my hibernate XML file to have autoReconnect=true. Which did not solve the problem.
Then I tried the c3po approach and the problem still persists.
I tried the approach of setting wait time, using select 1 query to test the connection etc.. but did not work.
Now I decided to configure the db using data source. This time I can't make a connection. Hibernate is not read the data source. While creating the connection I am getting an exception that states driver class is ' ' and url = null. I already gave this configuration in the context.xml file under META_INF folder.
I am using Tomcat 6 and mysql as my db.
Here are my configuration files....
hibernate.cfg.xml XML is .....................
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory >
<property name="connection.datasource">java:comp/env/jdbc/mydb</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="current_session_context_class">thread</property>
<mapping resource="path/mytable.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Context XML under META-INF/context.xml of the project is .....................
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/Myproject">
<resource name="jdbc/mydb"
global="jdbc/mydb"
auth="Container"
type="javax.sql.DataSource"
username="username"
password="password"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbname?autoReconnect=true"
maxActive="8"
maxIdle="4"/>
</Context>
(Note: I tried putting the resource contents in tomcat's $CATALINA_HOME/conf/context.xml as well. )
web.xml ....................................
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
...
<resource-ref>
<description>My DB Connection</description>
<res-ref-name>jdbc/mydb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
HibernateUtil.java .......................
public class HibernateUtil {
private static final SessionFactory sessionFactory;
static {
try {
// Create the SessionFactory from standard (hibernate.cfg.xml)
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
throw new ExceptionInInitializerError(ex);
}
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
}
I am getting this exception when I do sessionFactory.getSession().
Login
FAQ
Search