本软件下载地址未录入,如想要软件请评论,我们会补上!
数据库管理软件sql数据库引擎
·非常快的数据库引擎·开放源代码·在 Java 中写入·支持标准 SQL,JDBC API·嵌入式和服务器模式下,群集支持·强大的安全功能·PostgreSQL ODBC 驱动程序可以使用·多版本并发性
在 1.4.184 版本中,"分组依据"忽略表名,并且可能错误地挑选选择列。示例: 选择 0 作为从 system_range (1,2) d x d 组。x ;
新连接设置"REUSE_SPACE"(默认: 真实)。如果禁用,所有更改都附加到数据库文件中,并永远不会覆盖现有内容。这允许回滚到以前的状态,数据库的通过将数据库文件截断。
问题 587: MVStore: 并发的压实和存储操作可能会导致类型。
发行 594: 探查器。copyInThread 不正常。
SQL database engine written in Java
H2 Database Engine Portable is an advanced application designed for SQL users. JDBC and ODBC APIs are supported.
Embedded and server modes are available. A Web console application is included. Clustering is supported. Security: the TCP server did not cor>
rectly restrict access rights of clients in some cases. This was specially a problem when using the flag "tcpAllowOthers". · H2 Console: the session timeout can now be configured using the system property "h2.consoleTimeout". · Issue 431: Improved compatibility with MySQL: support for "ENGINE=InnoDB charset=UTF8" when creating a table. · Issue 249: Improved compatibility with MySQL in the MySQL mode: now the methods DatabaseMetaData methods stores*Case*Identifiers return the same as MySQL when using the MySQL mode. · Issue 434: H2 Console didn't work in the Chrome browser due to a wrong viewport argument. · There was a possibility that the .lock.db file was not deleted when the database was closed, which could slow down opening the database. · The SQL s cript generated by the "s cript" command contained inconsistent newlines on Windows.
LIRS cache: bugfix for caches that only contain nonresident entries.
For inmemory databases, queries with a "group by" column that is also a hash index threw a RuntimeException.
Improved error message for some syntax errors.
File system abstraction: if used directly, some file systems did not work correctly with spliced byte buffers (the database engine doesn't use those).
To use the MVStore storage engine (which is still work in progress), append ";mv_store=true" to the database URL. Using the MVTableEngine when creating the table is no longer recommended.
To compile user defined functions, the javax.tools.JavaCompiler is now used if available, and no temporary files are created. This should solve problems when multiple H2 database concurrently compile the same user defined functions. To disable, system the system property "h2.javaSystemCompiler" to false.
Concurrently creating function aliases in different databases could result in the exception "javac: file not found".
>