Building with Postgresql

<br />
       	 <test.hibernate.cfg>C:/Docume~1/swood/postgres.hibernate.cfg.xml</test.hibernate.cfg><br />
       	 <test.hibernate.jdbc.properties>C:/Docume~1/swood/postgres.jdbc.properties</test.hibernate.jdbc.properties><br />
       	 <!-- When you run the metadata repository DDL generation, do you want the<br />
       	      database to be dropped and recreated?					--><br />
       	 <metadata.database.generate>true</metadata.database.generate><br />
	 <repository.database.driver.groupId>postgresql</repository.database.driver.groupId><br />
	 <repository.database.driver.artifactId>postgresql</repository.database.driver.artifactId><br />
	 <repository.database.driver.version>8.1-404.jdbc3</repository.database.driver.version><br />
	 	 <js.quartz.script>C:/Docume~1/swood/My Documents/workspace/jasperserver-trunk/scripts/quartz/tables_mysql_innodb.sql</js.quartz.script><br />
</td></tr></tbody></table><br />
<br />
As you found, Postgres needs to read blobs in a transaction, which MySQL and other databases do not. I think the fix will be to change the metadata repository data source in the Spring configurations.<br />
<br />
In WEB-INF/applicationContext.xml, try changing the XX bean definition as follows - drop the readOnly configurations on get* and find*:<br />
<br />
<br />
<table align="center" border="0" cellpadding="3" cellspacing="1" width="90%"><tbody><tr><td><b>Code:</b></td></tr><tr><td><pre>    <bean id="hibernateRepoServiceTransactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor"><br />
		<property name="transactionManager" ref="transactionManager"/><br />
		<property name="transactionAttributes"><br />
			<props><br />
				<prop key="get*">PROPAGATION_REQUIRED</prop><br />
				<prop key="find*">PROPAGATION_REQUIRED</prop><br />
				<prop key="createFolder">PROPAGATION_REQUIRED</prop><br />
				<prop key="save*">PROPAGATION_REQUIRED</prop><br />
				<prop key="delete*">PROPAGATION_REQUIRED</prop><br />
				<prop key="*">PROPAGATION_SUPPORTS</prop><br />
			</props><br />
		</property><br />
    </bean><br />
</td></tr></tbody></table><br />
<br />
<br />
Let me know how you go.<br />
<br />
<br />
Sherman<br />
JasperSoft [file name=postgres.txt size=2134]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/postgres.txt[/file]<br>Post edited by: swood, at: 2006/10/21 20:33