[ http://issues.apache.org/jira/browse/JS2-171?page=all ]
Ate Douma closed JS2-171:
-------------------------
Resolution: Won't Fix
I don't know if indeed capability is a sybase reserved word, but you could
"solve" this by modifying the OJB related metadata configuration (look at
capabilities_repository.xml) of the capability component, and then change the
table name in the generated phase1-schema.sql script.
> table capability is a reserved word in sybase
> ---------------------------------------------
>
> Key: JS2-171
> URL: http://issues.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://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
