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

Mon Apr 4 10:27:01 CEST 2005

Hi Rivero

I tried using both the drivers jConnect-5_5 and jConnect-6_0 packaged
with Sybase distributable. 

Please let me know the location of MSSQLserver's so that I can try that.

Regards

Tarun

________________________________

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Henry Rivero
Sent: Monday, April 04, 2005 1:15 PM
To: The OpenCms mailing list
Subject: RE: [opencms-dev] Configuration on Sybase (Please Consider this
asurgent)

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.ja
va: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(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
5) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172) at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 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.i
nvokeNext(StandardPipeline.java:643) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 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:43
2) at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:386) at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:53
4) 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/e7aef792/attachment.htm>