A new topic, 'H2 update not working', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=76.new#new
The text of the topic is shown below:
Hi,
I'm trying to create a very simple test db using H2.
I've created a changelog and have all the connection settings correct.
I'm just letting H2 generate the db from the request and am currently telling
liquibase to use the 'public' schema.
Everytime I try to run the update I get:
Code:
... lots of stack trace ...
Caused by: org.h2.jdbc.JdbcSQLException: Table DATABASECHANGELOGLOCK already
exists; SQL statement:
CREATE TABLE public.DATABASECHANGELOGLOCK ...
My changelog is setup like this:
main.xml
--> 1.0.0-dev1/releasechanges.xml
--> 1.0.0-dev1/2009-07-15-CFREF-1.xml
the 2009-07-15-CFREF-1.xml contains the only "real" changeset:
Code:
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd";>
<changeSet author="jdoklovic" id="CFREF-1-1">
<createTable tableName="Authors">
<column autoIncrement="true" name="authorId" type="INT">
<constraints nullable="false" primaryKey="true"/>
</column>
<column name="firstName" type="VARCHAR(30)">
<constraints nullable="false"/>
</column>
<column name="lastName" type="VARCHAR(30)">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="jdoklovic" id="CFREF-1-2">
<createTable tableName="Books">
<column autoIncrement="true" name="bookId" type="INT">
<constraints nullable="false" primaryKey="true"/>
</column>
<column name="authorId" type="INT">
<constraints nullable="false"/>
</column>
<column name="title" type="VARCHAR(100)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(500)">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>
<changeSet author="jdoklovic" id="CFREF-1-3">
<addForeignKeyConstraint baseColumnNames="authorId"
baseTableName="Books" constraintName="book_author_fk" deferrable="false"
initiallyDeferred="false" onDelete="CASCADE" referencedColumnNames="authorId"
referencedTableName="Authors"/>
</changeSet>
</databaseChangeLog>
And here ar my connection settings:
Code:
liquibase.db.schema=public
liquibase.db.url=jdbc:h2:${build.dir}/war/h2db/testh2db;MODE=MySQL
liquibase.db.user=admin
liquibase.db.pass=admin
liquibase.db.driver=org.h2.Driver
liquibase.contexts=test
liquibase.prompt.non.local=false
Anyone have any idea what's going on with this??
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
