<br><font size=2 face="sans-serif">Perhaps, Sybase does not support the LONG RAW data type?</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Tarun Gupta" <Tarun_Gupta@infosys.com></b></font>
<br><font size=1 face="sans-serif">Sent by: opencms-dev-bounces@opencms.org</font>
<p><font size=1 face="sans-serif">04/04/2005 01:31 PM</font>
<br><font size=1 face="sans-serif">Please respond to The OpenCms mailing list</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: <opencms-dev@opencms.org></font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: [opencms-dev] Configuration on Sybase (Please Consider this as urgent)</font></table>
<br>
<br>
<br><font size=2 face="Courier New"> <br>
Hi All<br>
<br>
Do we know for sure that opencms works on Sybase ? If yes then which version of opencms has been tested for sybase ?<br>
<br>
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.<br>
<br>
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<br>
<br>
Tables could not be created!<br>
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) )<br>
-------------------------------------------<br>
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) <br>
-------------------------------------------<br>
<br>
Regards<br>
Tarun<br>
<br>
<br>
<br>
_______________________________________________<br>
This mail is send to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
http://mail.opencms.org/mailman/listinfo/opencms-dev<br>
</font>
<br>
<br>