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

[柯嘉]

WebLogic 8.1 + BMP EJB 出现以下错误：
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start
manual transaction mode because there are cloned connections.

该close的东西都close了，还要怎么办？

[dytsoft]

这里不是程序的错误.

好像是sqlserver的问题

[柯嘉]

Up.

[Wnyu]

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

[Morgan_ma]

程序。。。

[柯嘉]

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;
}

[eyeieye]

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

[ajoke]

不能开启事务模式？

[subscribe]

gz

[netcobol]

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