Hi Evgenij ,

Thanks for your reply. I am really sorry for getting back to you very late
due to other priorities.

Yes we are using the following command to initialize the H2DB in our
project. and it is working fine with h2-1.4.199.jar but with h2-1.4.200
version it was giving the issue.

Following is my command:
*jdbc:h2:%base%data\nim-sm-customizations;AUTO_SERVER=TRUE*

I have seen an example at :
http://www.h2database.com/html/features.html?highlight=AUTO_SERVER&search=auto_server#auto_mixed_mode

*Multiple processes can access the same database without having to start
the server manually. To do that, append ;AUTO_SERVER=TRUE to the database
URL. *You can use the same database URL independent of whether the database
is already open or not. This feature doesn't work with in-memory databases.
Example database URL:

jdbc:h2:/data/test;AUTO_SERVER=TRUE


I am suspecting If we have removed the AUTO_SERVER=TRUE might cause other
issues while accessing with multiple processes.So please suggest on this.

Also what is the difference between the H2DB versions 1.4.199 and 1.4.200?



Thanks,
Balamurali

On Tue, Mar 23, 2021 at 12:09 PM Evgenij Ryazanov <[email protected]> wrote:

> Hello.
>
> Your application shouldn't normally start TCP server of H2. If you need
> it, it should be launched as a separate process outside of your web /
> application server or at least in its process, but not on the web
> application level.
>
> Maybe you accidentally added AUTO_SERVER to JDBC URL of H2?
>
> Also if you use and embedded database and H2 is in the classpath of your
> application (not the best idea, but in many cases there is no other
> choice), you need to call the SHUTDOWN command explicitly from
> ServletContextListener.contextDestroyed().
>
> --
> 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/038663cd-2535-4c7a-8f67-3cb9947d40acn%40googlegroups.com
> <https://groups.google.com/d/msgid/h2-database/038663cd-2535-4c7a-8f67-3cb9947d40acn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
This electronic communication and the information and any files transmitted 
with it, or attached to it, are confidential and are intended solely for 
the use of the individual or entity to whom it is addressed and may contain 
information that is confidential, legally privileged, protected by privacy 
laws, or otherwise restricted from disclosure to anyone else. If you are 
not the intended recipient or the person responsible for delivering the 
e-mail to the intended recipient, you are hereby notified that any use, 
copying, distributing, dissemination, forwarding, printing, or copying of 
this e-mail is strictly prohibited. If you received this e-mail in error, 
please return the e-mail to the sender, delete it from your computer, and 
destroy any printed copy of it.

-- 
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/CAG6_yCBUWz2oXyjtxNEFoKT6CY8%3D0%3Di8VmZY%2Bve9hnC2URzHUg%40mail.gmail.com.

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to