Jetspeed 2 - Postgresql connection Issue

["Nicholls, Ian" <ia...@det.nsw.edu.au>]

Hi,
  I am looking at developing a series of JSR 168 compliant portlets and
wanted to use the Jetspeed 2 code as a base to work from, I have a
number of databases setup using Postgresql and do not want to run yet
another database so I started to change the maven.xml to include a
Postgresql step, everything went fine (well mostly fine) until it came
to the portal_entity table. This table cannot be created in postgresql
because the column OID conflicts with a postgresql reserved word. 

 My question is, is there any way to do a mapping to change the actual
column name within the database but not change the Jetspeed 2 code? Or
is this going to require a code change to get working?

Ian Nicholls

**********************************************************************
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**********************************************************************

Re: Jetspeed 2 - Postgresql connection Issue

[David Sean Taylor <da...@bluesunrise.com>]

On Jun 22, 2004, at 2:40 PM, Nicholls, Ian wrote:

> Hi,
>   I am looking at developing a series of JSR 168 compliant portlets and
> wanted to use the Jetspeed 2 code as a base to work from, I have a
> number of databases setup using Postgresql and do not want to run yet
> another database so I started to change the maven.xml to include a
> Postgresql step, everything went fine (well mostly fine) until it came
> to the portal_entity table. This table cannot be created in postgresql
> because the column OID conflicts with a postgresql reserved word.

Submit it as a bug to JIRA
We will change the column name

>
>  My question is, is there any way to do a mapping to change the actual
> column name within the database but not change the Jetspeed 2 code? Or
> is this going to require a code change to get working?
>
> Ian Nicholls
>



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org