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

[csong at toshiba.com.sg]

Perhaps, Sybase does not support the LONG RAW data type?





"Tarun Gupta" <Tarun_Gupta at infosys.com>
Sent by: opencms-dev-bounces at opencms.org
04/04/2005 01:31 PM
Please respond to The OpenCms mailing list

 
        To:     <opencms-dev at opencms.org>
        cc: 
        Subject:        [opencms-dev] Configuration on Sybase (Please Consider this as  urgent)


 
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
 


_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050404/483b25cd/attachment.htm>