Re: Failed to retrieve user 'anon': ORA-00904: invalid column name
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: > > > > generating > > OBJECTDATA BINARY, > > And Torque has a problem with a HEX error > > Try changing to > > > > 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/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: > <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]>
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: generating OBJECTDATA BINARY, And Torque has a problem with a HEX error Try changing to 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/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: <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]>
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/msg05377.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]>
