Archives: Answers

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

SQLNET.ALLOWED_LOGON_VERSION_SERVER in sqlnet.ora file to a lower Oracle version like 8 or 9 which are compatible with the client-server authentication when using unsupported JDBC drivers with Oracle DB 12c. This …