public void SQLSelectPasOK()
{
/// <testsummary>
/// SQLSelect Cas avec exception oracle
/// </testsummary>
JCASQLODPClient monSQLCliemt = new JCASQLODPClient();
monSQLCliemt.User = "******";
monSQLCliemt.Password = "******";
monSQLCliemt.OuvrirConnection();
try {
monSQLCliemt.SQLSelect("select count(*) from dualnexistepas");
} catch (Exception excep)
{
Assert.IsTrue(excep.Message.Contains ("ORA-"),
"Mauvais message " + excep.Message );
monSQLCliemt.FermerConnection();
}
monSQLCliemt.FermerConnection();
}
public void SQLSelectOKDeBase()
{
/// <testsummary>
/// SQLSelect cas les plui simples.
/// </testsummary>
JCASQLODPClient monSQLCliemt = new JCASQLODPClient();
monSQLCliemt.User = "******";
monSQLCliemt.Password = "******";
Assert.IsFalse(monSQLCliemt.SiConnectionOuverte (),
"La connection devrait être fermée");
monSQLCliemt.OuvrirConnection();
Assert.IsTrue(monSQLCliemt.SiConnectionOuverte(),
"La connection ne devrait pas être fermée");
monSQLCliemt.SQLSelect("select count(*) from dual");
monSQLCliemt.FermerConnection();
Assert.IsFalse(monSQLCliemt.SiConnectionOuverte(),
"La connection devrait être fermée");
}