[opencms-dev] Sybase 12.5 + OpenCMS 6 + jConnect 5.5

[Matthias Jakob]

Hi there!

I try to install OpenCMS 6 on Sybase bit i get the following error:  
(can i edit the sql script, where is the sql script ...??)

Tables could not be created!
Error executing SQL statement: CREATE TABLE CMS_USERS ( USER_ID  
VARCHAR2(36) NOT NULL, USER_NAME VARCHAR2(64) NOT NULL, USER_PASSWORD  
VARCHAR2(32) NOT NULL, USER_DESCRIPTION VARCHAR2(255) NOT NULL,  
USER_FIRSTNAME VARCHAR2(50) NOT NULL, USER_LASTNAME VARCHAR2(50) NOT  
NULL, USER_EMAIL VARCHAR2(100) NOT NULL, USER_LASTLOGIN DATE NOT  
NULL, USER_FLAGS INT NOT NULL, USER_INFO LONG RAW, USER_ADDRESS  
VARCHAR2(100) NOT NULL, USER_TYPE INT NOT NULL, PRIMARY KEY(USER_ID),  
UNIQUE(USER_NAME) )
-------------------------------------------
com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near 'RAW'.  
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535) at  
com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1916) at  
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)  
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java: 
201) at com.sybase.jdbc2.jdbc.SybStatement.nextResult 
(SybStatement.java:182) at  
com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java: 
1596) at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java: 
1588) at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java: 
766) at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java: 
405) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:331)  
at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:266) at  
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:183) at  
org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspServic 
e(step_005f5_005fdatabase_005fcreation_jsp.java:351) at  
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:105)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:860) at  
org.apache.jasper.servlet.JspServletWrapper.service 
(JspServletWrapper.java:336) at  
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: 
301) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java: 
251) at javax.servlet.http.HttpServlet.service(HttpServlet.java:860)  
at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at  
sun.reflect.DelegatingMethodAccessorImpl.invoke 
(DelegatingMethodAccessorImpl.java:25) at  
java.lang.reflect.Method.invoke(Method.java:324) at  
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java: 
249) at java.security.AccessController.doPrivileged(Native Method) at  
javax.security.auth.Subject.doAsPrivileged(Subject.java:500) at  
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java: 
282) at org.apache.catalina.security.SecurityUtil.doAsPrivilege 
(SecurityUtil.java:165) at  
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
(ApplicationFilterChain.java:257) at  
org.apache.catalina.core.ApplicationFilterChain.access$000 
(ApplicationFilterChain.java:55) at  
org.apache.catalina.core.ApplicationFilterChain$1.run 
(ApplicationFilterChain.java:161) at  
java.security.AccessController.doPrivileged(Native Method) at  
org.apache.catalina.core.ApplicationFilterChain.doFilter 
(ApplicationFilterChain.java:157) at  
org.apache.catalina.core.StandardWrapperValve.invoke 
(StandardWrapperValve.java:263) at  
org.apache.catalina.core.StandardPipeline.invoke 
(StandardPipeline.java:551) at  
org.apache.catalina.core.StandardContextValve.invokeInternal 
(StandardContextValve.java:225) at  
org.apache.catalina.core.StandardContextValve.invoke 
(StandardContextValve.java:173) at  
org.apache.catalina.core.StandardPipeline.invoke 
(StandardPipeline.java:551) at  
org.apache.catalina.core.StandardHostValve.invoke 
(StandardHostValve.java:161) at  
org.apache.catalina.core.StandardPipeline.invoke 
(StandardPipeline.java:551) at  
org.apache.catalina.core.StandardEngineValve.invoke 
(StandardEngineValve.java:132) at  
org.apache.catalina.core.StandardPipeline.invoke 
(StandardPipeline.java:551) at  
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)  
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: 
185) at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process 
(ProcessorTask.java:653) at  
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process 
(ProcessorTask.java:534) at  
com.sun.enterprise.web.connector.grizzly.ProcessorTask.doTask 
(ProcessorTask.java:403) at  
com.sun.enterprise.web.connector.grizzly.WorkerThread.run 
(WorkerThread.java:55)
-------------------------------------------

Thank you!