Turn off CLEAN_INSERT behaviour (appfuse, dbunit)

[malteseunderdog]

Hi can anyone tell me how to turn off the automatic dropping and re-creation of the tables (who wants this ? after spending half an hour importing test data!).

This is really annoying and you would think this question FAQ material (it is not).  I looked all over the place for an answer - I must be thick.

Many Thanks - Appfuse is great! Well done!
JP

[Bini MukundanVisalakshy]

In the pom.xml, just comment out dbunit-maven-plugin
This is what i did to avoid that.

see the following section for example:It worked out for me.
But when you build you can it is trying create the table and  unsuccessful messages. It won't create any build error.
I couldn't find out the section to avoid that too.
Hope this will be helpful at least to avoid the automatic dropping.

Thanks,
Bini


<!--
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>dbunit-maven-plugin</artifactId>
                <version>1.0-beta-1</version>
                <configuration>
                    <dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
                    <driver>${jdbc.driverClassName}</driver>
                    <username>${jdbc.username}</username>
                    <password>${jdbc.password}</password>
                    <url>${jdbc.url}</url>
                    <src>src/test/resources/sample-data.xml</src>
                    <type>${dbunit.operation.type}</type>
                    <schema>${dbunit.schema}</schema>
                    <skip>${maven.test.skip}</skip>-->
                    <!-- <type>CLEAN_INSERT</type> --> <!--
                    <type>NONE</type>
                </configuration>
                <executions>
                    <execution>
                        <id>test-compile</id>
                        <phase>test-compile</phase>
                        <goals>
                            <goal>operation</goal>
                        </goals>
                    </execution>
                    <execution> -->
                        <!-- Runs before integration tests and jetty:run-war -->
                  <!--     <id>test</id>
                        <phase>test</phase>
                        <goals>
                            <goal>operation</goal>
                        </goals>
                    </execution>
                </executions>
                <dependencies>
                    <dependency>
                        <groupId>${jdbc.groupId}</groupId>
                        <artifactId>${jdbc.artifactId}</artifactId>
                        <version>${jdbc.version}</version>
                    </dependency>
                </dependencies>
            </plugin>
-->


>>> malteseunderdog <[hidden email]> 5/8/2009 9:50 AM >>>


Hi can anyone tell me how to turn off the automatic dropping and re-creation
of the tables (who wants this ? after spending half an hour importing test
data!).

This is really annoying and you would think this question FAQ material (it
is not).  I looked all over the place for an answer - I must be thick.

Many Thanks - Appfuse is great! Well done!
JP
--
View this message in context: http://www.nabble.com/Turn-off-CLEAN_INSERT-behaviour-%28appfuse%2C-dbunit%29-tp23449545s2369p23449545.html 
Sent from the AppFuse - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]



CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[Bini MukundanVisalakshy]

In the pom.xml, just comment out dbunit-maven-plugin
This is what i did to avoid that.

see the following section for example:It worked out for me.
But when you build you can see it is trying create the table and  unsuccessful messages. It won't create any build error.
I couldn't find out the section to avoid that too.
Hope this will be helpful at least to avoid the automatic dropping.

Thanks,
Bini


<!--
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>dbunit-maven-plugin</artifactId>
                <version>1.0-beta-1</version>
                <configuration>
                    <dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
                    <driver>${jdbc.driverClassName}</driver>
                    <username>${jdbc.username}</username>
                    <password>${jdbc.password}</password>
                    <url>${jdbc.url}</url>
                    <src>src/test/resources/sample-data.xml</src>
                    <type>${dbunit.operation.type}</type>
                    <schema>${dbunit.schema}</schema>
                    <skip>${maven.test.skip}</skip>-->
                    <!-- <type>CLEAN_INSERT</type> --> <!--
                    <type>NONE</type>
                </configuration>
                <executions>
                    <execution>
                        <id>test-compile</id>
                        <phase>test-compile</phase>
                        <goals>
                            <goal>operation</goal>
                        </goals>
                    </execution>
                    <execution> -->
                        <!-- Runs before integration tests and jetty:run-war -->
                  <!--     <id>test</id>
                        <phase>test</phase>
                        <goals>
                            <goal>operation</goal>
                        </goals>
                    </execution>
                </executions>
                <dependencies>
                    <dependency>
                        <groupId>${jdbc.groupId}</groupId>
                        <artifactId>${jdbc.artifactId}</artifactId>
                        <version>${jdbc.version}</version>
                    </dependency>
                </dependencies>
            </plugin>
-->



