MySql 5.7.29 for ubuntu linux no_zero_date problem when inserting timestamp and group_by_Id problem solving

-
 Get rid of of this annoyable error in mysql 5.7 server on ubuntu:

https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/

We can add "sql_mode" to this file on ubuntu 18.04

Location :

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Comments

Post a Comment

Popular posts from this blog

Installation instructions for some programs on linux ubuntu

-
Install tomcat9 on linux ubuntu: https://phoenixnap.com/kb/how-to-install-tomcat-ubuntu https://www.digitalocean.com/community/tutorials/how-to-install-apache-tomcat-8-on-ubuntu-16-04 Install Ubuntu20 alongside Windows 10 as dual boot https://www.youtube.com/watch?v=-iSAyiicyQY Create Windows 10 bootable flash in ubuntu https://www.youtube.com/watch?v=rHFR-L7CtOY Install Windows Fonts on ubuntu https://ostechnix.com/install-microsoft-windows-fonts-ubuntu-16-04/ Install Configuration for Ubuntu https://wiki.ubuntu-tr.net/index.php?title=Ana_Sayfa JDK11 https://www.youtube.com/watch?v=72mz0-98vg8 jdk1.8 and netbeans 8.2 Install : https://www.youtube.com/watch?v=hyw0CHKGQ_Y UnInstall: https://netbeans.org/community/releases/82/install.html#uninstall_sollinux MYSQL https://www.youtube.com/watch?v=ug0TFsort24 GIT https://www.youtube.com/watch?v=ZMgLZUYd8Cw&t=522s Skype https://www.youtube.com/watch?v=58qlQREr_3E Docker https://www.youtube.com/watch?v=W7BvS942UZA h...
Read more

Hibernate and Application Performance

-
 hibernate 2 cur cache memory var: L1(Level bir) burada entitymanager a aiddir. bazadan gelen entityler cacheda saxlanir ve her entitymanagere xasdir L2(level 2) burada ise umumiyyetle EntityManagerFactory ye xidmet eden entiymanagerler arasinda shared cache memorydir ve level 1 den daha uzun muddetlidir level 2 cache i aktivleshdirmek uchun dependency elave edilir projecte ve 1-2 config edilir Javada 4 cur reference type var : https://dzone.com/articles/reference-types-java-part-1 Strong references. Soft references. Weak references. Phantom references entitymanager de weak referance var , ve o strongla muqayisede GC terefinden istenilen an siline biler ram lazim olsa. soft referance - strongdan zeif , weakdan gucludur ve GC onu ancaq en vacib hallarda sile biler, weak i her memory chatmiyanda sile biler ama softu ancaq outofmemory alacagi teqdirde silib ishlede biler ve soft un omru uzun olur . ve Level 2 cache da istifade edir bunu hibernate. burda da bele shey varki , LRU(last r...
Read more

timezone ile bagli Jackson deserializableda problem

-
  demeli date save olanda duzgun vaxtla save olur bazaya  ,ama qayidanda jackson deserializable levelinde ilishir ve 4 saat dala gorsenir swaggerde , bunun helli uchun: bu problem hem @CreationTimestamp ve @UpdateTimestamp da hem de el ile daxil olunan date larda da bash verir app propertiese 2 setr eleve edirik jackson serizable-deserizable emelyati uchun : spring.jackson.serialization.write-dates-with-zone-id=true spring.jackson.time-zone=GMT+4
Read more