1 * 1. connect ,disconnect and again connect, it should pass. (conntest1.c) -> (conntest1.c)
3 2. Pass correct username and incorrect password ,it should fail.(conntest9.c)
4 Pass incorrect user name and password ,it should fail.(conntest8.c)
5 Pass correct user name and password ,it should pass. (conntest7.c) -> (userauthentication.c)
7 3. connect twice without closing the connection.
8 second conection should return "user already logged in". (conntest6.c) ->(connecttwicewithoutclose.c)
10 4. closing the connection twice with single connect.
11 second close should return "User not logged in". (new case.) -> (closetwicewithoutconnect.c)
13 5. close the connection and call prepare ,it should fail. (conntest3.c) -> (prepareafterclose.c)
15 6. close the connection and call execute,it should fail. (conntest4.c) -> (executeafterclose.c)
17 7. create table T1 ,Insert some records in it.
18 Close the connection Fetch should fail. (conntest5.c ) -> (fetchafterclose.c)
20 8. close the connection and call commit, it should fail. (conntest2.c)
21 close the connection and call rollback, it should fail. (conntest2.c to be modified for rollback)
22 -> (transactionafterclose.c)
24 9. Connect and dissconnect 5000 times. it should pass.(new case. follow jdbc/Con/ConnTest2.java)
25 -> (connect5000times.c)