Escaping the colon character ‘:’ in JPA queries

by

I faced similar experience when using postgresql json function in native JPA query.

select * from component where data ::json ->> ?1 = ?2

JPA will throw error that i have not set the named parameter :json.

The solution:

"select * from component where data \\:\\:json ->> ?1 = ?2"

More Related Contents:

  1. How to start spring-boot app without depending on Database?
  2. INSERT INTO SELECT statement with more columns which is not in another table
  3. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. Normalization in MYSQL
  6. MySQL load NULL values from CSV data
  7. Is there a REAL performance difference between INT and VARCHAR primary keys?
  8. JOIN queries vs multiple queries
  9. Calculate difference between two datetimes in MySQL
  10. What is the maximum length of data I can put in a BLOB column in MySQL?
  11. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  12. Getting around MySQL “Can’t reopen table” error
  13. Can’t Create Entity Data Model – using MySql and EF6
  14. SQLException: No suitable driver found [duplicate]
  15. In MySQL, can I copy one row to insert into the same table?
  16. MySQL: Cloning a MySQL database on the same MySql instance
  17. MySQL sharding approaches?
  18. MySQL performance: multiple tables vs. index on single table and partitions
  19. Can MySQL convert a stored UTC time to local timezone?
  20. Returning a value even if no result
  21. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  22. I can not find my.cnf on my windows computer [duplicate]
  23. Does Order of Fields of Multi-Column Index in MySQL Matter
  24. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  25. How to store Query Result in variable using mysql
  26. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  27. Execute INSERT if table is empty?
  28. MySQL: Querying for unicode entities
  29. MySQL data directory location
  30. INSERT INTO fails with node-mysql

Leave a Comment