liquibase.exception.DatabaseException: java.sql.SQLException: Connection is closed

[alex moran]

HeY ALL

I got this exception liquibase.exception.DatabaseException: java.sql.SQLException: Connection is closed for mysql hibernate spring boot ?
 : Could not release lock

liquibase.exception.LockException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Connection is closed

And I got one table inserted inside schema  which is databasechangelock
ANY help?

[Zachary Griggs]

Are you closing the SqlConnection at some point?

Can you post the source code of what you are doing?

[alex moran]

Zachary Griggs wrote:Are you closing the SqlConnection at some point?

Can you post the source code of what you are doing?

No I am not closing sql connection not working in  MYSQL MAC OS although window works without isssue..it's jhipister config datasource:
   type: com.zaxxer.hikari.HikariDataSource
   url: jdbc:mysql://localhost:3306/xxxx?useUnicode=true&serverTimezone=UTC
   username: root
   password: root
   hikari:
     poolName: Hikari
     auto-commit: false
     data-source-properties:
       cachePrepStmts: true
       prepStmtCacheSize: 250
       prepStmtCacheSqlLimit: 2048
       useServerPrepStmts: true
       connectionTimeout: 3000
       
 jpa:
   database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
   database: MYSQL
   show-sql: false
   properties:
     hibernate.id.new_generator_mappings: true
     hibernate.connection.provider_disables_autocommit: true
     hibernate.cache.use_second_level_cache: true
     hibernate.cache.use_query_cache: false
     hibernate.generate_statistics: false
     hibernate.cache.region.factory_class: com.hazelcast.hibernate.HazelcastCacheRegionFactory
     hibernate.cache.hazelcast.instance_name:zzz
     hibernate.cache.use_minimal_puts: true
     hibernate.cache.hazelcast.use_lite_member: true

spring:
    profiles:
        active: dev
        include: swagger
    devtools:
        restart:
            enabled: true
        livereload:
            enabled: false # we use gulp + BrowserSync for livereload
    jackson:
        serialization.indent_output: true
    datasource:
         type: com.zaxxer.hikari.HikariDataSource
    url: jdbc:mysql://localhost:3306/xxxx?useUnicode=true&serverTimezone=UTC
    username: root
    password: root
    jpa:
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
    database: MYSQL
    show-sql: false
    properties:
      hibernate.id.new_generator_mappings: true
      hibernate.connection.provider_disables_autocommit: true
      hibernate.cache.use_second_level_cache: true
      hibernate.cache.use_query_cache: false
      hibernate.generate_statistics: false
      hibernate.cache.region.factory_class: com.hazelcast.hibernate.HazelcastCacheRegionFactory
      hibernate.cache.hazelcast.instance_name:zzz
      hibernate.cache.use_minimal_puts: true
      hibernate.cache.hazelcast.use_lite_member: true
    mail:
        host: localhost
        port: 25
        username:
        password:
    messages:
        cache-seconds: 1
    thymeleaf:
        cache: false


liquibase:
    contexts: dev



jhipster:
    http:
        version: V_1_1 # To use HTTP/2 you will need SSL support (see above the "server.ssl" configuration)
    cache: # Cache configuration
        ehcache: # Ehcache configuration
            time-to-live-seconds: 3600 # By default objects stay 1 hour in the cache
            max-entries: 100 # Number of objects in each cache entry
    # CORS is only enabled by default with the "dev" profile, so BrowserSync can access the API
    cors:
        allowed-origins: "*"
        allowed-methods: "*"
        allowed-headers: "*"
        exposed-headers: "Authorization"
        allow-credentials: true
        max-age: 1800
    security:
        authentication:
            jwt:
                secret: my-secret-token-to-change-in-production
                # Token is valid 24 hours
                token-validity-in-seconds: 86400
                token-validity-in-seconds-for-remember-me: 2592000
    mail: # specific JHipster mail property, for standard properties see MailProperties
        from: loginApp@localhost
        base-url: http://127.0.0.1:8080
    metrics: # DropWizard Metrics configuration, used by MetricsConfiguration
        jmx.enabled: true
        graphite: # Use the "graphite" Maven profile to have the Graphite dependencies
            enabled: false
            host: localhost
            port: 2003
            prefix: loginApp
        prometheus: # Use the "prometheus" Maven profile to have the Prometheus dependencies
            enabled: false
            endpoint: /prometheusMetrics
        logs: # Reports Dropwizard metrics in the logs
            enabled: false
            report-frequency: 60 # in seconds
    logging:
        logstash: # Forward logs to logstash over a socket, used by LoggingConfiguration
            enabled: false
            host: localhost
            port: 5000
            queue-size: 512
 




}

Liquibase could not start correctly, your database is NOT ready: java.sql.SQLException: Connection is closed


liquibase.exception.DatabaseException: java.sql.SQLException: Connection is closed