table capability is a reserved word in sybase
---------------------------------------------
Key: JS2-171
URL: http://nagoya.apache.org/jira/browse/JS2-171
Project: Jetspeed 2
Type: Wish
Environment: windows 2000, tomcat 5.x, sql anywhere 9.0
Reporter: Chandra Sunkara
Priority: Minor
I was trying to install jetspeed-2 onto tomcat 5.0, sql anywhere 9.0 (aka
sybase) and came accross following error.
db.execute:
[sql] Executing file: C:\Tools\jakarta\jakarta-jetspeed-2\target\src\sql\syb
ase\phase1-schema.sql
[sql] [ERROR] Failed to execute: IF EXISTS (SELECT 1 FROM sysobjects WHERE t
ype = 'U' AND name = 'CAPABILITY') BEGIN DROP TABLE CAPABILITY END
BUILD FAILED
File...... C:\Tools\jakarta\jakarta-jetspeed-2\maven.xml
Element... sql
Line...... 372
Column.... 39
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131: Syntax error near 'CAPABI
LITY' on line 1
Total time: 8 seconds
After looking through sybase site seems like capability is a sysbase reserved
word and hence would not create table. Please ignore if this is already a known
issue.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
