Added to email below, I think I covered all bases to change the dialect to Oracle but to no luck.
Any guidance on where else to look? Thank you. [cas@cas1 WEB-INF]$ grep dialect * cas.properties:database.hibernate.dialect=org.hibernate.dialect.OracleDialect cas.properties:# database.hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect cas.properties:# database.hibernate.dialect=org.hibernate.dialect.HSQLDialect cas.properties:database.dialect=org.hibernate.dialect.OracleDialect deployerConfigContext.xml: <prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop> On Sun, Sep 16, 2012 at 11:25 AM, Myn Harry <[email protected]> wrote: > Hello All: > > I am doing something not quite correct but am stymied on next steps. > > I am deploying CAS3.5 in a Tomcat container; the configs are set to point > to a local Oracle 11.3g database. > > When Tomcat is started the following message is capture in the > 'catalina.out' log files; looking at the database, two table were > successfully created: 'LOCKS' and 'RA_ATTRIBUTES'. > > I double checked the configuration in the 'deployerConfigContext.xml' file > and the driver etc were for Oracle. > > Any tips on where to look next? Thanks. > > > > 2012-09-16 11:11:12,853 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <HHH000388: Unsuccessful: create table RegisteredServiceImpl > (expression_type VARCHAR(15) DEFAULT 'ant' not null, id number(19,0) not > null, allowedToProxy boolean not null, anonymousAccess boolean not null, > description varchar2(255), enabled boolean not null, evaluation_order > number(10,0) not null, ignoreAttributes boolean not null, name > varchar2(255), serviceId varchar2(255), ssoEnabled boolean not null, theme > varchar2(255), primary key (id))> > 2012-09-16 11:11:12,854 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <ORA-00902: invalid datatype > > > 2012-09-16 11:11:12,856 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <HHH000388: Unsuccessful: create table SERVICETICKET (ID varchar2(255) not > null, NUMBER_OF_TIMES_USED number(10,0), CREATION_TIME number(19,0), > EXPIRATION_POLICY blob not null, LAST_TIME_USED number(19,0), > PREVIOUS_LAST_TIME_USED number(19,0), FROM_NEW_LOGIN boolean not null, > TICKET_ALREADY_GRANTED boolean not null, SERVICE blob not null, > ticketGrantingTicket_ID varchar2(255), primary key (ID))> > 2012-09-16 11:11:12,856 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <ORA-00902: invalid datatype > > > 2012-09-16 11:11:12,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <HHH000388: Unsuccessful: create table TICKETGRANTINGTICKET (ID > varchar2(255) not null, NUMBER_OF_TIMES_USED number(10,0), CREATION_TIME > number(19,0), EXPIRATION_POLICY blob not null, LAST_TIME_USED number(19,0), > PREVIOUS_LAST_TIME_USED number(19,0), AUTHENTICATION blob not null, EXPIRED > boolean not null, SERVICES_GRANTED_ACCESS_TO blob not null, > ticketGrantingTicket_ID varchar2(255), primary key (ID))> > 2012-09-16 11:11:12,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <ORA-00902: invalid datatype > -- 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
