Re: [h2] Using (+) symbol for joins H2 database in Oracle mode
Sorry, we do not support that syntax, even in oracle mode. -- 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/CAFYHVnWb3FxD2ohkqWczPsRNHVxE50L%3DFgztir90pwyHhnaKZA%40mail.gmail.com.
[h2] Using (+) symbol for joins H2 database in Oracle mode
I am using Oracle DB but for unit testing I am using H2 database version 1.4.199. While executing select statement with joins I am getting error message like "Function table3key(+[*]) not found". I suspect it is because of using (+) symbol for joins but I am using Oracle mode so it should support. Please help me to fix this issue, Thanks! SELECT table1.table1id, table2.table2id, table3.table3id, table4.table4id, table5.table5id FROM table5, table1, table2, table3, table4 WHERE table5.table5id = ? AND table3.table3key = table4.table3key(+) AND table1.table1key = table2.table1key(+) AND table2.table2key = table3.table2key(+) -- 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/13f60178-8f77-4ea9-b0dd-b58a154e5591n%40googlegroups.com.
Re: [h2] Problem upgrading from h2 version 2.1.214 to 2.2.220
On 8/3/2023 1:10 PM, Thomas Hurley wrote: I am Product Manager for 3 products all using H2 DB and backwards compatability for updates is really an essential This is an open-source volunteer project, not a commercial offering, so no, we are not planning anything like that. You are more than welcome to assign some of your engineers to help improve H2 on company time, however. -- 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/a30b6200-8e7a-4b69-817c-7d0c3fd8ad59%40gmail.com.
Re: [h2] H2 DB - Issues with the migration need from 2.1 to 2.2. And likely again to 2.3?
On Thu, 2023-08-03 at 04:27 -0700, Thomas Hurley wrote: > I am a Product Manager with 3 commercial products using H2 and > needing to upgrade. 1 upgraded to 2.1 and we had to go through a > migration process to make this seamless to our customers (mostly > heavily regulated companies). This upgrade went ok and no major > issues but we invested a lot of engineering time to make sure that > worked well for all upgrading customers. > > It now looks like upgrading from 2.1 to 2.2 will require the same > effort. Is that the case? Are you planning to make updates backward > compatible or will every upgrade require scripting to migrate data - > this is not a feasible solution for me and ask that you make upgrades > backward compatible to avoid your customers (and mine) having to > customise migration every version upgrade of H2. > > Look forward to your response. Greetings! We are in a similar situation, having multiple H2 Databases on our servers and need to upgrade all of those smoothly when we deploy newer versions of our software. Also, NOT upgrading H2 is never really an option since all the provided fixes are valuable and needed. That's why we wrote the Migration Tool. It can convert whole (recursive) directories with all DBs in it and we integrated it directly into our software. Upgrading from 2.1 to 2.2 was a minor task for us. We did not notice any incompatible features. Biggest issue (for us) is that CTEs are completely broken since 2.1.212 and return no rows (without throwing errors). As long as you don't use CTEs, you should be good. If you use CTEs you may need to refactor your queries (We use JSQLParser for this.) Good luck and cheers Andreas -- 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/f87230f862e9a93456bae210c8c8bab7a68a2086.camel%40manticore-projects.com.
[h2] H2 DB - Issues with the migration need from 2.1 to 2.2. And likely again to 2.3?
hi ,
Posting this as a new conversation. one of my colleagues posted this
recently:
Fredrik Sjögren
Aug 2, 2023, 4:07:04 PM (20 hours ago)
to H2 Database
When we have upgraded the h2 library we get following error trying to open
the existing databases:
*Unsupported database file version or invalid file header in file
"/path/to/database.h2.mv.db" [90048-220] 90048/90048*
We use a file based database ("jdbc:h2:file:...")
Creating new databases works well.
Has something changed so the files are not compatible?
Any way to get around this in an easy way? The upgrade from version 1 was a
hassle for us earlier and we really wish not to do that again.
Is there any way to get more information about why it gets this error?
I am a Product Manager with 3 commercial products using H2 and needing to
upgrade. 1 upgraded to 2.1 and we had to go through a migration process to
make this seamless to our customers (mostly heavily regulated companies).
This upgrade went ok and no major issues but we invested a lot of
engineering time to make sure that worked well for all upgrading customers.
It now looks like upgrading from 2.1 to 2.2 will require the same effort.
Is that the case? Are you planning to make updates backward compatible or
will every upgrade require scripting to migrate data - this is not a
feasible solution for me and ask that you make upgrades backward compatible
to avoid your customers (and mine) having to customise migration every
version upgrade of H2.
Look forward to your response.
--
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/3b27ef27-c20e-4846-977c-0de795b9369dn%40googlegroups.com.
Re: [h2] Problem upgrading from h2 version 2.1.214 to 2.2.220
Noel, Andreas
I am Product Manager for 3 products all using H2 DB and backwards
compatability for updates is really an essential feature for us. All of
our products are onpremise deployments with marquee names in regulated
industries so this migration process your refer to is not ideal for us at
all. We allready ran through a migration process in a recent upgrade on
one of our products and it took Fredrik and team some time to get that
working efficientlly where it would not have an impact on key customers.
We update dependencies now with regularity to ensure maintenance and
security is efficient to having to run this migration process for each
product for each version upgrade is not what we want. Is there a plan to
make H2 DB updates backward compatible so we can just bump versions without
migration scripts having to be implemented?
On Thursday, August 3, 2023 at 12:22:40 AM UTC+1 Andreas Reichel wrote:
> Greetings.
>
> You will need to Export to SQL Script and Create new DB from SQL Script.
> I wrote an UI that can help you with that:
> https://manticore-projects.com/H2MigrationTool/index.html
>
> There is an online version for testing small databases:
> http://h2migrationtool.manticore-projects.com/
>
> Cheers
> Andreas
>
> On Tue, 2023-08-01 at 06:35 -0700, Fredrik Sjögren wrote:
>
> When we have upgraded the h2 library we get following error trying to open
> the existing databases:
>
> *Unsupported database file version or invalid file header in file
> "/path/to/database.h2.mv.db" [90048-220] 90048/90048*
>
> We use a file based database ("jdbc:h2:file:...")
>
> Creating new databases works well.
>
> Has something changed so the files are not compatible?
> Any way to get around this in an easy way? The upgrade from version 1 was
> a hassle for us earlier and we really wish not to do that again.
> Is there any way to get more information about why it gets this error?
>
> --
> 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...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/619938c2-25f5-47cd-909c-c2cb1796464fn%40googlegroups.com
>
>
> .
>
>
>
--
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/ee079d54-52ca-4100-a2c5-33ed67d7a13fn%40googlegroups.com.
