portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ate Douma <...@douma.nu>
Subject Re: [J2] Head
Date Wed, 27 Jul 2005 22:14:03 GMT
David Le Strat wrote:
> All,
> 
> Before moving forward with some of my commits, I
> wanted to make sure i was starting with a clean slate.
> 
> I am getting the following error for the SSO
> component.  Which I was getting before Scott commit as
> well.  As part of some of the changes I would like to
> make.  I have upgraded Torque and OJB and the problem
> is no longer (fixes cascasding delete issue).  Is
> anyone else having this issue?
Yes, this is a old (and known) issue, but only with Hsqldb:
    http://issues.apache.org/jira/browse/JS2-227

Have you tested the new Torque/OJB combination with other db?
I'd rather not see J2 suddenly break on Mysql, PostgreSQL and/or Oracle...
Otherwise, I'd like to see this issue fixed indeed ;-)


> 
> DEBUG:
> org.apache.jetspeed.security.spi.impl.SecurityAccessImpl
> - Deleted user: /user/jack
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl]
> ERROR: SQLException during the execution of the delete
> (for a
> org.apache.jetspeed.security.om.impl.InternalGroupPrincipalImpl):
> Integrity constraint violation:
> SSO_SITE_TO_PRINCIPALS_FK_2 table:
> SSO_SITE_TO_PRINCIPALS in statement [DELETE FROM
> SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> Integrity constraint violation:
> SSO_SITE_TO_PRINCIPALS_FK_2 table:
> SSO_SITE_TO_PRINCIPALS in statement [DELETE FROM
> SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> ERROR:
> org.apache.jetspeed.security.spi.impl.SecurityAccessImpl
> - Unexpected security error at
> SecurityAccess.removeInternalGroupPrincipal from
> store: (OJB operation): data integrity violated by SQL
> ''; nested exception is java.sql.SQLException:
> Integrity constraint violation:
> SSO_SITE_TO_PRINCIPALS_FK_2 table:
> SSO_SITE_TO_PRINCIPALS in statement [DELETE FROM
> SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> org.springframework.dao.DataIntegrityViolationException:
> (OJB operation): data integrity violated by SQL '';
> nested exception is java.sql.SQLException: Integrity
> constraint violation: SSO_SITE_TO_PRINCIPALS_FK_2
> table: SSO_SITE_TO_PRINCIPALS in statement [DELETE
> FROM SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> java.sql.SQLException: Integrity constraint violation:
> SSO_SITE_TO_PRINCIPALS_FK_2 table:
> SSO_SITE_TO_PRINCIPALS in statement [DELETE FROM
> SECURITY_PRINCIPAL WHERE principal_id = 422 ]
> 	at org.hsqldb.Trace.getError(Unknown Source)
> 	at org.hsqldb.Result.<init>(Unknown Source)
> 
> 
> ________________________
> David Le Strat
> Blogging @ http://dlsthoughts.blogspot.com
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
> 
> 
> 
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message