`
nbaertuo
  • 浏览: 76054 次
  • 性别: Icon_minigender_1
  • 来自: 武汉
社区版块
存档分类
最新评论

The database is already in use by another process

阅读更多

java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@afdb14ea[file =D:\db\human.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception:  另一个程序已锁定文件的一部分,进程无法访问。 : D:\db\human.lck

原写法:

def sql = Sql.newInstance("jdbc:hsqldb:file:d:/db/human ;ifexists=true", "sa",
                  "", "org.hsqldb.jdbcDriver")

 

正确写法:

def sql = Sql.newInstance("jdbc:hsqldb:hsql://localhost/xdb ;ifexists=true", "sa",
                  "", "org.hsqldb.jdbcDriver")

 

 

 

分享到:
评论
1 楼 nforce_com 2011-04-02  
多谢!遇到同样问题看过后解决了!

相关推荐

    计算机网络第六版答案

    Hence, it becomes possible for the attacker to issue a command to all the nodes, that target a single node (for example, all nodes in the botnet might be commanded by the attacker to send a TCP SYN ...

    微软内部资料-SQL性能优化5

    The data is stored in one place and the index is stored in another. Pointers indicate the storage location of the indexed items in the underlying table. In a nonclustered index, the leaf level ...

    myBase Desktop 6.3.7

    s launched and test if the opened document has changed or the ...is still open in use by another MS Word Excel process In result it fails to import the document into the database with the original ...

    a project model for the FreeBSD Project.7z

    Often used more narrowly in reference to an external deliverable, which is a deliverable that is subject to approval by the project sponsor or customer” by [PMI, 2000]. Examples of outcomes are a ...

    微软内部资料-SQL性能优化3

    An isolation level determines the degree to which data is isolated for use by one process and guarded against interference from other processes. Prior to SQL Server 7.0, REPEATABLE READ and ...

    Proxy Pattern Informatization Research Based On SaaS

    The second data model is shared database, separate schema in which houses multiple users in the same database, with each user having his own set of tables that are grouped into a schema created ...

    XML Processing with Perl, Python, and PHP (2002).pdf

    The solution, if you haven’t guessed it already, is that I should use XML, the Extensible Markup Language. I get all the flexibility I need without losing any capabilities. I can add new fields, ...

    Foundations for Analytics with Python O-Reilly-2016-Clinton W. Brownley

    If you don’t already have MySQL on your computer, the first step is to download and install MySQL. From there, the examples mirror the sqlite3 examples, including creating a database and table, ...

    drupal 6.12

    * Ensure that the new location for the path is writable by the web server process. To grant write permissions for a directory named uploads, you may need to use the following command from a shell ...

    php.ini-development

    The following are all the settings which are different in either the production ; or development versions of the INIs with respect to PHP's default behavior. ; Please see the actual settings later in...

    oracle错误代码大全

    #### ORA-00028: Transaction removed by another process - **解释**: 事务已被另一个进程移除。 - **解决方案**: 重新启动事务处理过程。 #### ORA-00029: Process not in transaction - **解释**: 进程不在...

Global site tag (gtag.js) - Google Analytics