<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>[opencms-dev] Configuration on Sybase (Please Consider this asurgent)</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Rivero<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I tried using both the drivers jConnect-5_5
and jConnect-6_0 packaged with Sybase distributable. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Please let me know the location of </span></font>MSSQLserver's
so that I can try that.<o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Tarun</span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Henry Rivero<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, April 04, 2005 1:15
PM<br>
<b><span style='font-weight:bold'>To:</span></b> The OpenCms mailing list<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [opencms-dev]
Configuration on Sybase (Please Consider this asurgent)</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi,<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>maybe this helps:<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>well, at first... make sure you use the right driver.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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).<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Henry Rivero<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 color="#9999ff" face="Arial Black"><span
style='font-size:12.0pt;font-family:"Arial Black";color:#9999FF'>ten</span></font><font
color="#6666cc" face="Arial Black"><span style='font-family:"Arial Black";
color:#6666CC'>ten</span></font><font color="#000066" face="Arial Black"><span
style='font-family:"Arial Black";color:#000066'>digital</span></font><font
color="#000066"><span style='color:#000066'><br>
</span></font><strong><b><font size=2 color="#000066" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#000066'>(t) </span></font></b></strong><font
size=2 color="#000066" face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:#000066'>+44-20-7798 9292</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><strong><b><font size=2 color="#000066" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#000066'>(m) </span></font></b></strong><font
size=2 color="#000066" face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:#000066'>+44-7717-280 964</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2
face="Times New Roman"><span style='font-size:10.0pt'>-----Original
Message----- <br>
<b><span style='font-weight:bold'>From:</span></b> Tarun Gupta
[mailto:Tarun_Gupta@infosys.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Mon 04/04/2005 06:31 <br>
<b><span style='font-weight:bold'>To:</span></b> opencms-dev@opencms.org <br>
<b><span style='font-weight:bold'>Cc:</span></b> <br>
<b><span style='font-weight:bold'>Subject:</span></b> [opencms-dev]
Configuration on Sybase (Please Consider this asurgent)</span></font><o:p></o:p></p>
</div>
<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'><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>
<a href="http://mail.opencms.org/mailman/listinfo/opencms-dev">http://mail.opencms.org/mailman/listinfo/opencms-dev</a></span></font><o:p></o:p></p>
</blockquote>
</div>
</body>
</html>