What is H2 database used for in WildFly?

[Finster]

Hi all, 

Can anyone here confirm that H2 database is used by WildFly only for internal/testing purposes, and is not in use during real production at customer site deployment ?

A brief explanation of what is H2 used for in WildFly would be appreciated.

Many thanks!

[Bartosz Baranowski]

On Sunday, August 4, 2024 at 7:53:53 AM UTC+2 Finster wrote:

Hi all, 

Can anyone here confirm that H2 database is used by WildFly only for internal/testing purposes, and is not in use during real production at customer site deployment ?

What is used during real production is in control of administrator/s  There is really no way of being sure what people do. However its not uncommon for small deployments utilizing H2, when big dataset is not a requirement, ie:
https://stackoverflow.com/a/12263533

 

A brief explanation of what is H2 used for in WildFly would be appreciated.

As a relational DB ? Easy jump start for development, that later can be discarded in favor of commercial DBs?

 

Many thanks!

[Michael Musgrove]

There is an open H2 issue [1] about lack of support for transaction recovery if the server or connection fails with prepared transactions.

Also, but please don't quote me, about a decade or so ago when we looked at H2 for transactions there were some concerns about its robustness and scalability, the situation may well have improved so I will be happy to be corrected.

[1] https://github.com/h2database/h2database/issues/2347

--
You received this message because you are subscribed to the Google Groups "WildFly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wildfly+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/4e7c5d24-d101-4141-8622-6369f7f8817cn%40googlegroups.com.

--

Michael Musgrove

Transactions

Red Hat

[Finster]

Thank you Bartosz. 

I am an admin on my setup, so you say that I can control what in WildFly will be used and what will not be used?

How? 

Can you please share instructions or some example as a reference ?

Thank you,

Roni

ב-יום רביעי, 7 באוגוסט 2024 בשעה 09:33:05 UTC+3, Bartosz Baranowski כתב/ה:

[Bartosz Baranowski]

I mean if you remove driver definition and exampleDS you can add your own driver, add definition in config and base DS on top of it. This is bit old, but still relevant: https://medium.com/@tiagomac/configuring-a-datasource-in-wildfly-and-connecting-to-it-through-spring-boot-8c2ef880670b