java.sql.SQLException: error in script file line: 33 Unexpected token: SUBSTRING in statement [CREATE ALIAS SUBSTRING]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hsqldb by nitinprakash
, 1 year ago
socket creation error Error \*\*\*\*\*\*\*\*Total time in milliseconds is 79125
via Stack Overflow by Aniruddha
, 2 years ago
socket creation error
via hsqldb by pit3r
, 1 year ago
error in script file line: 4 S1000 General error java.lang.NullPointerException in statement \[SET TABLE ACTUALCATALOGTREE INDEX'3976216 272 0'\]
via hsqldb by rickwalsh
, 1 year ago
socket creation error
via hsqldb by fredrikericson
, 1 year ago
socket creation error
via hsqldb by txie
, 1 year ago
error in script file line: 1 Unexpected token: SCHEMA in statement \[CREATE SCHEMA\]
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.(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.CollaborationServerMigration.closeDB(CollaborationServerMigration.java:149)
at com.plumtree.core.om.CollaborationServerArchiveMetadata.execute(CollaborationServerArchiveMetadata.java:124)
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 javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:887)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:696)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
11 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.