...ho deciso di evolvere e così ho intrapreso la strada di hibernate + postgres...i file di configurazione penso siano corretti e posizionati nella giusta directory...sto seguendo il tutorial di hibernate...
...la action di test...
public class TestAction extends BaseAction {
private final String FORWARD_MAIN = "test";
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
long startMilliseconds = System.currentTimeMillis();
String returnForward = "wrongForward";
returnForward = "test";
ActionMessages messages = new ActionMessages();
try {
TestForm main = (TestForm)form;
Session session = HibernateUtil.currentSession();
System.out.println("Open? "+session.isOpen());
System.out.println("Connected? "+session.isConnected());
Transaction tx= session.beginTransaction();
session.beginTransaction();
Cat princess = new Cat();
princess.setName("Princess");
princess.setSex('F');
princess.setWeight(7.4f);
session.save(princess);
tx.commit();
HibernateUtil.closeSession();
}catch(Exception e) {
System.out.println(e);
throw e;
}
saveMessages(request, messages);
return (mapping.findForward(returnForward));
}
}
...il file di configurazione del "contenitore"...
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="it.assez">
<class name="it.assez.Cat" table="cat">
<id name="id" type="string">
<column name="c" not-null="true" sql-type="char(32)"/>
<generator class="uuid.hex"/>
</id>
<!-- A cat has to have a name, but it shouldn' be too long. -->
<property name="name">
<column length="16" name="name" not-null="true"/>
</property>
<property name="sex"/>
<property name="weight"/>
</class>
</hibernate-mapping>
...il file di configurazione di hibernate...
<?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>
<property name="connection.datasource">java:comp/env/jdbc/PostHibernate</property>
<property name="show_sql">false</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<!-- Mapping files -->
<mapping resource="Cat.hbm.xml"/>
</session-factory>
</hibernate-configuration>
...ed infine il context nel server.xml...
<Context debug="0"
docBase="C:/Programmi/eclipse-SDK-3.0.1-win32/eclipse/workspace/PostHibernate/WebContent"
path="/PostHibernate" reloadable="true">
<Resource name="jdbc/PostHibernate" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/PostHibernate">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:postgresql://localhost/PostHibernates</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>postgres</value>
</parameter>
<parameter>
<name>password</name>
<value>postgres</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
</ResourceParams>
</Context>
...l'errore viene scatenato alla riga "Transaction tx= session.beginTransaction();"...nella rete l'errore org.hibernate.exception.GenericJDBCException: Cannot open connection è legato principalmente a problemi di carico...situazione in cui il numero di connessioni supera il consentito...
...ciao...