Hi all! Well, i'm trying to migrate from hypersonic to postgresql and
got some problems. I edited the JETSPEED_HOME/webapp/WEB-INF/conf/Torque.properties,
JETSPEED_HOME/build/torque/build.properties and
JETSPEED_HOME/build/torque/dbpsml.properties
files to support postgresql.
Also, i edited JETSPEED_HOME/src/sql/dbpsml-schema.sql file, replacing
all BINARY fields to bytea and all IDENTITY fields to serial. I did the
same changes in JETSPEED_HOME/src/sql/security-schmema.sql. Then, i edited the
JETSPEED_HOME/src/sql/external/turbine-postgres.sql file, changing all oid
fields to bytea, but i receive exceptions when i try to add a new user in
jetspeed.
My last change was the one mentioned in the post below, but i still got
exceptions. Can anyone give me a full plan of migration from hypersonic to
postgresql please?
I'm using jetspeed-1.4 with tomcat-4.1.27.
Thanx in advance
----- Original Message -----
From: "Adrien GEYMOND" <[EMAIL PROTECTED]>
To: "Jetspeed Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 1:00 PM
Subject: Re: change from hypersonic to oracle
> hi,
>
>
>
> I've found few month ago this message in the archive :
>
>
>
> To use jetspeed with Oracle, you need to build from the src, otherwise
such
> exceptions are commons :) Cause when you build from src saying you want
> oracle, it regenerates thoseclasses, with the good stuff in it > I
> experienced the same error, and I can only tell you a workaround. I>
think
> this can alse be avoided by building jetspeed from source> properly.>>
But
> here is my fix:> for Turbine_user, there is a class named>
> org.apache.jetspeed.om.security.turbine.map.TurbineUserMapBuilder.>
Enter
> the sources, and change>> tMap.setPrimaryKeyMethodInfo("TURBINE_USER");>
to>
> tMap.setPrimaryKeyMethodInfo("TURBINE_USER_SEQ");>
> ^^^^> This should help. Note that there are similar classes for each
table>
> out there.Do the same thing for all the package
> org.apache.jetspeed.om.security.turbine.map when there is a method
> setPrimaryKeyMethodInfo
>
> i've to apply this fix for the release jetspeed-1.4-b4*
>
>
>
> i hope it helps ...
>
>
>
> ::::::::::::::::::::::::::::::::::::::::
> Adrien
>
>
> ---------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
