我用以下代码访问了一下数据库,连接应该已经关闭,为什么查看V$Session中,连接还存在啊。
OracleConnection connection = new OracleConnection(connString);
OracleCommand command = new OracleCommand(Query, connection);
OracleDataAdapter adapter = new OracleDataAdapter(command);
connection.Open();
System.Data.DataSet myDataSet = new System.Data.DataSet();
adapter.Fill(myDataSet,"Results");
connection.Close();
OracleConnection connection = new OracleConnection(connString);
OracleCommand command = new OracleCommand(Query, connection);
OracleDataAdapter adapter = new OracleDataAdapter(command);
connection.Open();
System.Data.DataSet myDataSet = new System.Data.DataSet();
adapter.Fill(myDataSet,"Results");
connection.Close();
此外,你可以看看以下两篇文章:
http://support.microsoft.com/kb/830173
http://support.microsoft.com/kb/929449
异常之前用
if()
……
try……
……
catch……
这样就比较容易的检查出问题的所在了!