[
http://issues.apache.org/jira/browse/JS2-318?page=comments#action_12317359 ]
Scott T Weaver commented on JS2-318:
------------------------------------
TestSSOComponent is now failing for me:
java.sql.SQLException: DELETE statement conflicted with COLUMN REFERENCE
constraint 'SSO_PRINCIPAL_TO_REMOTE_FK_2'. The conflict occurred in database
'j2test', table 'SSO_PRINCIPAL_TO_REMOTE', column 'REMOTE_PRINCIPAL_ID'.
at
net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
at
net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752)
at
net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
at
net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
at
net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
at
net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
at
net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeDelete(JdbcAccessImpl.java:115)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:528)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.delete(PersistenceBrokerImpl.java:475)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate$10.doInPersistenceBroker(PersistenceBrokerTemplate.java:276)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:167)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.delete(PersistenceBrokerTemplate.java:274)
at
org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider.removeCredentialsForSite(PersistenceBrokerSSOProvider.java:401)
at
org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider.removeCredentialsForSite(PersistenceBrokerSSOProvider.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy5.removeCredentialsForSite(Unknown Source)
at
org.apache.jetspeed.sso.TestSSOComponent.testSSOGroup(TestSSOComponent.java:223)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:536)
org.springframework.dao.DataIntegrityViolationException: (OJB operation): data
integrity violated by SQL ''; nested exception is java.sql.SQLException: DELETE
statement conflicted with COLUMN REFERENCE constraint
'SSO_PRINCIPAL_TO_REMOTE_FK_2'. The conflict occurred in database 'j2test',
table 'SSO_PRINCIPAL_TO_REMOTE', column 'REMOTE_PRINCIPAL_ID'.
java.sql.SQLException: DELETE statement conflicted with COLUMN REFERENCE
constraint 'SSO_PRINCIPAL_TO_REMOTE_FK_2'. The conflict occurred in database
'j2test', table 'SSO_PRINCIPAL_TO_REMOTE', column 'REMOTE_PRINCIPAL_ID'.
at
net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
at
net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752)
at
net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
at
net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
at
net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
at
net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
at
net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeDelete(JdbcAccessImpl.java:115)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.doDelete(PersistenceBrokerImpl.java:528)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.delete(PersistenceBrokerImpl.java:475)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.delete(DelegatingPersistenceBroker.java:170)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate$10.doInPersistenceBroker(PersistenceBrokerTemplate.java:276)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:167)
at
org.springframework.orm.ojb.PersistenceBrokerTemplate.delete(PersistenceBrokerTemplate.java:274)
at
org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider.removeCredentialsForSite(PersistenceBrokerSSOProvider.java:401)
at
org.apache.jetspeed.sso.impl.PersistenceBrokerSSOProvider.removeCredentialsForSite(PersistenceBrokerSSOProvider.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy5.removeCredentialsForSite(Unknown Source)
at
org.apache.jetspeed.sso.TestSSOComponent.testSSOGroup(TestSSOComponent.java:223)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325)
at
org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:536)
------------- ---------------- ---------------
Testcase: testSSOGroup(org.apache.jetspeed.sso.TestSSOComponent): Caused
an ERROR
Failed to store site info in
database.org.springframework.dao.DataIntegrityViolationException: (OJB
operation): data integrity violated by SQL ''; nested exception is
java.sql.SQLException: DELETE statement conflicted with COLUMN REFERENCE
constraint 'SSO_PRINCIPAL_TO_REMOTE_FK_2'. The conflict occurred in database
'j2test', table 'SSO_PRINCIPAL_TO_REMOTE', column 'REMOTE_PRINCIPAL_ID'.
java.lang.Exception: Failed to store site info in
database.org.springframework.dao.DataIntegrityViolationException: (OJB
operation): data integrity violated by SQL ''; nested exception is
java.sql.SQLException: DELETE statement conflicted with COLUMN REFERENCE
constraint 'SSO_PRINCIPAL_TO_REMOTE_FK_2'. The conflict occurred in database
'j2test', table 'SSO_PRINCIPAL_TO_REMOTE', column 'REMOTE_PRINCIPAL_ID'.
at
org.apache.jetspeed.sso.TestSSOComponent.testSSOGroup(TestSSOComponent.java:229)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Upgrading to Torque 3.2-rc1 and to OJB 1.0.3
> --------------------------------------------
>
> Key: JS2-318
> URL: http://issues.apache.org/jira/browse/JS2-318
> Project: Jetspeed 2
> Type: Improvement
> Components: Persistence and DAO
> Versions: 2.0-M4
> Reporter: David Le Strat
> Assignee: David Le Strat
> Fix For: 2.0-M4
>
> I have been doing some tests and I think we should upgrade Torque (to
> 3.2-rc1) and OJB (to 1.0.3) for the following reasons:
> 1. Torque: Now supports derby for SQL generation. Also, issues with
> cascading delete and HSQL have been fixed. This will address
> http://issues.apache.org/jira/browse/JS2-227.
> 2. OJB: Quite a few bugs fixed. Also, I noticed a couple of weird behaviors
> with the current version:
> As I mentioned in a previous email:
> - AbstractRegistryTest: the assertion on line 198 (assertNotNull("Web app did
> NOT persist its description", webApp.getDescription(Locale.FRENCH));) works
> no matter what locale is passed. I tried Locale.getDefault(), as well as
> Locale.FRENCH and it does not seem to matter. With 1.0.3, the assertion only
> works for Locale.FRENCH. Which the right correct behavior.
> - TestUserInfoManager: When testing with ExtendedPortletMetadata, I do not
> quite understand how
> it ever worked without calling updatePortletApplication on the registry.
> With OJB 1.0.3, you need to update the portlet application with the new
> loaded metadata for the test to pass. Just seem to make sense
> to me.
> I have applied the changes locally, I re-ran all the tests and everything is
> working, including the deployed application.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
