天道酬勤,学无止境

h2db

Vault 中的行超过 200 时的缓冲区溢出问题(Buffer overflow issue when rows in vault is more than 200)

问题 我们开发了一个应用程序,可以在表格中创建保险库中的义务。 如果表的行大小小于 200,则应用程序工作正常。 但是,如果行数超过 200,则在执行过程中会出现以下错误 - 请指定页面规范,因为结果 [201] 比默认页面大小 [200] 多 将分页从默认的 200 增加到 400 后,出现 java heap out of memory 错误。 我厌倦了将节点的堆大小从 512m(默认值)增加到 1024m。 但是,这个问题仍然没有解决,我在 H2 DB 中收到错误 - Exception: java.lang.OutOfMemoryError throw from the UncaughtExceptionHandler in thread "MVStore background writer nio:C:/Users/Administrator/Desktop/Settlemen t/corda -settlement/build/nodes/Bob/persistence.mv​​.db” 我也厌倦了在 H2 DB 文档中寻找解决方案。 但是,找不到任何解决方案。 回答1 默认情况下,未指定Pagination大小时,Vault 查询会快速失败。 请参阅 https://docs.corda.net/releases/release-V2.0/api-vault

2021-10-21 06:12:22    分类:技术分享    h2   corda   h2db

H2 jdbc 连接被拒绝:连接 90067-147(H2 jdbc Connection refused: connect 90067-147)

问题 我有一个要升级的项目,它使用带有 jdbc 驱动程序的 h2 DB。 在构建过程中,我在连接时出现系统错误: Exception in thread "main" org.h2.jdbc.JdbcSQLException: Connection is broken: "Connection refused: connect" [90067-147] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:156) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:380) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:271) at org.h2.engine.SessionRemote.createSession(SessionRemote.java:265) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110) at org.h2.jdbc

2021-09-29 10:19:17    分类:技术分享    java   database   jdbc   h2   h2db

无法从 H2 db 获得结果(Unable to get results from H2 db)

问题 我正在尝试从 h2 db 获取值,但总是收到此错误 org.h2.jdbc.JdbcSQLException: No data is available [2000-171] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.message.DbException.get(DbException.java:135) at org.h2.jdbc.JdbcResultSet.checkOnValidRow(JdbcResultSet.java:2956) at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:2962) at org.h2.jdbc.JdbcResultSet.getInt(JdbcResultSet.java:306) 我用谷歌搜索答案 确保调用 rs.next(); 在使用任何 getter 方法之前。 但我确实打电话给 rs.next() ... 这是我的代码: public

2021-09-15 17:56:05    分类:技术分享    java   h2   h2db

H2 jdbc Connection refused: connect 90067-147

I got a project to upgrade and it is using h2 DB with jdbc driver. During the build I have a systematic error on connection: Exception in thread "main" org.h2.jdbc.JdbcSQLException: Connection is broken: "Connection refused: connect" [90067-147] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:156) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:380) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:271) at org.h2.engine.SessionRemote.createSession(SessionRemote.java:265) at org.h2

2021-06-27 20:15:14    分类:问答    java   database   jdbc   h2   h2db

如何显示本地 h2 数据库(Web 控制台)的内容?(How to show content of local h2 database(web console)?)

问题 最近我加入了一个新团队,这里的人使用 h2 进行存根服务。 我想知道是否可以使用 Web 界面显示该数据库的内容。 在工作中,它可以通过访问localhost:5080 我有一个使用 h2 数据库的项目,但是当我点击localhost:5080时我看不到 h2 Web 控制台 我也试过localhost:8082 - 它也不起作用。 我的项目配置(成功运行): <bean id="wrappedDataSource" class="net.bull.javamelody.SpringDataSourceFactoryBean"> <property name="targetName" value="dataSource" /> </bean> <bean id="wrappedDataSource" class="net.bull.javamelody.SpringDataSourceFactoryBean"> <property name="targetName" value="dataSource" /> </bean> <bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource"> <property name="driverClassName"

2021-06-23 07:03:13    分类:技术分享    java   spring   orm   h2   h2db

Unable to get results from H2 db

I'm trying to get values from h2 db, but always getting this error org.h2.jdbc.JdbcSQLException: No data is available [2000-171] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.message.DbException.get(DbException.java:135) at org.h2.jdbc.JdbcResultSet.checkOnValidRow(JdbcResultSet.java:2956) at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:2962) at org.h2.jdbc.JdbcResultSet.getInt(JdbcResultSet.java:306) I googled for an answer Make sure to call

2021-06-14 03:18:27    分类:问答    java   h2   h2db

How to show content of local h2 database(web console)?

Recently I joined a new team and here guys use h2 for stub service. I was wondering whether I can show the content of this database using web interface. At work it is available by going to localhost:5080 I have a project where I use h2 database, but I cannot see the h2 web console when I hit localhost:5080 I tried also localhost:8082 - it also doesn't work. My project configuration (works successfully): <bean id="wrappedDataSource" class="net.bull.javamelody.SpringDataSourceFactoryBean"> <property name="targetName" value="dataSource" /> </bean> <bean id="wrappedDataSource" class="net.bull

2021-05-25 16:43:00    分类:问答    java   spring   orm   h2   h2db

Buffer overflow issue when rows in vault is more than 200

We have developed an app, which creates obligations in vault in a table. If the row size of the table is less than 200, the application works fine. However, if the rows are more than 200 then during the execution it gives the following error - Please specify a PageSpecification as there are more results [201] than the default page size [200] After increasing the pagination to 400 from the default 200, I am getting java heap out of memory error. I tired to increase the heap size of node from 512m (default) to 1024m. But, still this issue is not resolved and I am getting the error in H2 DB-

2021-05-06 20:31:35    分类:问答    h2   corda   h2db