Lets, for the sake of argument, pretend that I don't know how to do that...
On Fri, Mar 12, 2010 at 5:05 PM, Scott Battaglia <[email protected]>wrote: > Do those issues go away if you inherit the parent pom like I was trying > out? > > > On Fri, Mar 12, 2010 at 4:52 PM, Patrick Berry <[email protected]> wrote: > >> 3.3.5. Sorry, the 3.4 overlay vs. spring jar conflict stuff is still >> biting me. >> >> >> >> On Fri, Mar 12, 2010 at 4:50 PM, Scott Battaglia < >> [email protected]> wrote: >> >>> Are you trying this with RC1? >>> >>> >>> On Fri, Mar 12, 2010 at 4:46 PM, Patrick Berry <[email protected]> wrote: >>> >>>> I created the tables with no keys or null enables and sure enough the >>>> AUD_USER is null. >>>> >>>> Attached is the data. >>>> >>>> >>>> On Mon, Feb 22, 2010 at 6:21 PM, Scott Battaglia < >>>> [email protected]> wrote: >>>> >>>>> My guess is there was no ticket to log out of which is returning null. >>>>> I should update it to return the anonymous user when none can be found. >>>>> The alternative is to remove the null restriction. >>>>> >>>>> Cheers, >>>>> Scott >>>>> >>>>> >>>>> On Mon, Feb 22, 2010 at 8:07 PM, Patrick Berry <[email protected]>wrote: >>>>> >>>>>> I'll be doing more to verify this tomorrow, but I think I found a bug >>>>>> (or at least it's an issue if you use the create table script from the >>>>>> wiki). If you hit the CAS logout URL directly, the database insert will >>>>>> fail: >>>>>> >>>>>> Exception in thread "pool-2-thread-1" >>>>>> org.springframework.dao.DataIntegrityViolationException: >>>>>> PreparedStatementCallback; SQL [Insert into COM_AUDIT_TRAIL(AUD_USER, >>>>>> AUD_CLIENT_IP, AUD_SERVER_IP, AUD_RESOURCE, AUD_ACTION, APPLIC_CD, >>>>>> AUD_DATE) >>>>>> Values(?, ?, ?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL into >>>>>> ("EAPP_CAS_SVC"."COM_AUDIT_TRAIL"."AUD_USER") >>>>>> ; nested exception is java.sql.SQLException: ORA-01400: cannot insert >>>>>> NULL into ("EAPP_CAS_SVC"."COM_AUDIT_TRAIL"."AUD_USER") >>>>>> >>>>>> at >>>>>> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228) >>>>>> at >>>>>> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858) >>>>>> at >>>>>> org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:237) >>>>>> at >>>>>> org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask$1.doInTransactionWithoutResult(JdbcAuditTrailManager.java:96) >>>>>> at >>>>>> org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) >>>>>> at >>>>>> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) >>>>>> at >>>>>> org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask.run(JdbcAuditTrailManager.java:89) >>>>>> at >>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >>>>>> at >>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >>>>>> at java.lang.Thread.run(Thread.java:637) >>>>>> Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into >>>>>> ("EAPP_CAS_SVC"."COM_AUDIT_TRAIL"."AUD_USER") >>>>>> >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >>>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) >>>>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) >>>>>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) >>>>>> at >>>>>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) >>>>>> at >>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) >>>>>> at >>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454) >>>>>> at >>>>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798) >>>>>> at >>>>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) >>>>>> ... 11 more >>>>>> >>>>>> Thoughts on bug vs database issue? >>>>>> >>>>>> -- >>>>>> You are currently subscribed to [email protected] as: >>>>>> [email protected] >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> To unsubscribe, change settings or access archives, see >>>>>> http://www.ja-sig.org/wiki/display/JSG/cas-dev >>>>>> >>>>>> >>>>> -- >>>>> You are currently subscribed to [email protected] as: >>>>> [email protected] >>>>> >>>>> >>>>> >>>>> To unsubscribe, change settings or access archives, see >>>>> http://www.ja-sig.org/wiki/display/JSG/cas-dev >>>>> >>>>> >>>> -- >>>> You are currently subscribed to [email protected] as: >>>> [email protected] >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> To unsubscribe, change settings or access archives, see >>>> http://www.ja-sig.org/wiki/display/JSG/cas-dev >>>> >>>> >>> -- >>> You are currently subscribed to [email protected] as: [email protected] >>> To unsubscribe, change settings or access archives, see >>> http://www.ja-sig.org/wiki/display/JSG/cas-dev >>> >>> >> -- >> You are currently subscribed to [email protected] as: >> [email protected] >> >> >> >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/cas-dev >> >> > -- > You are currently subscribed to [email protected] as: [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-dev > > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-dev
