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]
