You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Chandra Sunkara (JIRA)" <je...@jakarta.apache.org> on 2004/12/08 21:38:16 UTC
[jira] Created: (JS2-171) table capability is a reserved word in sybase
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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
[jira] Closed: (JS2-171) table capability is a reserved word in
sybase
Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
[ 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