Archives: Answers

The error message “column ‘sysdate’ does not exist” in PostgreSQL typically occurs when you try to reference a column that doesn’t exist in the table. In PostgreSQL, there is no …

sysdate is not supported by PostgreSQL, Please use the function below that is in place of that.        

The coalesce functions in PostgreSQL are supported but not the NVL functions. Similar to Oracle, this method is used. Converting NVL and using Oracle’s coalesce operations are both possible with …

Root Cause 1:  There are duplicate jars with different versions. Solution: Check whether any duplicate jars there in the lib folder. if you found any duplicate jar’s remove one jar …

Solution 1: Please just add nativeQuery = true @Query( value = “any sql query ………”, nativeQuery = true) Example : @Query(value=”select * from Employee”,nativeQuery = true) public List<employee> getEmployeesList(); Solution …

Deletes Local Branch : git branch -d <branch_name> Example: git branch -d development_v.1 Deletes Remote Branch : > git push origin :<branch_name> Example: git branch -d development_v.2

Please add below property in spring boot application.properties file,problem automatically resolve.

Please add end of the JDBC URL  “?zeroDateTimeBehavior=convertToNull” like as below jdbc:mysql://yourdbserverip:3306/yourdatabasename?zeroDateTimeBehavior=convertToNull  

Use the below snippet : public static Long convertStringToLong(String stringValue) { try{ NumberFormat numberFormat = NumberFormat.getInstance(); Number number = numberFormat.parse(stringValue); return number.longValue(); }catch(Exception e){ return null; } }  

Execute the below lines in MySQL Data Base SET GLOBAL table_open_cache=16384 SET GLOBAL table_definition_cache=16384