I'm not an expert on Hibernate Oracle dialects, but you may want to try: http://docs.jboss.org/hibernate/core/3.6/javadocs/org/hibernate/dialect/Oracle10gDialect.html
On Sun, Sep 16, 2012 at 2:34 PM, Myn Harry <[email protected]> wrote: > 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 > > -- 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
