java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start manual transaction mode because there are cloned connection

Question

还有连接存在。
试试关关掉服务器中或Weblogic，重起再试

Answer 1

public java.lang.String ejbCreate(String account, java.sql.Date applyingTime, java.sql.Date beginTime, java.sql.Date endTime, Short peopleCount, String purpose, String destination, Boolean isInternalAuto) throws CreateException {
        /**@ Submit the application form*/
        String sqlStmnt = "INSERT applicationForm(account,applyingTime,beginTime,endTime,peopleCount,purpose,destination,isInteriorAuto) VALUES(?,?,?,?,?,?,?,?)";
        Context cntxt = null;
        try {
            cntxt = new InitialContext();
        }
        catch (NamingException ex) {
        }
        try {
            DataSource ds = (DataSource) cntxt.lookup("dslooa");
            Connection cnct = null;
            PreparedStatement ps = null;
            try {
                cnct = ds.getConnection();
                ps = cnct.prepareStatement(sqlStmnt);                ps.setString(1, account);
                ps.setDate(2, applyingTime);
                ps.setDate(3, beginTime);
                ps.setDate(4, endTime);
                ps.setShort(5, peopleCount.shortValue());
                ps.setString(6, purpose);
                ps.setString(7, destination);
                ps.setBoolean(8, isInternalAuto.booleanValue());
                ps.executeUpdate();
            }
            catch (SQLException ex2) {
                java.lang.System.out.println("Error ex2: " + ex2);
            }
            finally {
                try {
                    ps.close();
                }
                catch (SQLException ex3) {
                }
                try {
                    cnct.close();
                }
                catch (SQLException ex4) {
                }
            }
        }
        catch (NamingException ex1) {
            java.lang.System.out.println("Error ex1: " + ex1);
        }
        return account;
    }

Answer 2

这里不是程序的错误.好像是sqlserver的问题

Answer 3

加连接参数，如：
jdbc:microsoft:sqlserver://localhost:1433;databaseName=youdbname;SelectMethod=cursor

Answer 4

在ejbload和ejbstore
中关闭数据库
conn.close()
还有事务模式为bean