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

[Henry Rivero]

Hi,
 
maybe this helps:
well, at first... make sure you use the right driver.
as far as the script is concerned, you might try running the MS SQLserver script for opencms. It's floating about somewhere. MSSQLserver's syntax is pretty close to Sybase (T-SQL).
 
Henry Rivero
tentendigital
(t) +44-20-7798 9292
(m) +44-7717-280 964
 

	-----Original Message----- 
	From: Tarun Gupta [mailto:Tarun_Gupta at infosys.com] 
	Sent: Mon 04/04/2005 06:31 
	To: opencms-dev at opencms.org 
	Cc: 
	Subject: [opencms-dev] Configuration on Sybase (Please Consider this asurgent)
	
	

	
	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
	


_____________________________________________________________________
For your protection, this email has been scanned for all known viruses by tenten digital's service provider Message Labs. Please see disclaimer for further information.   If you have received this e-mail in error, please e-mail info at tentendigital.com or phone 020 7798 9292.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 7286 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050404/95198d20/attachment.bin>