ERROR: column “sysdate” does not exist Postgresql
sysdate is not supported by PostgreSQL, Please use the function below that is in place of that.
ERROR: column “sysdate” does not exist Postgresql Read MoreHere find the best solution
Answer
sysdate is not supported by PostgreSQL, Please use the function below that is in place of that.
ERROR: column “sysdate” does not exist Postgresql Read MoreThe 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 …
Postgres function for NVL Read MoreRoot 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 …
Caused by: org.hibernate.boot.archive.spi.ArchiveException: Could not build ClassFile Read MoreSolution 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 …
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: APPLICATION is not mapped Read MoreDeletes 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
How to delete Git branch locally and remotely? Read MorePlease add below property in spring boot application.properties file,problem automatically resolve.
Table does not exists Hibernate Spring Boot Application Read MorePlease add end of the JDBC URL “?zeroDateTimeBehavior=convertToNull” like as below jdbc:mysql://yourdbserverip:3306/yourdatabasename?zeroDateTimeBehavior=convertToNull
Caused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibited Read MoreUse 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; } }
How to convert String to Long? Read MoreExecute the below lines in MySQL Data Base SET GLOBAL table_open_cache=16384 SET GLOBAL table_definition_cache=16384
Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared Read MoreSQLNET.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 …
ORA-28040: No matching authentication protocol exception Read More