Использую:
Hibernate v3, DB2 v9, JSF, Tomcat v6
Вот обрашаюсь к базе данных. В первый раз все работает. Но стоит мне переустанавить программу происходит исключение
| Код |
org.hibernate.exception.JDBC ConnectionException: Cannot open connection
|
Чтоб снова сраюотала нада перезапустить Tomcat.
index.jsp
| Код |
<html>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<f:view>
<head>
<title><h:outputText value="Web Application"/></title>
</head>
<body>
<h:outputText value="Hello from JSF:-)"/>
<h:outputText value="#{project.project}"/>
</body>
</f:view>
</html>
|
faces-config.xml
| Код |
<?xml version="1.0" encoding="UTF-8"?>
<faces-config xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-facesconfig_1_2.xsd"
version="1.2">
<managed-bean>
<managed-bean-name>project</managed-bean-name>
<managed-bean-class>ProjectList</managed-bean-class>
<managed-bean-scope>session</managed-bean-scope>
</managed-bean>
</faces-config>
|
ProjectList.java
| Код |
public class ProjectList {
private String project;
private static SessionFactory sessionFactory;
public ProjectList() {
}
public String getProject() {
try {
ProjectList.sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
return "Initial SessionFactory creation failed." + ex.toString();
}
Session session = null;
try{
session = ProjectList.sessionFactory.openSession();
ProjectDB dept = (ProjectDB)session.load(ProjectDB.class, 1000);
session.close();
return dept.getName();
} catch (Exception e) {
return e.toString();
}
}
public void setProject(String project) {
this.project = "oohoho";
}
}
|
hibernate.cfg.xml
| Код |
<?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>
<!-- Database connection settings -->
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:MYDB</property>
<property name="hibernate.default_schema">MYSCHEMA</property>
<property name="connection.database">MYDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">100</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- mapping -->
<mapping resource="ProjectDB.hbm.xml"/>
</session-factory>
</hibernate-configuration>
|
В чем тут проблемы? |