<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT face=Arial
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm new to OpenCms, so first of all I installed it
normally (Win2000 + Tomcat + MySQL) just to learn how it works.</FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><FONT face=Arial
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2>Since I'm passed that, I want to install OpenCms
6.0.3 with Sybase ASE. I use jconnect 6 as driver, I can create the tables ok,
but when it's time to setup the modules I get the following
error:</FONT></DIV><FONT face=Arial size=2>
<DIV> </DIV>
<DIV> Caused by: com.sybase.jdbc2.jdbc.SybSQLException:
Operand type clash: INT is incompatible with DATETIME</DIV>
<DIV> 27: ... 8 more</DIV>
<DIV> 26: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:642)</DIV>
<DIV> 25: at
org.opencms.db.generic.CmsUserDriver.fillDefaults(CmsUserDriver.java:1631)</DIV>
<DIV> 24: at
org.opencms.db.generic.CmsUserDriver.importUser(CmsUserDriver.java:568)</DIV>
<DIV> 23: Caused by: org.opencms.db.CmsDbSqlException: An SQL
error occurred when executing the following query:
com.sybase.jdbc2.jdbc.SybPreparedStatement@e3b9b4. </DIV>
<DIV> 22: ... 7 more</DIV>
<DIV> 21: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4261)</DIV>
<DIV> 20: at
org.opencms.db.generic.CmsUserDriver.init(CmsUserDriver.java:648)</DIV>
<DIV> 19: Caused by: org.opencms.main.CmsInitException:
Critical error during OpenCms initialization: Unable to initialize the user
driver. </DIV>
<DIV> 18: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:155)</DIV>
<DIV> 17: at
org.opencms.main.CmsShell.<init>(CmsShell.java:498)</DIV>
<DIV> 16: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1464)</DIV>
<DIV> 15: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:971)</DIV>
<DIV> 14: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:161)</DIV>
<DIV> 13: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2670)</DIV>
<DIV> 12: at
org.opencms.db.CmsDriverManager.newInstance(CmsDriverManager.java:518)</DIV>
<DIV> 11: at
org.opencms.db.CmsDriverManager.newDriverInstance(CmsDriverManager.java:4271)</DIV>
<DIV> 10: org.opencms.main.CmsInitException: Critical error
while initializing driver "org.opencms.db.generic.CmsUserDriver".</DIV>
<DIV> 9: --------------------</DIV>
<DIV> 8: Giving up, unable to start OpenCms.</DIV>
<DIV> 7: Critical error during OpenCms initialization: Unable
to initialize the user driver. </DIV>
<DIV> 6: The following critical error occured:</DIV>
<DIV> 5: --------------------</DIV>
<DIV> 4: </DIV>
<DIV> 3: </DIV>
<DIV> 2: OpenCms property file:
"/Library/Tomcat/apache-tomcat-5.5.12/webapps/opencms/WEB-INF/config/opencms.properties".</DIV>
<DIV> 1: OpenCms WEB-INF path:
"/Library/Tomcat/apache-tomcat-5.5.12/webapps/opencms/WEB-INF/". </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Already compared SQLs for MySQL and Sybase and it all matches. Can anyone
help?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Joao Dias</DIV>
<DIV> </DIV></FONT></BODY></HTML>