java.sql.SQLException

error in script file line: 33 Unexpected token: SUBSTRING in statement [CREATE ALIAS SUBSTRING]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web9692

  • via Oracle Community by 656909, 1 year ago
    error in script file line: 33 Unexpected token: SUBSTRING in statement [CREATE ALIAS SUBSTRING]
  • via hsqldb by txie
    , 11 months ago
    error in script file line: 1 Unexpected token: SCHEMA in statement \[CREATE SCHEMA\]
  • error in script file line: 1 Unexpected token in statement \[CREATE CACHED TABLE TABLE\_PARAM(ID INTEGER
  • Stack trace

    • java.sql.SQLException: error in script file line: 33 Unexpected token: SUBSTRING in statement [CREATE ALIAS SUBSTRING] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.plumtree.core.om.CollaborationServerMigration.getConnection(CollaborationServerMigration.java:134) at com.plumtree.core.om.CollaborationServerArchiveMetadata.getProjectsInfo(CollaborationServerArchiveMetadata.java:145) at com.plumtree.core.om.CollaborationServerArchiveMetadata.execute(CollaborationServerArchiveMetadata.java:122) at com.plumtree.core.om.ObjectMigrationManager.getImportArchiveProjects(ObjectMigrationManager.java:170) at com.plumtree.collaboration.service.SCIImportPage.getContent(SCIImportPage.java:66) at com.plumtree.remote.sci.AdminPage.GetContent(AdminPage.java:125) at com.plumtree.remote.sci.xp.XPAdminEditor.GetPageContent(XPAdminEditor.java:114) at com.plumtree.remote.sci.soap.SciSoapBindingImpl.GetPageContent(SciSoapBindingImpl.java:141) at com.plumtree.remote.sci.soap.SciSoapBindingSkeleton.GetPageContent(SciSoapBindingSkeleton.java:141) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:887) at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:696) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2009) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    11 more bugmates