GateIn and PostgreSQL - How To?

[michaelschuetz]

Hi,

I need to integrate GateIn with PostgreSQL. I use GateIn3.1 with JBossAS5.1 ans Postgres 8.4.

I did read post: http://community.jboss.org/message/536630

Still a little bit confused about what really is required to do.

Would thererfore really appreciate a short FAQ article.

Thanks and regards

Michael

[mwringe]

The reference guide has a section on how to setup the database for GateIn:

http://docs.jboss.com/gatein/portal/3.1.0-FINAL/reference-guide/en-US/html/chap-Reference_Guide-Configuration.html#sect-Reference_Guide-Database_Configuration

[michaelschuetz]

Thanks for your reply. I got it working already.

Reference is not specific enough for Postgres configuration.

This one is required as well:

$JBOSS_HOME/server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml

Add this row 5 times:
<property name="jbosscache-cl-cache.jdbc.node.type" value="bytea" />

Postgres uses "bytea", not "blob".

Regards

Michael

[theute]

I opened a Jira for it.

https://jira.jboss.org/browse/GTNPORTAL-1361

Thanks !