You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tapestry.apache.org by Franz Amador <fg...@yahoo.com> on 2008/01/08 23:23:31 UTC
T5: Acegi table name too long for Oracle 9i
I'm using the tapestry5-acegi module (v 1.0.2, Tapestry v 5.0.7), and I get an error when Hibernate tries to create tables in Oracle 9i:
14:09:42.234 ERROR! [main] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:155) >55> Unsuccessful: create table UserDetailsBean_GrantedAuthorityBean (UserDetailsBean_id number(19,0) not null, grantedAuthorities_id number(19,0) not null, unique (grantedAuthorities_id))
14:09:42.234 ERROR! [main] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:156) >55> ORA-00972: identifier is too long
Am I out of luck? Surely people have run Acegi on Oracle 9i before, so I presume this error relates to tapestry5-acegi, not Acegi in general.
Re: T5: Acegi table name too long for Oracle 9i
Posted by Daniel Jue <te...@gmail.com>.
This seems more like Hibernate's problem. I'm not defending 9i's
<www.urbandictionary.com>failboating</www.urbandictionary.com> in
character limits. (What is this, 1994?)
I haven't played with this module, but perhaps you can specify the
name of the table in an annotation (if you are using Hibernate
Annotations) or in an XML file? Just specify a shorter name instead
of the auto-created name. Expect this to happen with field names too,
so you may need to override field names using whatever hibernate
mapping method you are using.
On Jan 8, 2008 5:23 PM, Franz Amador <fg...@yahoo.com> wrote:
> I'm using the tapestry5-acegi module (v 1.0.2, Tapestry v 5.0.7), and I get an error when Hibernate tries to create tables in Oracle 9i:
>
> 14:09:42.234 ERROR! [main] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:155) >55> Unsuccessful: create table UserDetailsBean_GrantedAuthorityBean (UserDetailsBean_id number(19,0) not null, grantedAuthorities_id number(19,0) not null, unique (grantedAuthorities_id))
> 14:09:42.234 ERROR! [main] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:156) >55> ORA-00972: identifier is too long
>
> Am I out of luck? Surely people have run Acegi on Oracle 9i before, so I presume this error relates to tapestry5-acegi, not Acegi in general.
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org