`
lenozhi
  • 浏览: 51032 次
社区版块
存档分类
最新评论

dbunit导出数据

阅读更多
<?xml version="1.0" encoding="UTF-8" ?>
<project basedir="."> 

 <property name="lib.dir" value="E:\workspace"/>
 <property name="dbunit.jar" value="${lib.dir}\dbunit\dbunit-2.3.0.jar"/>
 <property name="log.dir" value="C:\Downloads\slf4j-1.5.5\slf4j-1.5.5"/>
 <property name="jdbc.jar" value="${lib.dir}\cspass\bs\Lib\classes.jar"/>
 <property name="junit.jar" value="${lib.dir}\cspass\bs\Lib\junit.jar"/>

 <property name="dburl" value="jdbc:oracle:thin:@localhost:1521:orcl620"/>
 <property name="dbdriver" value="oracle.jdbc.driver.OracleDriver"/>
 <property name="dbuserid" value="cspass"/>
 <property name="dbpwd" value="cspasspwd"/>
<property name="schema" value="CSPASS"/>

 <path id="DbUnit.classpath">
  <pathelement location="${dbunit.jar}"/>
  <pathelement location="${jdbc.jar}"/>
  <pathelement location="${junit.jar}"/>
  <pathelement location="${log.dir}"/>
 </path>

 <target name="init">
    <taskdef name="dbunit" classname="org.dbunit.ant.DbUnitTask" classpathref="DbUnit.classpath"/>
 </target>

 <target name="export" depends="init">
  <dbunit driver="${dbdriver}"schema="${schema}" supportBatchStatement="false" url="${dburl}" userid="${dbuserid}" password="${dbpwd}" classpathref="DbUnit.classpath">
   <export dest="d:\\Export.xml">
   	
   </export>
  </dbunit>
 </target>
</project>
  

导出时必须指定schema,否则抛org.dbunit.database.AmbiguousTableNameException
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics