我的middlegen-build.xml是用middlegenIDE生成的,连接的MS SQL SERVER每次在运行的时候总是出现下面的错误不知道是什么原因请指教!!!
The database doesn't have any table named Table2. Please make sure the table exists. Also note that some databases are case sensitive.
Found the following tables: middlegen-build.xml: <?xml version="1.0" encoding="utf-8"?> <!--
This build file is generated by MiddlegenIDE.
MiddlegenIDE: http://ultimania.org/middlegenide/
--> <project name="Middlegen Hibernate" default="compile" basedir="../.">
<property file=".././build.properties"/>
<property name="hibernate.cascade" value="all" />
<property name="package" value="org.ultimania.model" />
<property name="gen.xdoclet-tag" value="false" />
<property name="gui" value="true" />
<property name="jdbc.jar" value="C:\jtds-1.2.2.jar" />
<property name="database.driver" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="lib.dir" value="/D:/eclipse/plugins/net.sf.middlegen_2.1.91/lib/" />
<property name="database.url" value="jdbc:jtds:sqlserver://localhost:1433/Web;" />
<property name="database.userid" value="sa" />
<property name="database.password" value="123" />
<property name="database.schema" value="" />
<property name="database.catalog" value="Web" />
<property name="dest.dir" value="src" /> <target name="init" depends="prepare,fail-if-no-middlegen,fail-if-no-hibernate,fail-if-no-hibernate-ext"> <taskdef
name="middlegen"
classname="middlegen.MiddlegenTask"
classpathref="middlegen.classpath"
/> <taskdef
name="hbm2java"
classname="net.sf.hibernate.tool.hbm2java.Hbm2JavaTask"
classpathref="hibernate-ext.classpath"
/> <mkdir dir="${dest.dir}"/>
</target> <target name="prepare"> <path id="middlegen.classpath">
<pathelement path="${jdbc.jar}"/>
<fileset dir="${lib.dir}" includes="*.jar"/>
</path> <path id="hibernate-ext.classpath">
<fileset dir="${lib.dir}" includes="*.jar"/>
</path> <available property="middlegen" classname="middlegen.MiddlegenTask" classpathref="middlegen.classpath"/>
<available property="hibernate" classname="net.sf.hibernate.Hibernate" classpathref="hibernate-ext.classpath"/>
<available property="hibernate-ext" classname="net.sf.hibernate.tool.hbm2java.Hbm2JavaTask" classpathref="hibernate-ext.classpath"/>
</target> <target name="fail-if-no-middlegen" unless="middlegen">
<fail>
Middlegen is not found. Please install Middlegen.
</fail>
</target> <target name="fail-if-no-hibernate" unless="hibernate">
<fail>
Hibernate is not found. Please install Hibernate.
</fail>
</target> <target name="fail-if-no-hibernate-ext" unless="hibernate-ext">
<fail>
Hibernate-Extension is not found. Please install Hibernate-Extenstion.
</fail>
</target>
<target name="gen-hbm" depends="init"> <middlegen
appname="org.ultimania.model"
prefsdir="."
gui="${gui}"
databaseurl="${database.url}"
driver="${database.driver}"
username="${database.userid}"
password="${database.password}"
schema="${database.schema}"
catalog="${database.catalog}"
>
<hibernate
version="3.0"
destination="${dest.dir}"
package="${package}"
genXDocletTags="${gen.xdoclet-tag}"
standardCascade="${hibernate.cascade}"
javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
/>
<table name="idcard" />
<table name="Table1" />
<table name="Table2" />
<table name="Table3" />
</middlegen>
</target> <target name="gen-java" depends="gen-hbm">
<hbm2java output="${dest.dir}">
<fileset dir="${dest.dir}">
<include name="**/*.hbm.xml" />
</fileset>
</hbm2java>
</target> <target name="compile" depends="gen-java">
</target> </project>
The database doesn't have any table named Table2. Please make sure the table exists. Also note that some databases are case sensitive.
Found the following tables: middlegen-build.xml: <?xml version="1.0" encoding="utf-8"?> <!--
This build file is generated by MiddlegenIDE.
MiddlegenIDE: http://ultimania.org/middlegenide/
--> <project name="Middlegen Hibernate" default="compile" basedir="../.">
<property file=".././build.properties"/>
<property name="hibernate.cascade" value="all" />
<property name="package" value="org.ultimania.model" />
<property name="gen.xdoclet-tag" value="false" />
<property name="gui" value="true" />
<property name="jdbc.jar" value="C:\jtds-1.2.2.jar" />
<property name="database.driver" value="net.sourceforge.jtds.jdbc.Driver" />
<property name="lib.dir" value="/D:/eclipse/plugins/net.sf.middlegen_2.1.91/lib/" />
<property name="database.url" value="jdbc:jtds:sqlserver://localhost:1433/Web;" />
<property name="database.userid" value="sa" />
<property name="database.password" value="123" />
<property name="database.schema" value="" />
<property name="database.catalog" value="Web" />
<property name="dest.dir" value="src" /> <target name="init" depends="prepare,fail-if-no-middlegen,fail-if-no-hibernate,fail-if-no-hibernate-ext"> <taskdef
name="middlegen"
classname="middlegen.MiddlegenTask"
classpathref="middlegen.classpath"
/> <taskdef
name="hbm2java"
classname="net.sf.hibernate.tool.hbm2java.Hbm2JavaTask"
classpathref="hibernate-ext.classpath"
/> <mkdir dir="${dest.dir}"/>
</target> <target name="prepare"> <path id="middlegen.classpath">
<pathelement path="${jdbc.jar}"/>
<fileset dir="${lib.dir}" includes="*.jar"/>
</path> <path id="hibernate-ext.classpath">
<fileset dir="${lib.dir}" includes="*.jar"/>
</path> <available property="middlegen" classname="middlegen.MiddlegenTask" classpathref="middlegen.classpath"/>
<available property="hibernate" classname="net.sf.hibernate.Hibernate" classpathref="hibernate-ext.classpath"/>
<available property="hibernate-ext" classname="net.sf.hibernate.tool.hbm2java.Hbm2JavaTask" classpathref="hibernate-ext.classpath"/>
</target> <target name="fail-if-no-middlegen" unless="middlegen">
<fail>
Middlegen is not found. Please install Middlegen.
</fail>
</target> <target name="fail-if-no-hibernate" unless="hibernate">
<fail>
Hibernate is not found. Please install Hibernate.
</fail>
</target> <target name="fail-if-no-hibernate-ext" unless="hibernate-ext">
<fail>
Hibernate-Extension is not found. Please install Hibernate-Extenstion.
</fail>
</target>
<target name="gen-hbm" depends="init"> <middlegen
appname="org.ultimania.model"
prefsdir="."
gui="${gui}"
databaseurl="${database.url}"
driver="${database.driver}"
username="${database.userid}"
password="${database.password}"
schema="${database.schema}"
catalog="${database.catalog}"
>
<hibernate
version="3.0"
destination="${dest.dir}"
package="${package}"
genXDocletTags="${gen.xdoclet-tag}"
standardCascade="${hibernate.cascade}"
javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
/>
<table name="idcard" />
<table name="Table1" />
<table name="Table2" />
<table name="Table3" />
</middlegen>
</target> <target name="gen-java" depends="gen-hbm">
<hbm2java output="${dest.dir}">
<fileset dir="${dest.dir}">
<include name="**/*.hbm.xml" />
</fileset>
</hbm2java>
</target> <target name="compile" depends="gen-java">
</target> </project>
这个数据库没有Table2这个表,请确认<table name="Table2" /> 这里有问题吧
要在路径“eclipse\plugins\net.sf.middlegen_2.1.1\lib”
(也就是middlegenIDE在MyEclipse中的插件安装路径下的lib目录)
添加那3个SQL的JAR驱动包。添加好后就可以生成XML了另外,别忘记配置ANT的环境变量
<property file="./build.properties"/>
<property name="hibernate.cascade" value="all" />
<property name="package" value="com.hibernate.tsby.beans" />
<property name="gen.xdoclet-tag" value="false" />
<property name="gui" value="true" />
<property name="jdbc.jar" value="D:\Source\MyEclipse\TSBYTest\WebRoot\WEB-INF\lib\mssqlserver.jar" />
<property name="database.driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<property name="lib.dir" value="/D:/Program/MyEclipse 6.0/eclipse/plugins/net.sf.middlegen_2.1.1/lib/" />
<property name="database.url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=taishanTest" />
<property name="database.userid" value="sa" />
<property name="database.password" value="sa" />
<property name="database.schema" value="dbo" />
<property name="database.catalog" value="taishanTest" />
<property name="dest.dir" value="src" />
正确的配置如下: <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<property name="connection.username">sa</property>
<property name="connection.password">sa</property>
<property name="connection.url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=taishanTest</property>
<property name="show_sql">true</property>
<mapping resource="com/hibernate/tsby/beans/Kp.hbm.xml" />
<mapping resource="com/hibernate/tsby/beans/Userinfo.hbm.xml" />
改为:
<property name="database.schema" value="dbo" />
再试试