天道酬勤,学无止境

h2db

Buffer overflow issue when rows in vault is more than 200

Question 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

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

H2 jdbc Connection refused: connect 90067-147

Question 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)

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

Unable to get results from H2 db

Question 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

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

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

Question 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

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