My URL: jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOG=0;UNDO_LOG=0;MODE=MYSQL;MVCC=0;MVCC=FALSE;MV_STORE=FALSE
1. Link table issue When I issue the following query internally translated invalid where condition Link table with where condition Original query: insert into mem_table select * from abc_link where number in(421404,421196,421314,630606,321351,421208,200812,671085,230884,321337) translated as below which is invalid Executed query: select * from abcview T WHERE NUMBER>=200812 AND NUMBER<=200812 2. I cannot start/connect in memory database if want to disable MV Store using MV_STORE=FALSE DB URL: jdbc:h2:mem:ingestion;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOG=0;UNDO_LOG=0;MODE=MYSQL;MVCC=0;MVCC=FALSE;MV_STORE=FALSE If i just use MVCC=FALSE; still MVTable get created and throws some exception. 3. I get random error General errors a) org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.178/4]"; SQL statement: INSERT INTO contributor_prods(gre_talent_no , gre_unique_id ) select gre_talent_no, gre_unique_id from contributor_prods_link [50000-178] b) Invalid operational path c) Sys Lock error after time out I am using in memory database for referential read only data. Thank you for your helps -Vishwa -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
