Thanks for the information. I hadn't made the change in cas.properties. When I changed it to org.hibernate.dialect.SQLServerDialect, it didn't seem to make any difference. I then found the setting in ticketRegistry.xml to set the dialect. When I also changed it to org.hibernate.dialect.SQLServerDialect, the tables were created successfully.
--Michael From: Scott Battaglia [mailto:[email protected]] Sent: Thursday, March 18, 2010 7:04 PM To: [email protected] Subject: Re: [cas-user] Connecting CAS to SQL Server 2005 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]<mailto:[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]<mailto:[email protected]> as: [email protected]<mailto:[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
