Tag Archives: Project error – BUG

[BUG-mybatis-plus] org.postgresql.util.PSQLException: ERROR: syntax error at or near “current_date“

Environmental Science:

         spring cloud   + Mybatis-plus + postgresql

Scenario:

  Prompt during table insertion

         org.postgresql.util.PSQLException: ERROR: syntax error at or near “current_date”

  Causes:

         current_ Date() is the method of SQL, current_ Date is the method name

resolvent:

         current_ Change date to create_ Date (optional here, not the method name)

Analysis process:

         The Error statement in XML file and navigator displays current_ Date is green (keyword color)

 

 

maven Error: Element ‘dependency’ cannot have character [children], because the type’s content type is

The IDEA pom.xml file reported an error
Element ‘dependency’ cannot have character [children], because the type’s content type is element-onThe picture effect

The reason:
Introduction & lt; dependency> . < /dependency> Invalid format

Solution:
1. Remove all carriage returns and line feeds from the part with the wrong format
2. Format (Ctrl + Alt + L)