We need to make the change because without the cleanup our database will just continue to grow and that doesn't sound like a "good thing".
I am not sure how our DBAs are going to make this fix, they are talking about doing an alter. -Bryan -----Original Message----- From: Juan Quintanilla [mailto:[email protected]] Sent: Tuesday, January 10, 2012 8:40 AM To: [email protected] Subject: RE: [cas-user] CAS slow today Bryan, So you are performing an alter table to modify the datatype for the expiration_date. Are you just making the change to improve the response time or so that you don't see the nested exception error in the logs. Thanks! ___________________ Juan Quintanilla UTS - Enterprise Group 305-348-6573 [email protected] ________________________________________ From: Bryan E. Wooten [[email protected]] Sent: Tuesday, January 10, 2012 10:36 AM To: [email protected] Subject: RE: [cas-user] CAS slow today It looks like the doc here (https://wiki.jasig.org/display/CASUM/JpaTicketRegistry) is missing that important piece of information for Oracle Ticket Registries: CREATE TABLE LOCKS ( APPLICATION_ID VARCHAR(50) NOT NULL, UNIQUE_ID VARCHAR(50) NULL, EXPIRATION_DATE TIMESTAMP NULL ); ALTER TABLE LOCKS ADD CONSTRAINT LOCKS_PK PRIMARY KEY (APPLICATION_ID); -----Original Message----- From: Bryan E. Wooten [mailto:[email protected]] Sent: Tuesday, January 10, 2012 8:06 AM To: [email protected] Subject: RE: [cas-user] CAS slow today Yep, It looks like my DBAs got the DDL wrong. I did a desc on the locks table and it is a TIMESTAMP and not DATE. Thanks! -Bryan -----Original Message----- From: Marvin Addison [mailto:[email protected]] Sent: Tuesday, January 10, 2012 7:58 AM To: [email protected] Subject: Re: [cas-user] CAS slow today > nested exception is java.lang.ClassCastException: oracle.sql.TIMESTAMP > cannot be cast to java.sql.Timestamp Pretty sure your LOCKS table has at least one wrong field datatype for JdbcLockingStrategy. Here's the DDL we used when we ran on Oracle (10g?): CREATE TABLE LOCKS ( APPLICATION_ID VARCHAR2(50) NOT NULL, UNIQUE_ID VARCHAR2(50) NULL, /** Must use DATE instead of TIMESTAMP on Oracle to prevent ClassCastException as discussed in SPR-4886 */ EXPIRATION_DATE DATE NULL ); ALTER TABLE LOCKS ADD CONSTRAINT LOCKS_PK PRIMARY KEY (APPLICATION_ID) ENABLE; I would imagine your EXPIRATION_DATE is a TIMESTAMP column instead of DATE as required on Oracle. M -- 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-user -- 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-user -- 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-user -- 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-user -- 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-user
