How to escape colon `:` within a native SQL query in Hibernate?

by

In Hibernate, escaping is done with prepending by \. But in Java, you also have to escape \ by another \. So every : needs to be replaced by \\:. Finally, you get:

Query query = session.createSQLQuery("SELECT
    XMLSERIALIZE
    (CONTENT
      XMLELEMENT
      (
        NAME \"ltc\\:DOAATLTC\",
        XMLATTRIBUTES
        (
          'http://www.edftrading.com/Trade/Common/DoaatLTC' AS \"xmlns\\:ltc\",
          'http://www.edftrading.com/Trade/Common/DoaatLTCHourlyNomination' AS \"xmlns\\:ltchnom\"
        ),
        XMLELEMENT ( ... ) FROM ...");

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. How to print a query string with parameter values when using Hibernate
  3. How to get SQL from Hibernate Criteria API (*not* for logging)
  4. Hibernate Union alternatives
  5. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  6. How can you call custom database functions with Hibernate?
  7. Hibernate Group by Criteria Object
  8. How to prevent SQL Injection with JPA and Hibernate?
  9. Hibernate Criteria API: get n random rows
  10. Get column name of property mapped with Hibernate
  11. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  12. having an exception when saving oracle type object in some entity
  13. How can I make a JPA OneToOne relation lazy
  14. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  15. Hibernate openSession() vs getCurrentSession()
  16. JPA and Hibernate – Criteria vs. JPQL or HQL
  17. annotation to filter results of a @OneToMany association
  18. How can I use hibernate with MS Access?
  19. Spring 3.1 Hibernate 4 exception for Inheritance [cannot be cast to org.hibernate.mapping.RootClass]
  20. Java SE + Spring Data + Hibernate
  21. Does Hibernate Fully Support SQLite
  22. How to add Distinct in Hibernate Criteria
  23. Hibernate: “Field ‘id’ doesn’t have a default value”
  24. Inserting null to an Integer column using JDBC
  25. How to implement a SQL like ‘LIKE’ operator in java?
  26. How do you map a “Map” in hibernate using annotations?
  27. Hibernate Criteria for Dates
  28. Can javax.persistence.Query.getResultList() return null?
  29. Difference between @GeneratedValue and @GenericGenerator
  30. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories

Leave a Comment