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" <bini.mukundanvisalak...@doj.ca.gov > 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 <j...@javaclass.co.uk> 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: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net



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: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net

Reply via email to