[opencms-dev] Tables could not be created using ANSI SQL-92 (generic)

[Michael Moossen]

Hi, Clovis!

> There is a way to change scripts to be compatible with another database?
> I'm using SapDB (www.sapdb.org) or (www.mysql.com/maxdb).
copy a ${OPENCMS_HOME}/setup/database/${DB_PROVIDER}/ folder and modify the
scripts to fit your needs.

-- 
Regards
Michael Moossen

Alkacon Software - The OpenCms Experts


Quoting Clovis Wichoski <clovis.wichoski at gmail.com>:

> Hi,
> 
> Using Setup Wizard i'm getting the follow message:
> 
> 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.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 45):
> Missing delimiter: ) at
> com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
> at
> com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:768)
> at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434)
> at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:325)
> at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:681)
> at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725)
> at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:219)
> at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:186)
> at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:454)
> at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:363) at
> org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:426) at
> org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:142) 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:210)
> 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:256)
> 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:171)
> 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:594)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
> at java.lang.Thread.run(Thread.java:534)
> -------------------------------------------
> 
> There is a way to change scripts to be compatible with another database?
> 
> I'm using SapDB (www.sapdb.org) or (www.mysql.com/maxdb).
> 
> Thanks
> 
> Clóvis
> 
> 
> _______________________________________________
> 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
> 


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.