>>> malteseunderdog <[hidden email]> 5/8/2009 9:50 AM >>>


Hi can anyone tell me how to turn off the automatic dropping and re-creation
of the tables (who wants this ? after spending half an hour importing test
data!).

This is really annoying and you would think this question FAQ material (it
is not).  I looked all over the place for an answer - I must be thick.

Many Thanks - Appfuse is great! Well done!
JP
--
View this message in context: http://www.nabble.com/Turn-off-CLEAN_INSERT-behaviour-%28appfuse%2C-dbunit%29-tp23449545s2369p23449545.html 
Sent from the AppFuse - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]



CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[dusty]

There are a few things you can do.  The first is move dbunit and  
hibernate to their own profiles.  Then when you want them you can  
include -Pdb-setup or -Pdb-reset or whatever you name the profiles.    
So if I want to create the production database and seed it with data  
you would use -Pprod,db-setup,db-reset.  This way you don't accidently  
wipe out your prod database with dbunit.  Been there, thank god for  
good dbas.

Also having the hibernate plugin drop and create has it's uses, but  
you may want to change the <drop>true</drop> to <update>true</update>  
in the dbunit config.  It will only update your schema if your model  
changes and then only the affected parts.

On May 8, 2009, at 10:02 AM, "Bini MukundanVisalakshy" <[hidden email]
 > wrote:

> In the pom.xml, just comment out dbunit-maven-plugin
> This is what i did to avoid that.
>
> see the following section for example:It worked out for me.
> But when you build you can see it is trying create the table and  
> unsuccessful messages. It won't create any build error.
> I couldn't find out the section to avoid that too.
> Hope this will be helpful at least to avoid the automatic dropping.
>
> Thanks,
> Bini
>
>
> <!--
>            <plugin>
>                <groupId>org.codehaus.mojo</groupId>
>                <artifactId>dbunit-maven-plugin</artifactId>
>                <version>1.0-beta-1</version>
>                <configuration>
>                    <dataTypeFactoryName>$
> {dbunit.dataTypeFactoryName}</dataTypeFactoryName>
>                    <driver>${jdbc.driverClassName}</driver>
>                    <username>${jdbc.username}</username>
>                    <password>${jdbc.password}</password>
>                    <url>${jdbc.url}</url>
>                    <src>src/test/resources/sample-data.xml</src>
>                    <type>${dbunit.operation.type}</type>
>                    <schema>${dbunit.schema}</schema>
>                    <skip>${maven.test.skip}</skip>-->
>                    <!-- <type>CLEAN_INSERT</type> --> <!--
>                    <type>NONE</type>
>                </configuration>
>                <executions>
>                    <execution>
>                        <id>test-compile</id>
>                        <phase>test-compile</phase>
>                        <goals>
>                            <goal>operation</goal>
>                        </goals>
>                    </execution>
>                    <execution> -->
>                        <!-- Runs before integration tests and  
> jetty:run-war -->
>                  <!--     <id>test</id>
>                        <phase>test</phase>
>                        <goals>
>                            <goal>operation</goal>
>                        </goals>
>                    </execution>
>                </executions>
>                <dependencies>
>                    <dependency>
>                        <groupId>${jdbc.groupId}</groupId>
>                        <artifactId>${jdbc.artifactId}</artifactId>
>                        <version>${jdbc.version}</version>
>                    </dependency>
>                </dependencies>
>            </plugin>
> -->
>
>
>
>>>> malteseunderdog <[hidden email]> 5/8/2009 9:50 AM >>>
>
>
> Hi can anyone tell me how to turn off the automatic dropping and re-
> creation
> of the tables (who wants this ? after spending half an hour  
> importing test
> data!).
>
> This is really annoying and you would think this question FAQ  
> material (it
> is not).  I looked all over the place for an answer - I must be thick.
>
> Many Thanks - Appfuse is great! Well done!
> JP
> --
> View this message in context: http://www.nabble.com/Turn-off-CLEAN_INSERT-behaviour-%28appfuse%2C-dbunit%29-tp23449545s2369p23449545.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
>
> CONFIDENTIALITY NOTICE: This communication with its contents may  
> contain confidential and/or legally privileged information. It is  
> solely for the use of the intended recipient(s). Unauthorized  
> interception, review, use or disclosure is prohibited and may  
> violate applicable laws including the Electronic Communications  
> Privacy Act. If you are not the intended recipient, please contact  
> the sender and destroy all copies of the communication.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[wkbutler]

