struts-config.xml中配置数据库部分如下:
<data-sources>
<data-source type="net.sourceforge.jtds.jdbcx.JtdsDataSource">
<set-property property="autoCommit" value="true" />
<set-property property="description" value="MS SQL SERVER 2000 Data Source" />
<set-property property="driverClass" value="net.sourceforge.jtds.jdbc.Driver" />
<set-property property="maxCount" value="10" />
<set-property property="minCount" value="2" />
<set-property property="user" value="sa" />
<set-property property="password" value="abc" />
<set-property property="url" value="jdbc:jtds:sqlserver://154.3.2.73:1433/testDB;tds=8.0;lastupdatecount=true" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="60" />
</data-source>
</data-sources>启动正常,在运行时Action类中执行
try{
DataSource ds = this.getDataSource(request); //语句1
java.sql.Connection conn = ds.getConnection(); //语句2
}
catch(Exception e){
System.out.println("e = " + e.getMessage());
}时报错:e = The serverName property has not been set.语句1能正常执行,语句2报错,请问是什么原因啊??
<data-sources>
<data-source type="net.sourceforge.jtds.jdbcx.JtdsDataSource">
<set-property property="autoCommit" value="true" />
<set-property property="description" value="MS SQL SERVER 2000 Data Source" />
<set-property property="driverClass" value="net.sourceforge.jtds.jdbc.Driver" />
<set-property property="maxCount" value="10" />
<set-property property="minCount" value="2" />
<set-property property="user" value="sa" />
<set-property property="password" value="abc" />
<set-property property="url" value="jdbc:jtds:sqlserver://154.3.2.73:1433/testDB;tds=8.0;lastupdatecount=true" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="60" />
</data-source>
</data-sources>启动正常,在运行时Action类中执行
try{
DataSource ds = this.getDataSource(request); //语句1
java.sql.Connection conn = ds.getConnection(); //语句2
}
catch(Exception e){
System.out.println("e = " + e.getMessage());
}时报错:e = The serverName property has not been set.语句1能正常执行,语句2报错,请问是什么原因啊??
谢谢楼上的兄弟,不过在struts-config.xml中配置数据库也是可以的,ActionServlet通过web.xml文件在启动的时候加载该文件,然后通过Action类的getDataSource(request);方法可以获取数据源的