. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.0.0) 2024-08-01T17:03:06.777+01:00 INFO 1 --- [ main] c.c.e.e.Application : Starting Application v1.0.0-SNAPSHOT using Java 17.0.2 with PID 1 (/app/app.jar started by root in /app) 2024-08-01T17:03:06.870+01:00 INFO 1 --- [ main] c.c.e.e.Application : No active profile set, falling back to 1 default profile: "default" 2024-08-01T17:03:44.272+01:00 INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2024-08-01T17:03:50.468+01:00 INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 5990 ms. Found 23 JPA repository interfaces. 2024-08-01T17:03:59.273+01:00 INFO 1 --- [ main] o.s.cloud.context.scope.GenericScope : BeanFactory id=d29a8022-f77e-33ab-95d5-98c568529195 2024-08-01T17:04:02.467+01:00 INFO 1 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.codelantic.ebos.user.management.UserManagementClient' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2024-08-01T17:04:02.473+01:00 INFO 1 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.codelantic.ebos.shift.management.client.ShiftClient' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2024-08-01T17:04:14.372+01:00 INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 9006 (http) 2024-08-01T17:04:14.765+01:00 INFO 1 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2024-08-01T17:04:14.766+01:00 INFO 1 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.1] 2024-08-01T17:04:18.066+01:00 INFO 1 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2024-08-01T17:04:18.072+01:00 INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 69099 ms 2024-08-01T17:04:30.574+01:00 INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2024-08-01T17:04:33.977+01:00 INFO 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.mariadb.jdbc.Connection@452c8a40 2024-08-01T17:04:34.073+01:00 INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2024-08-01T17:04:36.069+01:00 INFO 1 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2024-08-01T17:04:38.768+01:00 INFO 1 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.1.5.Final 2024-08-01T17:04:44.574+01:00 WARN 1 --- [ main] org.hibernate.orm.deprecation : HHH90000021: Encountered deprecated setting [javax.persistence.sharedCache.mode], use [jakarta.persistence.sharedCache.mode] instead 2024-08-01T17:04:49.773+01:00 INFO 1 --- [ main] SQL dialect : HHH000400: Using dialect: org.hibernate.dialect.MariaDB103Dialect 2024-08-01T17:04:49.776+01:00 WARN 1 --- [ main] org.hibernate.orm.deprecation : HHH90000026: MariaDB103Dialect has been deprecated; use org.hibernate.dialect.MariaDBDialect instead 2024-08-01T17:05:31.570+01:00 INFO 1 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2024-08-01T17:05:31.777+01:00 INFO 1 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2024-08-01T17:05:57.374+01:00 WARN 1 --- [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2024-08-01T17:06:51.169+01:00 INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 9006 (http) with context path '' 2024-08-01T17:06:51.577+01:00 INFO 1 --- [ main] c.c.e.e.Application : Started Application in 245.695 seconds (process running for 264.502) 2024-08-01T17:16:54.067+01:00 INFO 1 --- [nio-9006-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2024-08-01T17:16:54.068+01:00 INFO 1 --- [nio-9006-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2024-08-01T17:16:54.165+01:00 INFO 1 --- [nio-9006-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 96 ms Hibernate: select c1_0.cash_safe_name from cash_safe c1_0 where c1_0.id=? and c1_0.business_id=? Hibernate: select c1_0.id,c1_0.business_id,c2_0.cash_safe_id,c2_0.id,c2_0.employee_id,c1_0.cash_safe_name,c3_0.cash_safe_id,c3_0.id,c3_0.reason_id,c4_0.cash_safe_id,c4_0.id,c4_0.role_id,c1_0.is_active from cash_safe c1_0 left join cash_safe_employees c2_0 on c1_0.id=c2_0.cash_safe_id left join cash_safe_reasons c3_0 on c1_0.id=c3_0.cash_safe_id left join cash_safe_roles c4_0 on c1_0.id=c4_0.cash_safe_id where c1_0.id=? Hibernate: WITH RunningBalance AS( SELECT id, cash_safe_id,safe_name,transaction_date_time,cash_flow,amount,transaction_by,modified_by,modified_date_and_time, reason,description,daily_reconciliation,weekly_reconciliation,monthly_reconciliation,quarterly_reconciliation,yearly_reconciliation, business_id, cash_safe_transaction_type, SUM(CASE WHEN cash_flow = 'CASH_IN' THEN amount WHEN cash_flow = 'CASH_OUT' THEN -amount ELSE 0 END) OVER (PARTITION BY cash_safe_id ORDER BY transaction_date_time) AS running_balance FROM ebos_stock_management.cash_safe_transaction WHERE cash_safe_id =? AND business_id = ? ORDER BY transaction_date_time desc limit 1 ) SELECT * FROM RunningBalance Hibernate: insert into cash_safe_transaction (amount, business_id, cash_flow, cash_safe_id, cash_safe_transaction_type, daily_reconciliation, description, modified_by, modified_date_and_time, monthly_reconciliation, quarterly_reconciliation, reason, running_balance, safe_name, transaction_by, transaction_date_time, weekly_reconciliation, yearly_reconciliation, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Hibernate: insert into cash_safe_transaction_history (amount, business_id, cash_flow, cash_safe_id, cash_safe_transaction_id, cash_safe_transaction_type, description, modified_by, modified_date_and_time, reason, reconciliation_type, safe_name, track, transaction_by, transaction_date_time) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Hibernate: select l1_0.id,l1_0.amount,l1_0.balance,l1_0.business_id,l1_0.description,l1_0.entry_date_time,l1_0.entry_type,l1_0.payment_reason from ledger_entry l1_0 where l1_0.business_id=? order by l1_0.entry_date_time desc limit 1 2024-08-01T17:17:06.172+01:00 INFO 1 --- [nio-9006-exec-1] c.c.e.e.service.LedgerEntryService : ledgerTest++++ LedgerEntry(id=a03146d6-dff0-4cdb-9d87-cd92ff15ba56, entryDateTime=2024-08-01T04:39:26, description=Monthly deposityyy, entryType=CREDIT, amount=7200.0, balance=8.0000027E10, paymentReason=Reason 1, businessId=51d08357-9c4f-4d6c-a391-89db99edfff8) Hibernate: insert into ledger_entry (amount, balance, business_id, description, entry_date_time, entry_type, payment_reason, id) values (?, ?, ?, ?, ?, ?, ?, ?) Hibernate: select c1_0.cash_safe_name from cash_safe c1_0 where c1_0.id=? and c1_0.business_id=? Hibernate: select c1_0.id,c1_0.business_id,c2_0.cash_safe_id,c2_0.id,c2_0.employee_id,c1_0.cash_safe_name,c3_0.cash_safe_id,c3_0.id,c3_0.reason_id,c4_0.cash_safe_id,c4_0.id,c4_0.role_id,c1_0.is_active from cash_safe c1_0 left join cash_safe_employees c2_0 on c1_0.id=c2_0.cash_safe_id left join cash_safe_reasons c3_0 on c1_0.id=c3_0.cash_safe_id left join cash_safe_roles c4_0 on c1_0.id=c4_0.cash_safe_id where c1_0.id=? Hibernate: WITH RunningBalance AS( SELECT id, cash_safe_id,safe_name,transaction_date_time,cash_flow,amount,transaction_by,modified_by,modified_date_and_time, reason,description,daily_reconciliation,weekly_reconciliation,monthly_reconciliation,quarterly_reconciliation,yearly_reconciliation, business_id, cash_safe_transaction_type, SUM(CASE WHEN cash_flow = 'CASH_IN' THEN amount WHEN cash_flow = 'CASH_OUT' THEN -amount ELSE 0 END) OVER (PARTITION BY cash_safe_id ORDER BY transaction_date_time) AS running_balance FROM ebos_stock_management.cash_safe_transaction WHERE cash_safe_id =? AND business_id = ? ORDER BY transaction_date_time desc limit 1 ) SELECT * FROM RunningBalance Hibernate: insert into cash_safe_transaction (amount, business_id, cash_flow, cash_safe_id, cash_safe_transaction_type, daily_reconciliation, description, modified_by, modified_date_and_time, monthly_reconciliation, quarterly_reconciliation, reason, running_balance, safe_name, transaction_by, transaction_date_time, weekly_reconciliation, yearly_reconciliation, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Hibernate: insert into cash_safe_transaction_history (amount, business_id, cash_flow, cash_safe_id, cash_safe_transaction_id, cash_safe_transaction_type, description, modified_by, modified_date_and_time, reason, reconciliation_type, safe_name, track, transaction_by, transaction_date_time) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Hibernate: select l1_0.id,l1_0.amount,l1_0.balance,l1_0.business_id,l1_0.description,l1_0.entry_date_time,l1_0.entry_type,l1_0.payment_reason from ledger_entry l1_0 where l1_0.business_id=? order by l1_0.entry_date_time desc limit 1 2024-08-02T03:51:11.469+01:00 INFO 1 --- [nio-9006-exec-3] c.c.e.e.service.LedgerEntryService : ledgerTest++++ LedgerEntry(id=1ccd1413-0b4a-42ce-b4a4-7b8f1baedc5f, entryDateTime=2024-08-01T17:17:05, description=Paid to supplier, entryType=DEBIT, amount=1000.0, balance=8.0000026E10, paymentReason=Payment to supplier, businessId=51d08357-9c4f-4d6c-a391-89db99edfff8) Hibernate: insert into ledger_entry (amount, balance, business_id, description, entry_date_time, entry_type, payment_reason, id) values (?, ?, ?, ?, ?, ?, ?, ?)