diff options
author | Tim Coleman <tim@mono-cvs.ximian.com> | 2003-02-19 19:36:34 +0300 |
---|---|---|
committer | Tim Coleman <tim@mono-cvs.ximian.com> | 2003-02-19 19:36:34 +0300 |
commit | f0e7f36badecd0c252eb465ffcad02b13900eba9 (patch) | |
tree | beb990117d4c32efb60ac014d1858ee07544f230 /web/oracle | |
parent | 92dfad552e464f4695e6b11b1a3c1cf408c7314e (diff) |
2003-02-19 Tim Coleman <tim@timcoleman.com>
* oracle: update oracle status page
svn path=/trunk/mono/; revision=11731
Diffstat (limited to 'web/oracle')
-rwxr-xr-x | web/oracle | 51 |
1 files changed, 30 insertions, 21 deletions
diff --git a/web/oracle b/web/oracle index eef9e2717fb..921954aef0b 100755 --- a/web/oracle +++ b/web/oracle @@ -10,6 +10,8 @@ <li>Works with Oracle 8i</li> + <li>Untested, but should work with Oracle 9i</li> + <li>Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client software</li> @@ -49,14 +51,21 @@ System.Data.OracleClient.build nant build file.</li> <li>Can retrieve data via ExecuteReader and OracleDataReader. Currently, - only simple character - data is supported. ExecuteScalar() still needs to be imlemented.</li> + supports character, numeric, some date data types. ExecuteScalar + also works.</li> + + <li>Simple input parameters (character and numeric data) can now + be used in SQL queries. Output parameters do not yet work.</li> <li>OracleException and Error handling exists now.</li> + + <li>Message handling needs to be added for non-critical messages + received from Oracle</li> - <li>Handling of various data types need to be handled</li> + <li>Handling of various data types need to be added.</li> - <li>Data Adapter needs to be created. Tim has started on it.</li> + <li>Data Adapter exists, and a DataSet can be filled using it. The + Data Adapter is abstract enough that it should work as expected.</li> <li>Lots of missing functionality and bugs.</li> @@ -69,12 +78,12 @@ ** Action Plan <ul> - <li>Be able to retrieve results via a data reader</li> - <li>Parameters support</li> - <li>transactions</li> + <li>Be able to retrieve results via a data reader (WORKING)</li> + <li>Parameters support (IN PROGRESS)</li> + <li>transactions (WORKING)</li> <li>Stored Procedures, Functions, and Packages support</li> - <li>Be able to fill a DataTable in a DataSet via a data adapter</li> - <li>Support for Oracle 8i and 9i</li> + <li>Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)</li> + <li>Support for Oracle 8i and 9i (UNKNOWN)</li> <li>Support LOBs</li> <li>Support all the data types</li> <li>Implement Connection pooling</li> @@ -90,7 +99,7 @@ <li>Have access to an Oracle 8i database or download it from <a href="http://www.oracle.com/">Oracle</a>. If you are connecting remotely to an Oracle database, you need the Oracle client software. - Registration to the Oracle Technology Network is free. If installing on Linux, + Registration to the <a href="http://technet.oracle.com/">Oracle Technology Network</a> is free. If installing on Linux, I suggest you do a lot of searching to see how others installed Oracle on Linux.</li> <li>Make sure System.Data.OracleClient.dll assembly is built, if not, go @@ -114,33 +123,33 @@ public class Test { - public static void Main(string[] args) + public static void Main (string[] args) { string connectionString = "Data Source=testdb;" + "User ID=scott;" + "Password=tiger;"; IDbConnection dbcon; - dbcon = new OracleConnection(connectionString); - dbcon.Open(); - IDbCommand dbcmd = dbcon.CreateCommand(); + dbcon = new OracleConnection (connectionString); + dbcon.Open (); + IDbCommand dbcmd = dbcon.CreateCommand (); string sql = "SELECT ename, job FROM scott.emp"; dbcmd.CommandText = sql; - IDataReader reader = dbcmd.ExecuteReader(); - while(reader.Read()) { + IDataReader reader = dbcmd.ExecuteReader (); + while (reader.Read ()) { string employeeName = reader["ename"]; string job = reader["job"]; - Console.WriteLine("Employee Name: {0} Job: {1}", + Console.WriteLine ("Employee Name: {0} Job: {1}", employeeName, job); } // clean up - reader.Close(); + reader.Close (); reader = null; dbcmd.CommandText = sql; - dbcmd.ExecuteNonQuery(); - dbcmd.Dispose(); + dbcmd.ExecuteNonQuery (); + dbcmd.Dispose (); dbcmd = null; - dbcon.Close(); + dbcon.Close (); dbcon = null; } } |