Middlegen配置MSsql

Middlegen

1，将jdbc lib中3个jar包copy到应用的lib目录下，然后进行配置。
2，mssql.xml如下
 
   <!-- ant properties/targets for MS SQL Server                            -->
   <!-- note: this is not a proper xml file (there is no root element)      -->
   <!--       it is intended to be imported from a *real* xml file          -->
     <property name="database.script.file"           value=""/>
   <property name="database.driver.file"           value="${lib.dir}/mssqlserver.jar" />
   <property name="database.driver"                value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
   <property name="database.url"                   value="jdbc:microsoft:sqlserver://localhost:1433;database=dada"/>
   <property name="database.userid"                value="sa"/>
   <property name="database.password"              value="sa"/>
   <!-- In MS SQL the schema is the owner of the tables as displayed by SQL Server Enterprise Manager -->
   <property name="database.schema"                value="dbo"/>
   <!-- In MS SQL the catalog is the database, for example, 'Northwind' -->
   <property name="database.catalog"               value="dada"/>

   <property name="jboss.datasource.mapping"       value="MS SQLSERVER"/>
   <!--property name="jboss.datasource.mapping"       value="MS SQLSERVER2000"/-->
3，build.xml中
      <middlegen
         appname="${name}"
         prefsdir="${src.dir}"
         gui="${gui}"
         databaseurl="${database.url}"
         initialContextFactory="${java.naming.factory.initial}"
         providerURL="${java.naming.provider.url}"
         datasourceJNDIName="${datasource.jndi.name}"
         driver="${database.driver}"
         username="${database.userid}"
         password="${database.password}"  
          schema="dbo" //不是删除
         catalog="dada"    
         includeViews="false"
      >

4,提示符中到Middlegen目录运行ant middlegen

OK!