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

Oracle Community | 656909 | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Migrating Collab project (4.2) to Collab(4.5)

    Oracle Community | 8 years ago | 656909
    java.sql.SQLException: error in script file line: 33 Unexpected token: SUBSTRING in statement [CREATE ALIAS SUBSTRING]
  2. 0

    [jboss-user] [Beginners Corner] - javax.naming.NameNotFoundException: ConnectionFactory not bo

    jboss.org | 1 year ago
    java.sql.SQLException: The database is already in use by another process: [file =/home/coms/jboss1/jboss-4.0.5.GA/server/default/data/hypersonic/localDB.lck, exists=true, locked=false, valid=false, fl =null]:
  3. 0

    Migrating from 0.7b4 -> 0.7b7 Standalone

    xplanner | 1 decade ago | gruni
    java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@af9db647\[file =C:\prog\xplanner-0.7b7-standalone\hsqldb\xplanner.lck, exists=true, locked=false, valid=false, fl =null\]: java.lang.Exception: checkHeartbeat(): lock file \[C:\prog\xplanner-0.7b7-standalone\hsqldb\xplanner.lck\] is presumably locked by another process.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.net.SocketException: Unrecognized Window

    runawfe | 6 years ago | sunaysshah
    java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@d0cdbfe7: java.lang.Exception:  java.io.IOException: The process cannot access the file because another process has locked a portion of the file : C:\Users\Shvetal\AppData\Roaming\runawfe\jboss\data\hypersonic\localDB.lck
  6. 0

    Database Connection Causes Error

    hsqldb | 10 years ago | theycallmemorty
    java.sql.SQLException: error in script file line: 3 Constraint already exists: SYS\_FK\_48 in statement \[CREATE MEMORY TABLE CONCEPTS(CUI VARCHAR NOT NULL,SEMANTIC\_TYPE VARCHAR,CONSTRAINT SYS\_FK\_48 PRIMARY KEY(CUI),CONSTRAINT SYS\_FK\_48 FOREIGN KEY(SEMANTIC\_TYPE) REFERENCES SEMANTICTYPES(SEMANTIC\_TYPE))\]

    5 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

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

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcDriver.connect
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
      3. org.hsqldb.jdbcDriver.getConnection(Unknown Source)
      4. org.hsqldb.jdbcDriver.connect(Unknown Source)
      4 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:525)
      2. java.sql.DriverManager.getConnection(DriverManager.java:171)
      2 frames
    4. com.plumtree.core
      ObjectMigrationManager.getImportArchiveProjects
      1. com.plumtree.core.om.CollaborationServerMigration.getConnection(CollaborationServerMigration.java:134)
      2. com.plumtree.core.om.CollaborationServerMigration.closeDB(CollaborationServerMigration.java:149)
      3. com.plumtree.core.om.CollaborationServerArchiveMetadata.execute(CollaborationServerArchiveMetadata.java:124)
      4. com.plumtree.core.om.ObjectMigrationManager.getImportArchiveProjects(ObjectMigrationManager.java:170)
      4 frames
    5. com.plumtree.collaboration
      SCIImportPage.getContent
      1. com.plumtree.collaboration.service.SCIImportPage.getContent(SCIImportPage.java:66)
      1 frame
    6. com.plumtree.remote
      SciSoapBindingSkeleton.GetPageContent
      1. com.plumtree.remote.sci.AdminPage.GetContent(AdminPage.java:125)
      2. com.plumtree.remote.sci.xp.XPAdminEditor.GetPageContent(XPAdminEditor.java:114)
      3. com.plumtree.remote.sci.soap.SciSoapBindingImpl.GetPageContent(SciSoapBindingImpl.java:141)
      4. com.plumtree.remote.sci.soap.SciSoapBindingSkeleton.GetPageContent(SciSoapBindingSkeleton.java:141)
      4 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    8. Axis Web Services
      AxisServlet.doPost
      1. org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
      2. org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
      3. org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
      4. org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
      5. org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
      6. org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
      7. org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
      8. org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
      9. org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
      9 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
      1 frame
    10. Axis Web Services
      AxisServletBase.service
      1. org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
      1 frame
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame
    12. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      8 frames
    13. Grizzly HTTP
      NioEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:887)
      2. org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:696)
      3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2009)
      3 frames
    14. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
      3. java.lang.Thread.run(Thread.java:595)
      3 frames