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 | 10 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

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