Hi Javier, please, let me know, which version of Jahia you use and post the exception stack trace that you get after changes, I described (datasource in the jahia.xml and Hibernate dialect in the applicationcontext-hibernate.xml).
Could you also provide more details about the migration, you done from HSQL to PostgreSQL? Thank you! Sergiy Javier Turégano wrote: > Hi Sergiy, > > El Lun, 12 de Noviembre de 2007, 4:41 pm, Sergiy Shyrkov escribió: > >> Hi Javier, >> >> > > First of all thanks for your fast answer. > > >> in the default installation the database connection is configured using >> the JNDI datasource that is used in Jahia. >> Its name is configured as 'datasource.name' in the jahia.properties >> file. If it is specified, other settings have no influence in this case. >> The same datasource is used across all Jahia services. >> Its configuration is located in the >> <TOMCAT_HOME>/conf/Catalina/localhost/jahia.xml file (in the default >> installation). >> >> You need to change the datasource configuration in the jahia.xml file >> from HSQL to PostgreSQL, i.e.: >> >> > > We have done this change also, but it looks like that has no effect over > our instalation. After the change is enough a tomcat restart or there is > more work to do? Is necesary to change also the jahia.xml located in the > src tree? > > >> <Context path="/jahia" docBase="jahia" crossContext="true"> >> >> <Manager pathname=""/> >> >> <Resource name="jdbc/jetspeed" auth="Container" >> factory="org.apache.commons.dbcp.BasicDataSourceFactory" >> type="javax.sql.DataSource" username="jahia_user" >> password="jahia_pass" >> driverClassName="org.postgresql.Driver" >> url="jdbc:postgresql://192.168.1.5:5432/jahia" defaultAutoCommit="true" >> maxActive="100" maxIdle="30" maxWait="10000"/> >> >> <Resource name="jdbc/jetspeedNonTx" auth="Container" >> factory="org.apache.commons.dbcp.BasicDataSourceFactory" >> type="javax.sql.DataSource" username="jahia_user" >> password="jahia_pass" >> driverClassName="org.postgresql.Driver" >> url="jdbc:postgresql://192.168.1.5:5432/jahia" defaultAutoCommit="true" >> maxActive="20" maxIdle="30" maxWait="10000"/> >> >> </Context> >> >> >> Kind regards >> Sergiy Shyrkov >> >> > > Any other idea or posibility about where the source of the problem is? > > _______________________________________________ install_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
