W3CHINA.ORG讨论区--WS紧急求助！admin请进！

贴子主题： WS紧急求助！admin请进！

本主题类别:

测试环境：
1，J2EE5+NETBEANS5.5BETA2里测试web service的开发，连接数据库出错。
2,WINXP
问题求助：
具体怎么通过@Source调用SQLSERVER数据库？
****************************
connectionPool:
<?xml version="1.0" encoding="UTF-8"?>
<resources>
<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit"

datasource-classname="com.microsoft.jdbcx.sqlserver.SQLServerDataSource" fail-all-connections="false"

idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-

guaranteed="true" max-pool-size="32" max-wait-time-in-millis="60000" name="connectionPool" non-

transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" steady-pool

-size="8" validation-table-name="TAB_NAME">
    <property name="URL" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DLib_db"/>
    <property name="User" value="duanwei"/>
    <property name="Password" value="123"/>
  </jdbc-connection-pool>
</resources>
dataSource :
<?xml version="1.0" encoding="UTF-8"?>
<resources>
  <jdbc-resource enabled="true" jndi-name="jdbc/816ds" object-type="user" pool-name="connectionPool">
    <description/>
  </jdbc-resource>
</resources>

******************************
package cn.whu.ws;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.annotation.Resource;
import javax.ejb.Stateless;
import javax.jws.WebService;
import javax.jws.WebMethod;
import javax.jws.WebParam;

@Stateless()
@WebService()
public class NewWebService1 {
private boolean b=false;
private javax.sql.DataSource myDB;
@Resource(name="jdbc/816ds")
private void setMyDB(javax.sql.DataSource ds) {
myDB = ds;
System.out.println("11111111111");
}

    @WebMethod
    public String Search_db(@WebParam(name = "name") String name) {
        try {
            // TODO implement operation
            Connection conn=myDB.getConnection();
            System.out.println("2222222222");
            Statement stat=conn.createStatement();
            System.out.println("3333333333333");
         b= stat.execute("CREATE TABLE Temp_table (bookName char(200),author char(100),institution

char(1000),keyword char(1000),Cabstract char(3000),cdNo char(100),litNo char(100),CpubName char

(100),Year char(30),PerNo char(30),CN char(100),ISSN char(100),fileName char(100),page char

(100),classNo char(100),subjectNo char(100),sourceDB char(100),book_id bigint)");
          if(b)System.out.println("finish!");
           // stat.execute();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return name+" want to search db!";
    }

}
****************************

run project:

11111111111|#]
RAR5038:Unexpected exception while creating resource
RAR5117 : Failed to obtain/create connection. Reason : Connection could not be allocated because:

[Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. DataSource property serverName must be

specified.
RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not

be allocated because: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. DataSource

property serverName must be specified.]

java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated

because: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. DataSource property serverName

must be specified.
at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:100)
at cn.whu.ws.NewWebService1.Search_db(NewWebService1.java:47)
......


	W 3 C h i n a ( since 2003 ) 旗下站点苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》	2,265.625ms