You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by David Sean Taylor <da...@bbc.co.uk> on 2002/09/26 14:59:51 UTC
RE: Failed to retrieve user 'anon': ORA-00904: invalid column nam
e
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:ms@euromove.sk]
> Sent: 26 September 2002 13:39
> To: jetspeed-user@jakarta.apache.org
> 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/jetspeed-user@jakarta.apache.org/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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Failed to retrieve user 'anon': ORA-00904: invalid column name
Posted by Marian Skalsky <ms...@euromove.sk>.
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" <da...@bbc.co.uk>
To: "'Jetspeed Users List'" <je...@jakarta.apache.org>
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:ms@euromove.sk]
> > Sent: 26 September 2002 13:39
> > To: jetspeed-user@jakarta.apache.org
> > 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/jetspeed-user@jakarta.apache.org/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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> 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:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>