com.discoverymachine.util.db.DBException: java.sql.SQLException: error in script file line: 2 File input/output errorerror java.io.FileNotFoundException: C:\Documents and Settings\Administrator\Desktop\new.data (Access is denied) opening file - file C:\Documents and Settings\Administrator\Desktop\new.data in statement \[CREATE CACHED TABLE BLACKBOARD\] in statement \[SHUTDOWN COMPACT\]

hsqldb | prplehaze2 | 1 decade ago
  1. 0

    Crash closing an application that uses HSQLDB

    hsqldb | 1 decade ago | prplehaze2
    com.discoverymachine.util.db.DBException: java.sql.SQLException: error in script file line: 2 File input/output errorerror java.io.FileNotFoundException: C:\Documents and Settings\Administrator\Desktop\new.data (Access is denied) opening file - file C:\Documents and Settings\Administrator\Desktop\new.data in statement \[CREATE CACHED TABLE BLACKBOARD\] in statement \[SHUTDOWN COMPACT\]
  2. 0

    Mapping a table called "group" in Hibernate for DB2 and HSQLDB

    Stack Overflow | 7 years ago | Juha Syrjälä
    java.sql.SQLException: Unexpected token: GROUP in statement [create table group]
  3. 0

    Java SQL-statement problems

    Stack Overflow | 3 years ago | iHank
    java.sql.SQLException: Column not found: HANK
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SimpleJdbcTestUtils.executeScript and multilines script

    Stack Overflow | 7 years ago | romaintaz
    java.sql.SQLException: Unexpected token: in statement [CREATE TABLE T_FOO (]
  6. 0

    HSQLDB Trigger Statement ERROR when using SimpleJdbcTestUtils.executeSqlScript()

    Stack Overflow | 5 years ago | JavaLady
    java.sql.SQLException: Unexpected end of command: REFERENCING in statement [CREATE TRIGGER t BEFORE UPDATE ON SUBJECTS REFERENCING]

    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: 2 File input/output errorerror java.io.FileNotFoundException: C:\Documents and Settings\Administrator\Desktop\new.data (Access is denied) opening file - file C:\Documents and Settings\Administrator\Desktop\new.data in statement \[CREATE CACHED TABLE BLACKBOARD\] in statement \[SHUTDOWN COMPACT\]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
      3 frames
    3. com.discoverymachine.util
      DMHSQLDBDriver.close
      1. com.discoverymachine.util.db.DMHSQLDBDriver.close(DMHSQLDBDriver.java:214)
      1 frame
    4. com.discoverymachine.dm
      DTFrame.processWindowEvent
      1. com.discoverymachine.dm.data.Project.close(Project.java:590)
      2. com.discoverymachine.dm.data.ProjectManager.closeProject(ProjectManager.java:368)
      3. com.discoverymachine.dm.data.ProjectManager.closeProject(ProjectManager.java:336)
      4. com.discoverymachine.dm.ui.DTFrame.closeProject(DTFrame.java:1065)
      5. com.discoverymachine.dm.ui.DTFrame.closeApplication(DTFrame.java:1261)
      6. com.discoverymachine.dm.ui.DTFrame.processWindowEvent(DTFrame.java:1220)
      6 frames
    5. Java RT
      EventDispatchThread.run
      1. java.awt.Window.processEvent(Unknown Source)
      2. java.awt.Component.dispatchEventImpl(Unknown Source)
      3. java.awt.Container.dispatchEventImpl(Unknown Source)
      4. java.awt.Window.dispatchEventImpl(Unknown Source)
      5. java.awt.Component.dispatchEvent(Unknown Source)
      6. java.awt.EventQueue.dispatchEvent(Unknown Source)
      7. java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
      8. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      9. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      10. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      11. java.awt.EventDispatchThread.run(Unknown Source)
      11 frames