Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using oracle.jdbc.driver;
- using java.sql;
- using System.Diagnostics;
- using System.Collections.Generic;
- namespace IKVMTest
- {
- class MainClass
- {
- public static void Main (string[] args)
- {
- Stopwatch s = new Stopwatch ();
- s.Start ();
- List<object> l = new List<object> ();
- java.sql.DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ());
- Connection c = DriverManager.getConnection ("jdbc:oracle:thin:@database-host-on-vpn:1521:SID", "scott", "tiger");
- Statement stmt = c.createStatement ();
- ResultSet rset = stmt.executeQuery("select * from table");
- while (rset.next())
- l.Add (new { Number = rset.getInt (1) });
- stmt.close();
- s.Stop ();
- Console.WriteLine (l.Count);
- Console.WriteLine (s.Elapsed);
- }
- }
- }
Add Comment
Please, Sign In to add comment