So I have worked for a couple of days on the sources and learned much about
Jetspeed, Turbine, Torque, Maven and finally log4j. Because I'm on the early
learning curve here, I may be making another dumb mistake, but when I get
everything else in place, I still get an Oracle eror (see below). I couldn't
find reference to this in the Users List.
I was able to get debug from log4j that said the SQL being executed is:
SELECT TURBINE_USER_GROUP_ROLE.USER_ID, TURBINE_USER_GROUP_ROLE.GROUP_ID,
TURBINE_USER_GROUP_ROLE.ROLE_ID FROM TURBINE_USER_GROUP_ROLE WHERE
TURBINE_USER_GROUP_ROLE.USER_ID='anon'
...whereas src/sql/external/turbine_oracle.sql says:
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID NUMBER NOT NULL,
GROUP_ID NUMBER NOT NULL,
ROLE_ID NUMBER NOT NULL
);
...and populate-oracle.sql says:
INSERT INTO TURBINE_USER_GROUP_ROLE
VALUES(getUserId('turbine'),getGroupId('Jetspeed'),getRoleId('user'));
INSERT INTO TURBINE_USER_GROUP_ROLE
VALUES(getUserId('admin'),getGroupId('Jetspeed'),getRoleId('user'));
INSERT INTO TURBINE_USER_GROUP_ROLE
VALUES(getUserId('admin'),getGroupId('Jetspeed'),getRoleId('admin'));
INSERT INTO TURBINE_USER_GROUP_ROLE
VALUES(getUserId('anon'),getGroupId('Jetspeed'),getRoleId('guest'));
...and as you'd expect:
SQL> select * from turbine_user_group_role;
...gives:
USER_ID GROUP_ID ROLE_ID
---------- ---------- ----------
2 1 1
1 1 1
1 1 2
3 1 3
...in other words, the query's where clause is comparing a string value with
a numeric value, hence ORA-01722.
I apologize if I simply have the wrong versions of something. I'm using
torque-3.0 (turbine-2.2), jetspeed 1.4. Basically, everything taken from CVS
as at 04-Dec-2002.
Am I missing something?
Bill
> > -----Original Message-----
> > From: Bill Weir [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, December 05, 2002 6:19 PM
...
> > [junit] Failed to get anonymous user:
> > org.apache.jetspeed.services.security.RoleException: Failed to retrieve
> > roles : ORA-01722: invalid number
> >
> > [junit] org.apache.jetspeed.services.security.LoginException:
> > Failed to
> > get anonymous user: org.apache.jetspeed.services.security.RoleException:
> > Failed to retrieve roles : ORA-01722: invalid number
> > [junit] at
> > org.apache.jetspeed.services.security.turbine.TurbineAuthenticatio
> > n.getAnony
> > mousUser(TurbineAuthentication.java:22
...
> Did you run the database populate script too?
> (populate-oracle.sql)
>
(yes, after I got my classpath right, doh!)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
