portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timony, Michael" <Michael.Tim...@FMR.COM>
Subject RE: SSO_SITE_TO_PRINCIPALS_FK_SITE_ID_SSO_SITE to long for Oracle?
Date Mon, 18 Dec 2006 13:42:09 GMT
Fixed.

Thanks 


Michael A. Timony


-----Original Message-----
From: Timony, Michael 
Sent: Wednesday, December 13, 2006 6:38 PM
To: 'jetspeed-dev@portals.apache.org'
Cc: 'David Sean Taylor'
Subject: SSO_SITE_TO_PRINCIPALS_FK_SITE_ID_SSO_SITE to long for Oracle?

Looks like a constraint that was just added to the security-schema.sql
that is too long for Oracle to handle?

I just grabbed the latest source from subversion, 475954, compiled and
populated my .m2. I then created a custom portal, and when I try and
deploy it to Tomcat with an Oracle XE (Express Edition) database I get
the following errors:

[sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\se
curity-schema.sql
[sql] Failed to execute:         ALTER TABLE SSO_SITE_TO_PRINCIPALS ADD
CONSTRAINT SSO_SITE_TO_PRINCIPALS_FK_SITE_ID_SSO_SITE FOREIGN KEY
(SITE_ID) REFERENCES SSO_SITE (SITE_ID) ON DELETE CASCADE
...
Embedded error: The following error occurred while executing this line:
C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\build.xml:284: The
following error occurred while executing this line:
C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\build.xml:340:
java.sql.SQLException: ORA-00972: identifier is too long

I also tested against Tomcat & Derby and it works without errors.


See below for the full output when I try and deploy to Tomcat & Oracle,
apologies if the line wrapping is messed up.

mvn -o -P tomcat
[INFO]
NOTE: Maven is executing in offline mode. Any artifacts not already in
your local repository will be inaccessible.

[INFO] Scanning for projects...
[INFO] Reactor build order:
[INFO]   etag-portal-test-1 Portal
[INFO]   etag-portal-test-1 Portal Database
[INFO]   etag-portal-test-1 Portal Components
[INFO]   etag-portal-test-1 Portal Applications
[INFO]   etag-portal-test-1 Portal WAR
[INFO]   etag-portal-test-1 Portal Application Server Deployment
[INFO]
------------------------------------------------------------------------
----
[INFO] Building etag-portal-test-1 Portal
[INFO]    task-segment: [install]
[INFO]
------------------------------------------------------------------------
----
[INFO] [site:attach-descriptor]
[INFO] [install:install]
[INFO] Installing C:\Documents and
Settings\A268412\Desktop\etag-portal-test-1\pom.xml to C:\Documents and
Settings\USER\.m2\repository\bluesunrise\etag-portal-test-1\1.0\etag-por
tal-test-1-1.0.po

[INFO]
------------------------------------------------------------------------
----
[INFO] Building etag-portal-test-1 Portal Database
[INFO]    task-segment: [install]
[INFO]
------------------------------------------------------------------------
----
[WARNING]
        Artifact ant:ant:jar:1.6.5:runtime retains local scope 'runtime'
overriding broader scope '
ompile'
        given by a dependency. If this is not intended, modify or remove
the local scope.

[WARNING]
        Artifact org.apache.maven:maven-project:jar:2.0.1:runtime
retains local scope 'runtime' ove riding broader scope 'compile'
        given by a dependency. If this is not intended, modify or remove
the local scope.

[INFO] [antrun:run {execution: etc-schema}] [INFO] Executing tasks

clean-schema:
   [delete] Deleting directory C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql

test-database-default-name:

test-database-filter-drops:

test-database-target-sql:

schema:
    [mkdir] Created dir: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle
     [copy] Copying 3 files to C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\taret\sql\oracle
     [copy] Copying C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\sql\populate-d-default.sql
to C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\
opulate-db-default.sql
     [copy] Copying C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\sql\populate-userinfo-for-d
efault-psml.sql to C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\populate-
userinfo-for-default-psml.sql
     [copy] Copying C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\sql\drop.sql to
C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\drop.sql

schema-mssql:

schema-mysql:

schema-oracle:

check-use-classpath:

check-run-only-on-schema-change:

sql-check:

torque-gen:

sql-classpath:
[torque-sql] Using classpath
[torque-sql] Generating to file C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\re
port.phase1.sql.generation
[INFO] XmlToAppData - Parsing file: 'phase1-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package
[INFO] XmlToAppData - Parsing file: 'phase2-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package
[INFO] XmlToAppData - Parsing file: 'phase3ojb-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package
[INFO] XmlToAppData - Parsing file: 'prefs-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package
[INFO] XmlToAppData - Parsing file: 'registry-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package
[INFO] XmlToAppData - Parsing file: 'security-schema.xml'
[INFO] DTDResolver - Resolver: used database.dtd from
'org.apache.torque.engine.database.transform'package

sql-template:

schema-hsql:

schema-postgres:

schema-sapdb:

schema-derby:

schema-filter-drops:
     [copy] Copying 1 file to C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle
     [copy] Copying C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\sql\oracle\populate-userinf
o-for-default-psml.sql to C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\populate-
userinfo-for-default-psml.sql
[INFO] Executed tasks
[INFO] [site:attach-descriptor]
[INFO] [install:install]
[INFO] Installing C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\pom.xml to C:\Documents and
Settings\USER\.m2\repository\bluesunrise\portal-etc\1.0\portal-etc-1.0.p
om
[INFO] [antrun:run {execution: etc-populate-production}] [INFO]
Executing tasks

test-populate-skip:

populate-db:

sql-test-database-classpath:

sql-execute-drivers-path:
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\drop.sql
      [sql] 83 of 83 SQL statements executed successfully

sql-execute-derby:

sql-execute-hsql:

sql-execute:

sql-test-database-classpath:

sql-execute-drivers-path:
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\ph
ase1-schema.sql
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\ph
ase2-schema.sql
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\ph
ase3ojb-schema.sql
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\pr
efs-schema.sql
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\re
gistry-schema.sql
      [sql] Executing file: C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\target\sql\oracle\schema\se
curity-schema.sql
      [sql] Failed to execute:         ALTER TABLE
SSO_SITE_TO_PRINCIPALS ADD CONSTRAINT
SSO_SITE_TO_PRINCIPALS_FK_SITE_ID_SSO_SITE FOREIGN KEY (SITE_ID)
REFERENCES SSO_SITE (SITE_ID) ON DELETE CASCADE
[INFO]
------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error executing ant tasks

Embedded error: The following error occurred while executing this line:
C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\build.xml:284: The
following error occurred while executing this line:
C:\Documents and
Settings\USER\Desktop\etag-portal-test-1\etc\build.xml:340:
java.sql.SQLException: ORA-00972: identifier is too long

BTW, can't seem to be able to join the Dev list. I get this response
when I e-mail jetspeed-dev-help@portals.apache.org:

      jetspeed-dev-help@portals.apache.org on 12/13/2006 6:20 PM
            The message could not be delivered because the recipient's
mailbox is full.
            < maillnx-us111.fmr.com #5.2.2 SMTP; 552 spam score (5.8)
exceeded threshold>


Mick Timony


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message