The allowedAttributes table is an additional table that stores which attributes are mapped to a service. Unfortunately we're allowing Hibernate to generate the table names instead of explicitly specifying them. I'm surprised hibernate won't generate appropriate sized ones though. You can open a JIRA issue for this and we'll take a look though I can't promise I know how to fix it other than specifically naming the table which would break backwards compatibility. :-/
-Scott -Scott Battaglia PGP Public Key Id: 0x383733AA LinkedIn: http://www.linkedin.com/in/scottbattaglia On Tue, Sep 30, 2008 at 3:23 PM, Chuck Pearson <[EMAIL PROTECTED]>wrote: > I'm really new to CAS and Service Management but can someone tell me how > to use the Oracle10gDialect. I am attempting to add my first service and I > get these errors when attempting to create Oracle database tables. > > I can create the REGISTEREDSERVICEIMPL, SERVICETICKET, & > TICKETGRANTINGTICKET tables just fine, but my table name is too long for. > " > 2008-09-30 14:16:27,376 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <create table RegisteredServiceImpl_allowedAttributes > (RegisteredServiceImpl_id number(19,0) not null, element varchar2(255 char), > allowed_attribute_id number(10,0) not null, primary key > (RegisteredServiceImpl_id, allowed_attribute_id))> > 2008-09-30 14:16:27,391 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <Unsuccessful: create table RegisteredServiceImpl_allowedAttributes > (RegisteredServiceImpl_id number(19,0) not null, element varchar2(255 char), > allowed_attribute_id number(10,0) not null, primary key > (RegisteredServiceImpl_id, allowed_attribute_id))> > 2008-09-30 14:16:27,391 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - > <ORA-00972: identifier is too long > " > > I was expecting the table name to be just " RegisteredServiceImpl " but it > seems to default to the above longer name which is greater than 30 > characters. > > Thanks for any and all suggestions. > Chuck > > _______________________________________________ > Yale CAS mailing list > [email protected] > http://tp.its.yale.edu/mailman/listinfo/cas > >
_______________________________________________ Yale CAS mailing list [email protected] http://tp.its.yale.edu/mailman/listinfo/cas
