Spring Boot Hibernate 5 com.zaxxer.hikari.pool. active Connection is not Release

1. maxpoolsize = 100
2. idle time out = reduced to 10 seconds
3. save method in repo/services classes should close in entityManager
close in finally block {}
4. also told spring to use hibernate5.SpringContext in application.properties

 
4th application.properties
spring.datasource.hikari.leak-detection-threshold=10000
spring.jpa.properties.hibernate.current_session_context_class=org.springframework.orm.hibernate5.SpringSessionContext

1 & 2 in HikariPool Datasource settings

url=xxx
username=xx
password=xx
driverClassName=com.mysql.jdbc.Driver
connectionTimeout=30000
maxPoolSize=100
idleTimeout=10000
minIdle=10
poolName=xxxdb-connection-pool


3rd - EntityManager Connection close
 EntityManager entityManager = entityManagerFactory.createEntityManager ();
        try
        {
            if ( entityManager != null )
            {
                entityManager.getTransaction ().begin ();
                entityManager.merge ( xxx );
                entityManager.getTransaction ().commit ();
            }
        }
        catch ( Exception e )
        {
            System.out.println ( e.getMessage () );
        }
        finally
        {
            if ( entityManager != null )
            {
                entityManager.close ();
            }
        }

Ubuntu Linux - Gnome Disk Boot Uninstall - Asking new user profile at booting 52MB new Loop disk

sudo apt-get remove gnome-disk-utility sudo apt-get remove --auto-remove gnome-disk-utility sudo apt-get purge gnome-disk-utility sudo apt-get purge --auto-remove gnome-disk-utility sudo apt update

Connect Watchgaurd VPN in linux ubuntu 20.04

1. Go to Pritunl https://client.pritunl.com/
2. Scroll to bottom, Select your linux OS, for ex: Ubuntu 20.04
3. Copy and paste the steps in your terminal
4. Windows Key in your keyboard, type pritunl, Open Pritunl GUI

5. Go to windows machine which watchgaurd is already installed.
     “%Appdata%\Watchguard\Mobile VPN\
6. Copy the following files to your linux machine for ex: /home/drvijay/watchgaurd
     client.ovpn
     ca.crt
    client.crt
    client.pem

7. Now in pritunl -> click import profile -> select the client.ovpn
8. Select connect and Enter your user/pwd from the top left settings









-ENJOY