JDBCµ÷ÓÃSql server 2005 ´æ´¢¹ý³Ì³öÏÖµÄÎÊÌâ

»·¾³£ºJDK1.5
Êý¾Ý¿â£ºSql server 2005 +sp2
JDBCÇý¶¯£ºsqljdbc.jar
²âÊÔÀà´úÂëÈçÏ£º
import java.sql.*;
public class test {
 /**
  * @param args
  * @throws SQLException
  * @throws ClassNotFoundException
  */
 public static void main(String[] args) throws SQLException, ClassNotFoundException {
  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  Connection con = DriverManager.getConnection("jdbc:sqlserver://192.168.1.168:1433;SelectMethod=cursor;DatabaseName=DBName", "sa", "sa");
  
  //PreparedStatement ps = con.prepareCall("exec Proc_checkPDDateTime '00','00'");  --ʹÓÃPreparedStatementÒ²¿ÉÒÔ
  CallableStatement ps = con.prepareCall("{call dbo.Proc_checkPDDateTime('1602327','20100526162514')}");
  
  //{µÚÒ»ÖÖ·½Ê½}  Á½ÖÖ·½Ê½µ÷Óô洢¹ý³ÌµÄ·µ»ØÖµ¶¼¿ÉÒÔ
//  ResultSet rs= ps.executeQuery();
//  if(rs.next()){
//   System.out.println("--"+rs.getString(1)+"--");
//  }
  
  //{µÚ¶þÖÖ·½Ê½}
  if(ps.execute()){  --Èç¹ûpsÖ´Ðк󷵻صÄÊÇResultSet,ÄÇôps.execute·µ»ØTrue ,ÇÒ±ØÐëҪͨ¹ýps.getResultSet()·½·¨»ñµÃ½á¹û¼¯
   if(ps.getResultSet().next()){
    System.out.println("--"+ps.getResultSet().getString(1)+"--");
   }
  }
 }
}
ÔËÐÐʱ£¬ÌáʾÈçÏ´íÎó£º
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: ÎÞ·¨ÔÚ¸ø¶¨µÄÓï¾äÖдò¿ª·þÎñÆ÷ÓαꡣÇëʹÓÃĬÈϽá¹û¼¯»ò¿Í»§¶ËÓαꡣ
 at com.microsoft.sqlserver.jdbc.SQLServerException.makefromDatabaseError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerPrepa