If you have ever dreamed about Continuous Delivery (CD) you surely thought about deployment which is fully automated. It implies automated management of database scripts. With the help provided by Liquibase it is easy to add some automation to database change sets deployment. However, there is a small downside in Liquibase implementation that makes it a little bit trickier to execute PL/SQL pieces.
"When work, commitment, and pleasure all become one and you reach that deep well where passion lives, nothing is impossible." --Nancy Coey
Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts
Tuesday, May 6, 2014
Monday, November 25, 2013
Oracle's XMLTYPE with Hibernate 4
XML is quite popular nowadays. You can store XML as a VARCHAR type in a DB. However, it has some limitations, e.g. you cannot perform XPath DB queries on a VARCHAR. Oracle DB comes with XML dedicated type - XMLTYPE that allows to perform XPath queries, has XML validation logic built-in and some storage optimizations. On the contrary, Hibernate does not support XMLTYPE out of the box. We need to define our custom UserType.
Subscribe to:
Posts
(
Atom
)