struts1.1.b3的数据库连接问题！！！十万火急！！！！！

Question

给出我再JB8中用struts1。1连接sqlserver的例子，已经成功连接。我用ms jdbc
  <data-sources>
    <data-source>
      <set-property value="com.microsoft.jdbc.sqlserver.SQLServerDriver" property="driverClass" />
      <set-property value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Employees" property="url" />
      <set-property value="5" property="maxCount" />
      <set-property value="sa" property="user" />
      <set-property value="sa" property="password" />
      <set-property value="1" property="minCount" />
    </data-source>
  </data-sources>相应的action代码：
  protected String getUser(String username, String password) {
    String user = null;
    String copypassword = null;
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource)
        context.getAttribute(Action.DATA_SOURCE_KEY);
    try {
      conn = dataSource.getConnection();
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
      String sqlstring ="select * from employees where "
                       + "username='" + username + "' "
                       + "and password = '" + password + "'";
      rs =stmt.executeQuery(sqlstring);
      if ( rs.next() ) {
        user = rs.getString("username");
        copypassword=rs.getString("password");
// Iterate over the results
        System.err.println("Username : "
                           + user
                           + " Password : " + copypassword);
      }
      else {
        System.err.println("---->User not found<----");
      }
    }    catch (SQLException e) {
      System.err.println(e.getMessage());
    }
    finally {
      if (rs != null) {
        try {
          rs.close();
        }
        catch (SQLException sqle) {
          System.err.println(sqle.getMessage());
        }
        rs = null;
      }
      if (stmt != null) {
        try {
          stmt.close();
        }
        catch (SQLException sqle) {
          System.err.println(sqle.getMessage());
        }
        stmt = null;
      }
      if (conn != null) {
        try {
          conn.close();
        }
        catch (SQLException sqle) {
          System.err.println(sqle.getMessage());
        }
        conn = null;
      }
    }
    return user;
  }

Answer 1

<data-sources>
   <data-source>
     <set-property property="autoCommit"
                      value="false"/>
     <set-property property="description"
                      value="Example"/>
     <set-property property="driverClass"
                      value="oracle.jdbc.driver.OracleDriver"/>
     <set-property property="maxCount"
                      value="10"/>
     <set-property property="minCount"
                      value="2"/>
     <set-property property="password"
                      value="test"/>
     <set-property property="url"
                      value="dbc:oracle:thin:@10.0.2.122:1521:truelx"/>
     <set-property property="user"
                      value="test"/>
   </data-source>
 </data-sources>