[h2] Re: WriteValue Function replacement
Hello. No, there are no direct replacements. You cannot rely on internals of H2, they aren't expected to be used by applications. This method was used internally by removed PageStore backend. MVStore backend uses ValueDataType instead (and it also isn't a part of API). ValueDataType uses different encoding, so it cannot read or write values in format used by PageStore. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b3e09598-72a6-4724-b335-765602ba17b3n%40googlegroups.com.
[h2] Re: H2 version 2.1.210 droping public table on its own
Thanks , I am actually trying to migrate my code from H2 1.3.176 to H2 2.1.214 so I wanted to make sure that is there a way to include MV_Store = FALSE But now its clear. On Tuesday, July 12, 2022 at 7:55:22 AM UTC+5:30 andrei...@gmail.com wrote: > I am curious what might be the reason to try the addition of > MV_Store=FALSE to your connection URL, > but that option has been removed a while ago (at v. 1.4.200 ?), and > MVStore is the only storage engine available in H2. > > On Monday, July 11, 2022 at 11:43:47 AM UTC-4 ronjos...@gmail.com wrote: > >> Hello , >> >> I am working with the H2 2.1.214 and I want to add MV_Store=FALSE to my >> JDBC Connection string. >> can you please tell me how its done ? >> >> Currently I am adding it >> >> >> jdbc:h2:file:databasePath/dbName;MV_STORE=FALSE;LOCK_TIMEOUT=180;MAX_COMPACT_TIME=1 >> >> and it is giving me ' General error: >> "java.lang.UnsupportedOperationException"'. >> Thanks >> On Thursday, June 23, 2022 at 10:44:43 AM UTC+5:30 kapoor.s...@gmail.com >> wrote: >> >>> I have some more logs. please see below >>> >>> >>> 2022-06-23 08:43:23 database: disconnecting session #3 >>> 2022-06-23 08:43:23 database: closing /Volumes/Macintosh HD - >>> Data/Projects/informixhq-server/server/h2db >>> 2022-06-23 08:43:23 lock: 2 shared read unlock SYS >>> 2022-06-23 08:43:23 lock: 1 shared read unlock SYS >>> 2022-06-23 08:43:23 database: closed >>> 2022-06-23 08:43:23 database: disconnected session #3 >>> 2022-06-23 08:43:23 database: opening /Volumes/Macintosh HD - >>> Data/Projects/informixhq-server/server/h2db (build 210) >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for SYS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >>> INFORMIX_SERVER_GROUPS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVER_GROUPS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYSTEM_REPORTS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for SYSTEM_REPORTS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for ALERTING_INCIDENTS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for ALERTING_INCIDENTS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USERS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for USERS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SENSOR_TYPES >>> 2022-06-23 08:43:23 lock: 1 exclusive added for SENSOR_TYPES >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >>> ALERTING_CRITERIA_VIOLATIONS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for >>> ALERTING_CRITERIA_VIOLATIONS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_PERMISSIONS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_PERMISSIONS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >>> USER_ALERT_MESSENGERS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_MESSENGERS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for DASHBOARDS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for DASHBOARDS >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_ALERT_SERVICES >>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_SERVICES >>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for INFORMIX_SERVERS >>> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVERS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVER_GROUPS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYSTEM_REPORTS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_INCIDENTS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USERS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SENSOR_TYPES >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock >>> ALERTING_CRITERIA_VIOLATIONS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_PERMISSIONS >>> *2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_MESSENGERS * >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock DASHBOARDS >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_SERVICES >>> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVERS >>> 2022-06-23 08:43:23 database: opened /Volumes/Macintosh HD - >>> Data/Projects/informixhq-server/server/h2db >>> 2022-06-23 08:43:23 database: connecting session #3 to >>> /Volumes/Macintosh HD - Data/Projects/informixhq-server/server/h2db >>> 2022-06-23 08:43:23 jdbc[3]: >>> /*SQL */SET TRACE_LEVEL_FILE 3; >>> 2022-06-23 08:43:23 jdbc[3]: >>> /**/Connection conn2679 = >>> DriverManager.getConnection("jdbc:h2:file:./h2db;TRACE_LEVEL_FILE=3", "", >>> ""); >>> 2022-06-23 08:43:23 jdbc[3]: >>> /**/PreparedStatement prep947 = conn2679.prepareStatement("update >>> informix_servers set alias = ?, hostname = ?, service_name = ?, port = ?, >>> monitor_user = ?, monitor_password = ?, admin_user = ?, admin_password = ?, >>> group_id = ?, profile = ?, alerts = ?, properties = ?, agent_config = ?, >>>
[h2] Re: H2 version 2.1.210 droping public table on its own
I am curious what might be the reason to try the addition of MV_Store=FALSE to your connection URL, but that option has been removed a while ago (at v. 1.4.200 ?), and MVStore is the only storage engine available in H2. On Monday, July 11, 2022 at 11:43:47 AM UTC-4 ronjos...@gmail.com wrote: > Hello , > > I am working with the H2 2.1.214 and I want to add MV_Store=FALSE to my > JDBC Connection string. > can you please tell me how its done ? > > Currently I am adding it > > > jdbc:h2:file:databasePath/dbName;MV_STORE=FALSE;LOCK_TIMEOUT=180;MAX_COMPACT_TIME=1 > > and it is giving me ' General error: > "java.lang.UnsupportedOperationException"'. > Thanks > On Thursday, June 23, 2022 at 10:44:43 AM UTC+5:30 kapoor.s...@gmail.com > wrote: > >> I have some more logs. please see below >> >> >> 2022-06-23 08:43:23 database: disconnecting session #3 >> 2022-06-23 08:43:23 database: closing /Volumes/Macintosh HD - >> Data/Projects/informixhq-server/server/h2db >> 2022-06-23 08:43:23 lock: 2 shared read unlock SYS >> 2022-06-23 08:43:23 lock: 1 shared read unlock SYS >> 2022-06-23 08:43:23 database: closed >> 2022-06-23 08:43:23 database: disconnected session #3 >> 2022-06-23 08:43:23 database: opening /Volumes/Macintosh HD - >> Data/Projects/informixhq-server/server/h2db (build 210) >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYS >> 2022-06-23 08:43:23 lock: 1 exclusive added for SYS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >> INFORMIX_SERVER_GROUPS >> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVER_GROUPS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYSTEM_REPORTS >> 2022-06-23 08:43:23 lock: 1 exclusive added for SYSTEM_REPORTS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for ALERTING_INCIDENTS >> 2022-06-23 08:43:23 lock: 1 exclusive added for ALERTING_INCIDENTS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USERS >> 2022-06-23 08:43:23 lock: 1 exclusive added for USERS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SENSOR_TYPES >> 2022-06-23 08:43:23 lock: 1 exclusive added for SENSOR_TYPES >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >> ALERTING_CRITERIA_VIOLATIONS >> 2022-06-23 08:43:23 lock: 1 exclusive added for >> ALERTING_CRITERIA_VIOLATIONS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_PERMISSIONS >> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_PERMISSIONS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for >> USER_ALERT_MESSENGERS >> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_MESSENGERS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for DASHBOARDS >> 2022-06-23 08:43:23 lock: 1 exclusive added for DASHBOARDS >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_ALERT_SERVICES >> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_SERVICES >> 2022-06-23 08:43:23 lock: 1 exclusive requesting for INFORMIX_SERVERS >> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVERS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVER_GROUPS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYSTEM_REPORTS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_INCIDENTS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock USERS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock SENSOR_TYPES >> 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_CRITERIA_VIOLATIONS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_PERMISSIONS >> *2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_MESSENGERS * >> 2022-06-23 08:43:23 lock: 1 exclusive unlock DASHBOARDS >> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_SERVICES >> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVERS >> 2022-06-23 08:43:23 database: opened /Volumes/Macintosh HD - >> Data/Projects/informixhq-server/server/h2db >> 2022-06-23 08:43:23 database: connecting session #3 to /Volumes/Macintosh >> HD - Data/Projects/informixhq-server/server/h2db >> 2022-06-23 08:43:23 jdbc[3]: >> /*SQL */SET TRACE_LEVEL_FILE 3; >> 2022-06-23 08:43:23 jdbc[3]: >> /**/Connection conn2679 = >> DriverManager.getConnection("jdbc:h2:file:./h2db;TRACE_LEVEL_FILE=3", "", >> ""); >> 2022-06-23 08:43:23 jdbc[3]: >> /**/PreparedStatement prep947 = conn2679.prepareStatement("update >> informix_servers set alias = ?, hostname = ?, service_name = ?, port = ?, >> monitor_user = ?, monitor_password = ?, admin_user = ?, admin_password = ?, >> group_id = ?, profile = ?, alerts = ?, properties = ?, agent_config = ?, >> password_secret_Key = ?, server_type = ? where id = 11"); >> 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost >> 10,390 index PUBLIC.INFORMIX_SERVERS.tableScan >> 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost >> 230 index PUBLIC.PRIMARY_KEY_3 >> 2022-06-23 08:43:23 jdbc[3]: >> /**/prep947.setString(1, "FUN1"); >>
[h2] WriteValue Function replacement
Hello , I am trying to migrate my code from H2 1.3.176(Older version) from H2 2.1.214(Latest version). In the Older version in org.h2.store.Data.java class there used to be a void writeValue(Value v) { } function which does not exist in the latest version. I wanted to know if there is a replacement for that function in the latest version ? Thanks -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/226f5199-fb5d-4a51-9242-f0f72561e5cfn%40googlegroups.com.
[h2] Re: MV_Store
Hello. Legacy PageStore backend was removed from H2, so you cannot specify MV_STORE=FALSE any more. This backend is only available in old unsupported versions, it was introduced somewhere in 1.1.* releases and the last release with this backend is 1.4.200. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/96ff2095-a7ac-43c3-b6ad-1638fdf8e8c1n%40googlegroups.com.
[h2] MV_Store
Hello , I am trying to connect to the H2 2.1.214 and I want to add MV_Store= FALSE in the JDBC connection string . I have created the DataSource object , then try { Connection conn = dataSource.getConnection() } catch (SQLException sqle) { log.error("Error : " + sqle); } jdbc:h2:file:databsePath\databseName;MV_STORE=FALSE;MODE=PostgreSQL;LOCK_TIMEOUT=180;MAX_COMPACT_TIME=1 Here I am getting 'org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.UnsupportedOperationException" '. am I making any mistake in here !? Thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/7740c630-75a7-444c-9d59-c64b5b61a8ccn%40googlegroups.com.
[h2] Re: H2 version 2.1.210 droping public table on its own
Hello , I am working with the H2 2.1.214 and I want to add MV_Store=FALSE to my JDBC Connection string. can you please tell me how its done ? Currently I am adding it jdbc:h2:file:databasePath/dbName;MV_STORE=FALSE;LOCK_TIMEOUT=180;MAX_COMPACT_TIME=1 and it is giving me ' General error: "java.lang.UnsupportedOperationException"'. Thanks On Thursday, June 23, 2022 at 10:44:43 AM UTC+5:30 kapoor.s...@gmail.com wrote: > I have some more logs. please see below > > > 2022-06-23 08:43:23 database: disconnecting session #3 > 2022-06-23 08:43:23 database: closing /Volumes/Macintosh HD - > Data/Projects/informixhq-server/server/h2db > 2022-06-23 08:43:23 lock: 2 shared read unlock SYS > 2022-06-23 08:43:23 lock: 1 shared read unlock SYS > 2022-06-23 08:43:23 database: closed > 2022-06-23 08:43:23 database: disconnected session #3 > 2022-06-23 08:43:23 database: opening /Volumes/Macintosh HD - > Data/Projects/informixhq-server/server/h2db (build 210) > 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYS > 2022-06-23 08:43:23 lock: 1 exclusive added for SYS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for > INFORMIX_SERVER_GROUPS > 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVER_GROUPS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYSTEM_REPORTS > 2022-06-23 08:43:23 lock: 1 exclusive added for SYSTEM_REPORTS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for ALERTING_INCIDENTS > 2022-06-23 08:43:23 lock: 1 exclusive added for ALERTING_INCIDENTS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for USERS > 2022-06-23 08:43:23 lock: 1 exclusive added for USERS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for SENSOR_TYPES > 2022-06-23 08:43:23 lock: 1 exclusive added for SENSOR_TYPES > 2022-06-23 08:43:23 lock: 1 exclusive requesting for > ALERTING_CRITERIA_VIOLATIONS > 2022-06-23 08:43:23 lock: 1 exclusive added for > ALERTING_CRITERIA_VIOLATIONS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_PERMISSIONS > 2022-06-23 08:43:23 lock: 1 exclusive added for USER_PERMISSIONS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_ALERT_MESSENGERS > 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_MESSENGERS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for DASHBOARDS > 2022-06-23 08:43:23 lock: 1 exclusive added for DASHBOARDS > 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_ALERT_SERVICES > 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_SERVICES > 2022-06-23 08:43:23 lock: 1 exclusive requesting for INFORMIX_SERVERS > 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVERS > 2022-06-23 08:43:23 lock: 1 exclusive unlock SYS > 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVER_GROUPS > 2022-06-23 08:43:23 lock: 1 exclusive unlock SYSTEM_REPORTS > 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_INCIDENTS > 2022-06-23 08:43:23 lock: 1 exclusive unlock USERS > 2022-06-23 08:43:23 lock: 1 exclusive unlock SENSOR_TYPES > 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_CRITERIA_VIOLATIONS > 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_PERMISSIONS > *2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_MESSENGERS * > 2022-06-23 08:43:23 lock: 1 exclusive unlock DASHBOARDS > 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_SERVICES > 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVERS > 2022-06-23 08:43:23 database: opened /Volumes/Macintosh HD - > Data/Projects/informixhq-server/server/h2db > 2022-06-23 08:43:23 database: connecting session #3 to /Volumes/Macintosh > HD - Data/Projects/informixhq-server/server/h2db > 2022-06-23 08:43:23 jdbc[3]: > /*SQL */SET TRACE_LEVEL_FILE 3; > 2022-06-23 08:43:23 jdbc[3]: > /**/Connection conn2679 = > DriverManager.getConnection("jdbc:h2:file:./h2db;TRACE_LEVEL_FILE=3", "", > ""); > 2022-06-23 08:43:23 jdbc[3]: > /**/PreparedStatement prep947 = conn2679.prepareStatement("update > informix_servers set alias = ?, hostname = ?, service_name = ?, port = ?, > monitor_user = ?, monitor_password = ?, admin_user = ?, admin_password = ?, > group_id = ?, profile = ?, alerts = ?, properties = ?, agent_config = ?, > password_secret_Key = ?, server_type = ? where id = 11"); > 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost > 10,390 index PUBLIC.INFORMIX_SERVERS.tableScan > 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost 230 > index PUBLIC.PRIMARY_KEY_3 > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setString(1, "FUN1"); > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setString(2, "localhost"); > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setString(3, null); > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setObject(4, x); > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setString(5, "informix"); > 2022-06-23 08:43:23 jdbc[3]: > /**/prep947.setString(6, > "47E8rRcSCgt12fTZ3b60sZrLVx911PoDS7YrFYHU43QiR3t/1A=="); > 2022-06-23