Re: [Ejbca-develop] Fwd: JBOSS ERROR - "long" does notr exists

[<Thu...@ao...>]

Tomas, thanx for responding. The version of ejbca is 3.0b2 and I did not 
issue the "ant replaceDS" command. At this point I saw no need to change it yet. 
Since my posting I've located the source of the problem which was a definition 
in my src/ca/ca/META-INF/jbosscmp-jdbc.xml file. I renamed the wrong file from 
jbosscmp-<database>-jdbc.xml (the oracle one to be exact). Oracle's has an 
sql-type of "LONG", where postgres uses "BIGINT". I changed this and all works. 
Even so, I decided to replace the jbosscmp-jdbc.xml with the postgressql 
definition which only contains the datasource name and mapping and uses 
standardjbosscmp-jdbc.xml for resolvong sql-types.

tom

In a message dated 5/12/2004 3:00:04 AM Eastern Daylight Time, 
to...@pr... writes:

> 
> 
> You don't say which version of ejbca you are using. I assume 3.0b2.
> 
> Did you do do 'and replaceDS' followed by 'and deploy'?
> What does your src/ca/ca/META-INF/jbosssmp-jdbc.xml look like?
> 
> /Tomas
> 
> Thu...@ao... wrote:
> 
> >In a message dated 5/10/2004 4:08:26 PM Eastern Daylight Time, 
> >Thuffman00 writes:
> >
> >>JBoss 3.2.3
> >>JDK 1.4_2
> >>PostgresSql 7.4..2
> >>
> >>EJBCA builds and deploys without a problem but when I try to start 
> >>JBoss, I'm getting an DeploymentException in the EJB CAData. Error 
> >>says: "Error while creating table cadata; - nested throwable: 
> >>(org.postgresql.util.PSQLException: ERROR: type "long" does not exists)"
> >>
> >>This causes in subsequent error when 'checkIncompleteDeployments()'
> >>
> >>All MbBeans are in the "CONFIGURED: state with the exception of
> >>
> >>jboss.j2ee.jndiName=local/CAData, servoce-EJB which has the "long" 
> >>exception.
> >>
> >>This appears to be the only problem and I can't seem to figure out 
> >>the cause. All the jbosscmp-jdbc.xml files have been updated to use 
> >>PostgreSql, and the standardjbosscmp-jdbc.xml and stahdardjaws.xml 
> >>have been modified to reflect the use of PostgresSQL also.
> >>
> >>Any help in this area would be greately appreciated.
> >>
> >>tom
> >
> >
> 
>