I was looking for a way to do this and found another way.  Similar to dusty's but I used the <skip> property in a profile.  I also had to tell hibernate3 not to drop tables:

<profile>
   <id>prod</id>
   <activation>
      <property><name>prod</name></property>
   </activation>
   <build>
      <plugins>
                <plugin>
                   <groupId>org.codehaus.mojo</groupId>
                   <artifactId>dbunit-maven-plugin</artifactId>
                   <configuration>
                      <skip>true</skip>
                   </configuration>
                </plugin>
        </plugins>
    </build>
    <properties>
         <!-- This is for hibernate3-maven-plugin -->
         <drop.tables>false</drop.tables>
    </properties>
</profile>

dusty wrote:

There are a few things you can do.  The first is move dbunit and  
hibernate to their own profiles.  Then when you want them you can  
include -Pdb-setup or -Pdb-reset or whatever you name the profiles.    
So if I want to create the production database and seed it with data  
you would use -Pprod,db-setup,db-reset.  This way you don't accidently  
wipe out your prod database with dbunit.  Been there, thank god for  
good dbas.

Also having the hibernate plugin drop and create has it's uses, but  
you may want to change the <drop>true</drop> to <update>true</update>  
in the dbunit config.  It will only update your schema if your model  
changes and then only the affected parts.

On May 8, 2009, at 10:02 AM, "Bini MukundanVisalakshy" <[e-mail]
 > wrote:

> In the pom.xml, just comment out dbunit-maven-plugin
> This is what i did to avoid that.
>
> see the following section for example:It worked out for me.
> But when you build you can see it is trying create the table and  
> unsuccessful messages. It won't create any build error.
> I couldn't find out the section to avoid that too.
> Hope this will be helpful at least to avoid the automatic dropping.
>
> Thanks,
> Bini
>
>
> <!--
>            <plugin>
>                <groupId>org.codehaus.mojo</groupId>
>                <artifactId>dbunit-maven-plugin</artifactId>
>                <version>1.0-beta-1</version>
>                <configuration>
>                    <dataTypeFactoryName>$
> {dbunit.dataTypeFactoryName}</dataTypeFactoryName>
>                    <driver>${jdbc.driverClassName}</driver>
>                    <username>${jdbc.username}</username>
>                    <password>${jdbc.password}</password>
>                    <url>${jdbc.url}</url>
>                    <src>src/test/resources/sample-data.xml</src>
>                    <type>${dbunit.operation.type}</type>
>                    <schema>${dbunit.schema}</schema>
>                    <skip>${maven.test.skip}</skip>-->
>                    <!-- <type>CLEAN_INSERT</type> --> <!--
>                    <type>NONE</type>
>                </configuration>
>                <executions>
>                    <execution>
>                        <id>test-compile</id>
>                        <phase>test-compile</phase>
>                        <goals>
>                            <goal>operation</goal>
>                        </goals>
>                    </execution>
>                    <execution> -->
>                        <!-- Runs before integration tests and  
> jetty:run-war -->
>                  <!--     <id>test</id>
>                        <phase>test</phase>
>                        <goals>
>                            <goal>operation</goal>
>                        </goals>
>                    </execution>
>                </executions>
>                <dependencies>
>                    <dependency>
>                        <groupId>${jdbc.groupId}</groupId>
>                        <artifactId>${jdbc.artifactId}</artifactId>
>                        <version>${jdbc.version}</version>
>                    </dependency>
>                </dependencies>
>            </plugin>
> -->
>
>
>
>>>> malteseunderdog <[e-mail]> 5/8/2009 9:50 AM >>>
>
>
> Hi can anyone tell me how to turn off the automatic dropping and re-
> creation
> of the tables (who wants this ? after spending half an hour  
> importing test
> data!).
>
> This is really annoying and you would think this question FAQ  
> material (it
> is not).  I looked all over the place for an answer - I must be thick.
>
> Many Thanks - Appfuse is great! Well done!
> JP
> --
> View this message in context: http://www.nabble.com/Turn-off-CLEAN_INSERT-behaviour-%28appfuse%2C-dbunit%29-tp23449545s2369p23449545.html
> Sent from the AppFuse - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>
>
> CONFIDENTIALITY NOTICE: This communication with its contents may  
> contain confidential and/or legally privileged information. It is  
> solely for the use of the intended recipient(s). Unauthorized  
> interception, review, use or disclosure is prohibited and may  
> violate applicable laws including the Electronic Communications  
> Privacy Act. If you are not the intended recipient, please contact  
> the sender and destroy all copies of the communication.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]