Michael, In the CAS configuration file https://www.ja-sig.org/svn/cas3/trunk/cas-server-webapp/src/main/webapp/WEB-INF/cas.properties
You need to specify the dialect for your database. Did you do that? Cheers, Scott On Thu, Mar 18, 2010 at 5:51 PM, Percival, Michael E < [email protected]> wrote: > 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 > > -- 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
