Fixed. Thanks
Michael A. Timony -----Original Message----- From: Timony, Michael Sent: Wednesday, December 13, 2006 6:38 PM To: '[email protected]' 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 [EMAIL PROTECTED]: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
