Hi David!
I have localized the problem causing the LoginException with 22-9-2002
nightbuild on oracle.
In the "22-9-2002-NightBuild\build\torque\schema\security-schema.xml" file
in the definition of table TURBINE_USER, there is a PASSWORD_CHANGED collumn
defined. But in the
"22-9-2002-NightBuild\src\sql\externalturbine-oracle.sql" file, is this
collumn definition missing.

I made mistake in last post, I misguided you. The error was :
*Failed to retrieve user 'anon': ORA-00904: invalid column name
with no definition of collumn, not the
*Failed to retrieve user 'anon': ORA-00904: invalid column name OBJECTDATA

So the problem was in the other collumn :)) Thank you for pointing me the
right way.
$kala.

----- Original Message -----
From: "David Sean Taylor" <[EMAIL PROTECTED]>
To: "'Jetspeed Users List'" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 2:59 PM
Subject: RE: Failed to retrieve user 'anon': ORA-00904: invalid column name


> It seems strange that Oracle would give an invalid column name.
> Can you go into SQLPLUS and type DESCRIBE TURBINE_USER and see the
> OBJECTDATA column there?
> What data type does it show?
>
> Ive had problems with security-schema.xml:
>
>     <column name="OBJECTDATA" type="VARBINARY"/>
>
> generating
>
>     OBJECTDATA BINARY,
>
> And Torque has a problem with a HEX error
>
> Try changing to
>
>     <column name="OBJECTDATA" type="BINARY"/>
>
> generating
>
>     OBJECTDATA LONG RAW
>
> If that fixes it let me know and I'll patch it
>
> > -----Original Message-----
> > From: Marian Skalsky [mailto:[EMAIL PROTECTED]]
> > Sent: 26 September 2002 13:39
> > To: [EMAIL PROTECTED]
> > Subject: Failed to retrieve user 'anon': ORA-00904: invalid
> > column name
> >
> >
> > Hi there!
> > I'm moving from 1.4b1 to night build 22-9-2002 working with
> > ORACLE 8.17 and I'm getting this exception when starting JetSpeed:
> >
> > Horrible Exception:
> > org.apache.jetspeed.services.security.LoginException:
> > Failed to get anonymous user:
> > org.apache.jetspeed.services.security.UserException: Failed
> > to retrieve user
> > 'anon': ORA-00904: invalid column name OBJECTDATA
> >
> > I've checked sql scripts of these versions, are equal and
> > OBJECTDATA collumn is of course present in db. Anon user is
> > also present in the db. Then I found post from David Sean
> > Taylor ( 21 Aug 2002 -
> > http://www.mail-archive.com/[email protected]/m
> sg05377.html ) that says:
>
> "This is a bug from a patch I committed a while back. It doesn't work on
> Oracle for some reason, but seems to work on Hypersonic. I will roll it
back
> out now and try to resolve the bug later..."
>
> Can you tell me what's the progress about this issue ?
> How can I solve this problem ?
>
> Thank you very much.
> $kala.
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>
> BBCi at http://www.bbc.co.uk/
>
> This e-mail (and any attachments) is confidential and may contain
> personal views which are not the views of the BBC unless specifically
> stated.
> If you have received it in error, please delete it from your system, do
> not use, copy or disclose the information in any way nor act in
> reliance on it and notify the sender immediately. Please note that the
> BBC monitors e-mails sent or received. Further communication will
> signify your consent to this.
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to