>>sigh< Still getting the error the first time the registry cleaner runs:
> locks table doesn't exist.

Mea culpa.  I gave you bad information.  I was puzzled about your
continued difficulty, so I consulted source and the answer was right
there in the javadocs:

 * This class requires a backing database table to exist based on the
 * following template:
 * <pre>
 * 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);
 * </pre>

I should note that this feature doesn't use JPA, so we can't leverage
the typical Hibernate create/drop DDL feature.  I have updated
https://wiki.jasig.org/display/CASUM/JpaTicketRegistry with this
information.  Thanks for your earlier edit and patience setting this
up.  Hopefully this is it.

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

Reply via email to