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"
>
上一篇： Java 中文问题的解决 mysql, oracle, servlet, jsp
下一篇： 解决Tomcat 编码问题的Character Encoding 另类过滤器实现.
文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
