portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ate Douma (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Closed: (JS2-171) table capability is a reserved word in sybase
Date Thu, 13 Apr 2006 17:56:00 GMT
     [ 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: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message