[opencms-dev] Configuration on Sybase (Please Consider this as urgent)

[Tarun Gupta]

Hi All
 
Do we know for sure that opencms works on Sybase ? If yes then which version of opencms has been tested for sybase ?
 
When I am trying to run the setup (to create database) with opencms_5.0.1 with database selected as Generic (ANSI) SQL, There is no way I can specify the driver class name for sybase. It is using the Oracle driver by default which I dont think will be useful to connect to Sybase.
 
When I am trying to configure for opencms_6.0_beta_1, This allows me to specify the driver class name but I am getting following exception while running the setup
 
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.jdbc3.jdbc.SybSQLException: Incorrect syntax near 'RAW'. at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:2942) at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2246) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(SybStatement.java:1868) at com.sybase.jdbc3.jdbc.SybStatement.execute(SybStatement.java:1860) at com.sybase.jdbc3.jdbc.SybStatement.execute(SybStatement.java:865) 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.step_5_database_creation_jsp._jspService(step_5_database_creation_jsp.java:346) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:534) 
-------------------------------------------
 
Regards
Tarun