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.
By the way, I'd like to know why there are the wrong entries in the source
distributation?
Hope I could help you.
> -----Urspr�ngliche Nachricht-----
> Von: Aurelien Pernoud [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. April 2003 08:53
> An: 'Jetspeed Users List'
> Betreff: RE: 1.4b3 and oracle sequence names problem
>
>
>
> This is weird, I got 1.4b3 working with Oracle 8i / 9i
> without any trouble,
> and the sequence name is indeed TURBINE_USER_SEQ...
>
> Have you build Jetspeed from src, and declared you wanted it
> to use a Oracle
> DB (under src/build/torque, I have two properties referring to oracle
> database : build.properties and dbpsml.properties) ?
>
> You're not the first one with this trouble, but I don't know how other
> people got it working... All I can say is I got it working,
> under WIN2K and
> AIX 4/5 :(
>
> Try looking the archive on www.mail-archive.com ?
>
> Marco Parmigiani a �crit :
>
> > Hi everybody,
> >
> > While using Jetspeed 1.4b3 with Oracle (both 8i and 9i),
> > everything works fine but this error occurs when I try to add a new
> > user:
> >
> > [DEBUG] - select TURBINE_USER.nextval from dual
> > [ERROR] - Turbine.handleException: null
> > [ERROR] - java.lang.reflect.InvocationTargetException:
> > java.sql.SQLException: ORA-02289: sequence does not exist
> >
> > This happens because the actual name of the sequence, created
> > by turbine-oracle.sql, is TURBINE_USER_SEQ and not
> > TURBINE_USER, which is the name of the table.
> >
> > I'm not sure about how to set up Torque to solve this
> problem since I
> > never used it. How can I configure and build the portal in order to
> > make it use the correct sequence name?
> >
> >
> > Thanks in advance,
> >
> > Marco
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
