Hello Jeroen,
Thanks for quick reply!
Situation is following:
* there are two web servers and on each there is
o two tomcats
o one hippo repository (latest)
o one hippo cms (latest)
* two db servers with postgres 8.3 installed in a master-slave
configuration using slony
2 repositories are configured for load balancing (jgroups configuration
should be ok) and they see DBs as a single DB, through a context
sensitive switch.
Correct JDBC driver is being used, postgresql-8.3-603.jdbc4.jar and
attached you can find requested configuration file.
Regards,
Stevo.
Jeroen Reijn wrote:
Hi Stevo,
could you provide us with some more details? Which version of Postgress are you
using for instance?
Are the postgres server and the CMS on the same machine, or are they on
different machines?
Could you perhaps post your postgres workflow configuration to the list? Have
you checked that you are using the correct JDBC driver?
Regards,
Jeroen
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Stevo Slavic
Sent: Tue 5/27/2008 8:00 PM
To: Hippo CMS development public mailinglist
Subject: [HippoCMS-dev] Load balanced Hippo, Master-Slave Postgres,and
SQLException
Hello all,
I'm not sure which of the 3 from the subject is good, bad, or ugly, but
something doesn't work in this configuration and I need your help.
Everything seems to work for some time, editing, creating, etc. but then
suddenly after a while Hippo CMS editor becomes unresponsive, just
showing animation in its right-hand bar. Log (see attachment) prints an
SQLException.
Any advice where to look for a solution would be highly appreciated.
Thanks in advance!
Regards,
Stevo.
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
--
Met vriendelijke groet / Kind regards,
Stevo Slavić
Senior Software Developer
Levi9 Global Sourcing
------------------------------------------------------------------------
. Jan van Goyenkade 8, 1075 HP Amsterdam, The Netherlands
( (+31) (0) 20 6701 947
È (+381) (0) 63 7 258 458
* [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
^ Skype: sslavic
ü http://www.levi9.com/
Chamber of commerce Levi9 Global Sourcing BV: 34221951
Chamber of commerce Levi9 Global Sourcing Benelux BV: 34224746
------------------------------------------------------------------------
This e-mail may contain confidential or privileged information. If you
are not (one of) the intended recipient(s), please notify the sender
immediately by reply e-mail and delete this message and any attachments
permanently without retaining a copy. Any review, disclosure, copying,
distribution or taking any action in reliance on the contents of this
e-mail by persons or entities other than the intended recipient(s) is
strictly prohibited and may be unlawful.
The services of Levi9 are exclusively subject to its general terms and
conditions. These general terms and conditions can be found on
http://www.levi9.com/ and a copy will be promptly submitted to you on
your request and free of charge.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd";>
<!--
Copyright 2001-2007 Hippo (www.hippo.nl)
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<beans>
<bean id="projectWorkflowDataSourceBinder" class="nl.hippo.servermanager.util.JndiBinder" init-method="bind">
<property name="context"><ref bean="defaultContext"/></property>
<property name="name"><value>java:comp/env/jdbc/localdevWorkflowDataSource</value></property>
<property name="object"><ref local="projectWorkflowDataSource"/></property>
</bean>
<bean id="projectWorkflowDataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"><value>org.postgresql.Driver</value></property>
<property name="url"><value>jdbc:postgresql://172.29.71.6:5432/osworkflow</value></property>
<property name="username"><value>slide</value></property>
<property name="password"><value>slide</value></property>
<property name="initialSize"><value>10</value></property>
</bean>
<bean id="projectWorkflowStore"
class="nl.hippo.servermanager.util.SpringJdbcWorkflowStore" init-method="initialize" depends-on="projectWorkflowDataSourceBinder">
<property name="dataSource"><ref bean="projectWorkflowDataSource"/></property>
<property name="initializationProperties">
<map>
<entry key="entry.sequence">
<value>SELECT nextVal('seq_os_wfentry')</value>
</entry>
<entry key="step.sequence">
<value>SELECT nextVal('seq_os_currentsteps')</value>
</entry>
<entry key="entry.table">
<value>OS_WFENTRY</value>
</entry>
<entry key="entry.id">
<value>ID</value>
</entry>
<entry key="entry.name">
<value>NAME</value>
</entry>
<entry key="entry.state">
<value>STATE</value>
</entry>
<entry key="history.table">
<value>OS_HISTORYSTEP</value>
</entry>
<entry key="current.table">
<value>OS_CURRENTSTEP</value>
</entry>
<entry key="historyPrev.table">
<value>OS_HISTORYSTEP_PREV</value>
</entry>
<entry key="currentPrev.table">
<value>OS_CURRENTSTEP_PREV</value>
</entry>
<entry key="step.id">
<value>ID</value>
</entry>
<entry key="step.entryId">
<value>ENTRY_ID</value>
</entry>
<entry key="step.stepId">
<value>STEP_ID</value>
</entry>
<entry key="step.actionId">
<value>ACTION_ID</value>
</entry>
<entry key="step.owner">
<value>OWNER</value>
</entry>
<entry key="step.caller">
<value>CALLER</value>
</entry>
<entry key="step.startDate">
<value>START_DATE</value>
</entry>
<entry key="step.finishDate">
<value>FINISH_DATE</value>
</entry>
<entry key="step.dueDate">
<value>DUE_DATE</value>
</entry>
<entry key="step.status">
<value>STATUS</value>
</entry>
<entry key="step.previousId">
<value>PREVIOUS_ID</value>
</entry>
</map>
</property>
<property name="propertySetFactory">
<ref local="projectWorkflowPropertySetFactory"/>
</property>
</bean>
<bean id="projectWorkflowPropertySetFactory" class="nl.hippo.servermanager.util.JdbcPropertySetFactory" depends-on="projectWorkflowDataSourceBinder">
<property name="configurationProperties">
<map>
<entry key="datasource">
<value>java:comp/env/jdbc/localdevWorkflowDataSource</value>
</entry>
<entry key="table.name">
<value>OS_PROPERTYENTRY</value>
</entry>
<entry key="col.globalKey">
<value>GLOBAL_KEY</value>
</entry>
<entry key="col.itemKey">
<value>ITEM_KEY</value>
</entry>
<entry key="col.itemType">
<value>ITEM_TYPE</value>
</entry>
<entry key="col.string">
<value>STRING_VALUE</value>
</entry>
<entry key="col.date">
<value>DATE_VALUE</value>
</entry>
<entry key="col.data">
<value>DATA_VALUE</value>
</entry>
<entry key="col.float">
<value>FLOAT_VALUE</value>
</entry>
<entry key="col.number">
<value>NUMBER_VALUE</value>
</entry>
</map>
</property>
</bean>
</beans>
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
