Or rather , What are the changes that one should make if it is the case of migration to H2-2.1.214 from H2-1.3.176
Thanks. On Friday, 15 July 2022 at 12:22:48 UTC+5:30 Ronit wrote: > Hello again, > > My code was using H2 with MV_Store=false previously , what should I do to > get the same behavior ? > Because now I am not able to find those tables from the database even > after creating the connection. > > Thanks > > On Thursday, 14 July 2022 at 14:19:09 UTC+5:30 Evgenij Ryazanov wrote: > >> Hello. >> >> > Will the database files dbName.h2.db , dbName.lock.db, dbName.mv.db and >> dbName.track.db work in the latest version >> No, you need to export your databases to SQL scripts with old version of >> H2 and create new databases with the new version and execute these scripts >> (this procedure was always required to upgrade between different versions): >> https://h2database.com/html/tutorial.html#upgrade_backup_restore >> You may need to add FROM_1X to import options, documentation suggests >> VARIABLE_BINARY, but FROM_1X can handle incorrect grammar used by old >> versions of H2 much better, unfortunately, documentation isn't up to date. >> >> There is also a org.h2.tools.Upgrade utility in H2 2.*.*, you can try to >> use it instead (it requires access to Internet to download an old version). >> >> You can also try a third-party upgrade tool: >> https://github.com/manticore-projects/H2MigrationTool >> >> > or I will have to change those files and Queries as well? >> It depends on their correctness, new versions of H2 are more restrictive >> and many bugs were fixed, there is no bug-for-bug emulation for older >> versions. >> >> > How Session has changed ? >> It is not a part of API, applications should never try to use it >> directly. What exactly are you trying to do with it? >> >> > I was lookinginto the code and I saw that the object of SessionLocal in >> the PgServerThread.initDb() is null. >> PgServerThread should never be used by applications and librarires. If >> you need to start the PG server to allow connections from ODBC drivers for >> PostgreSQL, you should use >> org.h2.tools.Server.createPgServer(optional_arguments).start(); >> or command-line options. >> This server is also started automatically when you start H2 as a service >> without parameters: >> java -jar h2-*.jar >> >> > Engine.createSession(ci) is returning null >> This method never returns null in H2 itself, it either returns an >> instance, or throws an exception. If you use modified sources, reflection, >> or some code injection and modification libraries everything in possible, >> but it that case it isn't a problem of H2. >> > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b866bc08-8400-46fa-bcde-a1970fde120en%40googlegroups.com.
