liquibase is a perfect alternative to hibernate's hbm2ddl_auto property if you are using xml-mapping. But Im using JPA annotation (hibernate annotations). Is it possible to use liquibase then? ...
Hi , I need to update my data that have html tag inside so wrote this on liquibase <sql> update table_something set table_content = " something <br/> in the next line " </sql> it apparently doesn't work on liquibase ( i got loooong errors .. and meaningless). I tried to remove <br/> and it works. my question is, is it possible to in...
Following the quickstart on liquibase i've created a changeset (very dumb :) ) Code: <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.6" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.6 ...
Hi, Im evaluating liquibase for a project starting today. Has anybody used it to create procedures, functions, basically all of the plsql stuff? If not, is it possible to write embedded sql code in the xml files? Thanks in advance. ...
Hi, Im trying to get to run a very simple example in liquibase 1.9.5 (see at the end). When I run liquibase --changeLogFile=test_sample.xml update I get this error message. Migration Failed: ORA-03115: unsupported network datatype or representation Im using oracle 10g XE 10.2.0.1. As I understand (and googled), this is an...
Hi, Im using the sqlFile to include an sql script that creates tables using oracle specific commands (NOCACHE, NO PARALLEL, stuff like that). My master.xml file includes all sql scripts and executes them. However, when it detects a tag, it fails and prints this error message. C:\update.bat master.xml Migration Failed: cvc-complex-type....
Hi, I have a bunch of sql scripts that create / drop sequences, users and other objects. I'm running these scripts through liquibase, but they fail because oracle complains when I try to drop a non existing sequence, or create an existing user. Is there an oracle way to prevent errors from happening? Something of the sort Create ...
Hi, I have a table generated by GORM (Grails Domain). It has foreign key / index that generated random characters like FKAC7AAF67162A158F. I need to remove that field that not needed anymore. The problems, I have some servers that need to be updated. So I need to create a migration using Liquibase. But I have no idea how to remove that...
I have a Liquibase migration that I manually run to load seed data from several CSV files into my database. I would like to run this migration each time I run grails run-app. I think I have two questions in one: How to I integrate the migrate command into my grails run-app ? How do I clear the DATABASECHANGELOG to allow me to run th...
As a Java Developper using JPA/Hibernate, I am looking for a will help diff a database that has been generated by Hibernate with a production database. I've already looked at LiquiBase's abilities LiquiBase which is quite nice... Unfortunlately it is plagued by some weird bugs: Re-Create Foreign Keys for no reason Re-Create Indexes fo...
Hi all, I need to execute the same db-changelog by ant and then by spring. I hope that ant will run the changelog and when spring run, it will not do anything and just stop normally. Ant run the db-changelog successfully and then spring run but it throws an exception, part of the stack trace : Reason: liquibase.exception.JDBCException...
I'm performing a diff on a remote mysql database using LiquiBase, and finding that the changeset that is generated uses the incorrect casing for table names (all lowercase). This subsequently causes the update to fail. Liquibase v1.9.5 Database : MySQL Local OS: Windows 7 Remote OS: Ubuntu Am I doing something wrong, or is this a ...
Hi, I've added the future-rollback tag to my ant script. What i want to do (and I think future-rollback is what Im looking for) is to generate an sql rollback script, but without executing it (rollback script must be delivered with sql scripts is the requirement from my client). My changelog file has many changesets, some of which cont...
I have a number of Oracle triggers stored in a file which we upload to our DB using sqlplus. We want to use liquibase instead to manage this, but I don't really want to split out the triggers into separate files. The file looks like: create or replace trigger Trig1 ... ... end Trig1; / create or replace trigger Trig2 ... ......
Hello ! Today I found LiquiBase project and I think it is very interesting. I would like to use it but I am looking for best way to do it. We are working with PHP projects and SVN (a few developers) with one MySQL server. I am wondering how to work with LiquiBase: should we store its changeLog in SVN too ? how to edit this changeLog...
Hello, I have been looking for an alternative to Hibernate for various reasons. I came across Liquibase and i like the idea so i am willing to try it. Liquibase will cater for database creation/modification in a SQL independent fashion. My main question is how does my code in my application execute SQL statements without being database ...
Does anybady know how to make case insensitive table with liquibase. I'm using the newest postgres. For example liquibase creates table in that way: create table "Users" ( "userId" integer unique not null, "userFirstName" varchar(50) not null, "userLastName" varchar(50) not null ); but how to make liquibase to create table in that...
Hi all, This question is related to "Hibernate using JPA (annotated Entities) and liquibase". I was actually wondering what to expect when doing a Liquibase diff against a Hibernate mapping definition. What it seems to produce: A liquibase changelog that migrates the state of my hibernate mappings to the current image of the database....
Hi all I am trying to create a baseline on one of my development database using liquibase, here's my environment - Database, -> Oralce 10g, with 500+ Tables with lots of configuration data, the oracle export dump file is about 70mb; - Java - Java 6 - Oracle JDBC Driver - ojdbc14.jar (downloaded from Oracle web site) - Command line execu...
I'd like to generate liquibase's dbdoc as part of my maven site build, but I cannot figure out how to do this. My thoughts were to add maven-antrun-plugin to the reporting section of the pom, but I cannot have an node under plugin in the reporting section. Any ideas? ...