[chandler-users] PostgreSQL support

[Randy Letness]

PostgresSQL *should* work, although its not currently tested.  In 
addition to the configuration in server.xml, you must also make changes 
to the cosmo.properties file in:

osaf-server-bundle-0.10/etc

You need to set the dialect property like this:

cosmo.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

-Randy

BALATON Zoltan wrote:
> Hello,
>
> Although the documantation did not say PostgreSQL is supported it was 
> mentioned in the server.xml configuration so I decided to give it a 
> try. All I managed to get were some error messages to the effect:
>
> WARN  [AnnotationSessionFactoryBean] Unsuccessful schema statement: 
> create table attribute (attributetype varchar(16) not null, id bigint 
> not null, createdate bigint, etag varchar(255), modifydate bigint, 
> localname varchar(255) not null, namespace varchar(255) not null, 
> binvalue blob(102400000), booleanvalue smallint, datevalue timestamp, 
> tzvalue varchar(32), decvalue numeric(19,6), textvalue 
> clob(102400000), intvalue bigint, stringvalue varchar(2048), itemid 
> bigint not null, primary key (id), unique (itemid, namespace, localname))
>
> PSQLException: ERROR: syntax error at or near "("
>
> and so on. Is this because:
>
> 1. I've tried something unsupported that is not supposed to work anyway.
> 2. I have a configuration error in my database server or Chandler Server.
> 3. I hit a bug that could be fixed.
> 4. Or something completely different.
>