Hi all Gurus Here is my problem, I wants to create a baseline on our development Dateabase (Oracle 10g), and check into our svn for version control, and after this we will use liquibase to help us manage the incremental database changes. My problem is how should I create baseline of Oracle 10g? the database now consists of 500+ tables...
Hello Experts ! Last week i read about liquibase quick start and all the related tutorials but i feel like i don't get the whole drift about using it for consecutive change in the database and i have some questions still opened. i'm developing an application in netbeans using maven with 3 modules: dbunit module, service module a...
Hello Good People! i'm getting my hands around the liquibase library and i'ld like to mimic working with existing database. So from command line i manage to generate the changelog and i was wondering whether it's possible to generate insert statements for data insides the tables? thanks for reading this. ...
I manage to issue a Liquibase Update as described in Liquibase Servlet Listener. <listener> <listener-class>liquibase.servlet.LiquibaseServletListener</listener-class> </listener> This effectively executes my Changelog. However, this happens after the setup of the EntityManager. Obviously, this is too late if I want my Persist...
Hello Everyone, I can't figure out how to rollback custom Sql within a changeset. Any thoughts? I'd like to do this: <changeSet author="Charlie White" id="15" runAlways="false" runOnChange="false" failOnError="true"> <sql> INSERT INTO `XXXX` (`CONFIG_ID`,`NAME`,`VALUE`) VALUES YYYY; </sql> <rollback> DELETE FROM 'XXXX" WHERE 'YY...
Hello Gurus! i'm having a light problem with liquibase and hibernate.I expect hibernate to create the schema when the hbm2ddl is set to create and then have liquibase polulate the database with an sql script file. i've notice that when on validate it behaves as describe and on create it doesn't Especially on a testing environment when...
Hello Expert!! I'm using liquibase on a project and i just realize what makes my build fails.i've successfully use command line generateChangeLog against the same schema in mysql and included that file in my master-change-log file. For test environment i use hsqldb.Now all the table name are hyphen separated apart from language.Sinc...
We use liquibase to keep track of our database changes.. First changeSet contains those lines: <column name="SHORT_ID" type="INTEGER"> <constraints unique="true" /> </column> Basically it means that SHORT_ID column has unique constraint but the name of this constraint can be whatever and usually is different each time (we run some ...
I'm using Hibernate 3.5.0, JBoss AS 6 and Liquibase 1.9.5. I wanted to activate EhCache Hibernate second-level caching as follows: The first thing I do, is adding a new dependency to the pom.xml: <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-ehcache</artifactId> <version>3.5....
I'm new to the world of data migration and looking into ways to migrate the data of customers using OurApp 1.0 to a new database with a schema compatible with OurApp 2.0. I've seen a more than a few people recommending Liquibase for database change management and database refactoring tasks, which to my newbie ears sounds like it may be ...
Perhaps this is a shot in the dark but I am attempting to use the Grails Liquibase plugin and it appears as though there is a compatibility issue with the Taggable plugin. The Taggable plugin works by implementing Taggable on the domain classes which you want to be taggable. When I try to run the Liquibase command grails generate-change...
I'm experimenting with Liquibase, trying to get it to copy one database to another. Unfortunately, I keep getting this error: Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query. The SQL it's generating is here: CREATE TABLE [dbo].[Attachment] ( [Applicantid] u...