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))\]

hsqldb | theycallmemorty | 9 years ago
  1. 0

    Database Connection Causes Error

    hsqldb | 9 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))\]
  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

    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]
  6. 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

    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: 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))\]

      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. Unknown
      UserInterface.main
      1. DataBaseWrapper.<init>(DataBaseWrapper.java:32)
      2. BusinessLogic.<init>(BusinessLogic.java:39)
      3. UserInterface.main(UserInterface.java:294)
      3 frames