-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 3.3.5 -- looks like we now have a reason to look into upgrading.
Jeff Patrick Berry wrote: > Which version of CAS are you running? This was an issue which got > resolved in 3.4.2. > > > On Mon, Apr 19, 2010 at 7:34 AM, Jeff Chapin <jeff.cha...@uni.edu > <mailto:jeff.cha...@uni.edu>> wrote: > > I am getting the following error -- I assume it is because I have > something configured wrong, as the database schema was setup by CAS: > > Exception in thread "pool-2-thread-174783" > 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 ("CAS_CONFIG_HATHOR"."COM_AUDIT_TRAIL"."AUD_USER") > ; nested exception is java.sql.SQLException: ORA-01400: cannot insert > NULL into ("CAS_CONFIG_HATHOR"."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:127) > 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:619) > Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into > ("CAS_CONFIG_HATHOR"."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:743) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368) > 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) > > > Any ideas how to fix this ? - -- You are currently subscribed to cas-user@lists.jasig.org <mailto:cas-user@lists.jasig.org> as: pbe...@gmail.com <mailto:pbe...@gmail.com> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user > -- > You are currently subscribed to cas-user@lists.jasig.org as: > jeff.cha...@uni.edu > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user - -- Jeff Chapin, Assistant Systems/Applications Administrator ITS-IS, University of Northern Iowa Phone: 319-273-3162 Email: jeff.cha...@uni.edu -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAkvMmNwACgkQQiaEUfQoY7QZUQCePNY7A0piEBjYcWpc66ruVRAY xf0An0uEdxlYQ1pUXhopKEP5GZ1wUUx+ =jQl3 -----END PGP SIGNATURE----- -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
