I have CAS connecting to an SQL Server 2005 machine. Now it tries to create the tables when the application starts up, but most of the SQL commands fail due to the blob datatype not found or syntax errors. Is there an update or some change I can make?
Below is some output from my stdout log. Thanks, Michael Percival <Unsuccessful: create table RegisteredServiceImpl (id bigint not null auto_increment, allowedToProxy bit not null, anonymousAccess bit not null, description varchar(255), enabled bit not null, evaluation_order integer not null, ignoreAttributes bit not null, name varchar(255), serviceId varchar(255), ssoEnabled bit not null, theme varchar(255), primary key (id))> <Incorrect syntax near 'auto_increment'.> <Unsuccessful: create table SERVICETICKET (ID varchar(255) not null, NUMBER_OF_TIMES_USED integer, CREATION_TIME bigint, EXPIRATION_POLICY blob not null, LAST_TIME_USED bigint, PREVIOUS_LAST_TIME_USED bigint, FROM_NEW_LOGIN bit not null, TICKET_ALREADY_GRANTED bit not null, SERVICE blob not null, ticketGrantingTicket_ID varchar(255), primary key (ID))> <Column, parameter, or variable #4: Cannot find data type blob.> <Unsuccessful: create table TICKETGRANTINGTICKET (ID varchar(255) not null, NUMBER_OF_TIMES_USED integer, CREATION_TIME bigint, EXPIRATION_POLICY blob not null, LAST_TIME_USED bigint, PREVIOUS_LAST_TIME_USED bigint, AUTHENTICATION blob not null, EXPIRED bit not null, SERVICES_GRANTED_ACCESS_TO blob not null, ticketGrantingTicket_ID varchar(255), primary key (ID))> <Column, parameter, or variable #4: Cannot find data type blob.> <Unsuccessful: alter table SERVICETICKET add index FK7645ADE132A2C0E5 (ticketGrantingTicket_ID), add constraint FK7645ADE132A2C0E5 foreign key (ticketGrantingTicket_ID) references TICKETGRANTINGTICKET (ID)> <Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.> <Unsuccessful: alter table TICKETGRANTINGTICKET add index FKB4C4CDDE32A2C0E5 (ticketGrantingTicket_ID), add constraint FKB4C4CDDE32A2C0E5 foreign key (ticketGrantingTicket_ID) references TICKETGRANTINGTICKET (ID)> <Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.> <Unsuccessful: alter table rs_attributes add index FK4322E15F0C8D661 (RegisteredServiceImpl_id), add constraint FK4322E15F0C8D661 foreign key (RegisteredServiceImpl_id) references RegisteredServiceImpl (id)> <Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.> -- 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
