juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Toufic Arabi (JIRA)" <juddi-...@ws.apache.org>
Subject [jira] [Commented] (JUDDI-662) Name length of j3_signature_transform_data_value too long
Date Tue, 22 Oct 2013 13:50:43 GMT

    [ https://issues.apache.org/jira/browse/JUDDI-662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13801817#comment-13801817
] 

Toufic Arabi commented on JUDDI-662:
------------------------------------

Alex,

As suspected:

RHQADMIN@GCCS:owl>     create table j3_signature_transform_data_val (
  2  	     id number(19,0) not null,
  3  	     content_bytes blob,
  4  	     content_type varchar2(255 char),
  5  	     signature_transform_key number(19,0) not null,
  6  	     primary key (id)
  7  	 );
    create table j3_signature_transform_data_val (
                 *
ERROR at line 1:
ORA-00972: identifier is too long 

RHQADMIN@GCCS:owl>     alter table j3_signature_transform_data_val
  2  	     add constraint FK3242526C7B88B2A4
  3  	     foreign key (signature_transform_key)
  4  	     references j3_signature_transform;
    alter table j3_signature_transform_data_val
                *
ERROR at line 1:
ORA-00972: identifier is too long 

Thanks!

> Name length of j3_signature_transform_data_value too long
> ---------------------------------------------------------
>
>                 Key: JUDDI-662
>                 URL: https://issues.apache.org/jira/browse/JUDDI-662
>             Project: jUDDI
>          Issue Type: Bug
>    Affects Versions: 3.2
>         Environment: EAP 6.1.1, Oracle 11g, RHEL 6.4, Open JPA
>            Reporter: Toufic Arabi
>            Assignee: Alex O'Ree
>             Fix For: 3.2
>
>
> When creating tables, the following fails because the table name is too long
>  create table j3_signature_transform_data_value (
>          id number(19,0) not null,
>          content_bytes blob,
>          content_type varchar2(255 char),
>           signature_transform_key number(19,0) not null,
>           primary key (id)
>          );
> create table j3_signature_transform_data_value (
>                    *
>  ERROR at line 1:
> ORA-00972: identifier is too long
> additional reference: https://issues.jboss.org/browse/JBESB-3889



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message