Re: [Ejbca-develop] PostgreSQL 7.4 doesn't work

[Tomas G. <to...@pr...>]

It looks like the database mapping is not correct, since 'varbinary' is 
the type used by Hsqldb. This particular mapping is in 
src/authorization/META-INF/jbosscmp-jdbc.xml

I updated the howto-database...

1. Use the command 'ant replaceDS'.  Choose database postgres.
2. Build and deploy EJBCA with 'ant deploy'.

If the wrong mapping was used, it might have created tables with wrong 
typ already, so better drop all tables and start again.

Cheers,
Tomas

Manuel Ruiz wrote:

> Hi,
>  
> I'm testing EJBCA and want to setup postgres 7.4 as my default database.
> I followed the database "howto" and was unable to start correctly jboss.
>  
> I get this message:
>  
> org.jboss.deployment.DeploymentException: Error while creating table 
> accessrulesdata; - nested throwable: 
> (org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exist
> I'm using 7.4 (devel) jdbc.postgresql.org drivers.
>  
> Any help?
> Manuel
>  
>