19 Commits
Author SHA1 Message Date
Neale Ferguson 0b26afc182 Fix memory leaks in Oracle Client. The largest leaks come from the cursors being created but never freed in OracleParameter.cs. The size of the memory used by these cursors varies from tens to thousands of bytes depending on the statement being executed. Several hours of transactions can lead to OOM errors. The other fixes are relatively minor but they do clean up other unmanaged memory not being returned. 2013-10-10 13:17:17 -04:00
Raja R Harinath cd51491631 Fix a few cases of mixed line-endings
This is a scripted conversion of mixed line-ending files to LF-only or CRLF-only
based on which patch is smaller.  I used a threshold of upto a quarter of the
lines to determine whether to keep the patch or not.
2010-07-26 02:20:13 +05:30
Daniel Morgan f9992d7537 2008-08-26 Daniel Morgan <[email protected]>
* System.Data.OracleClient/OracleParameter.cs
	* System.Data.OracleClient.Oci/OciStatementHandle.cs
	* System.Data.OracleClient.Oci/OciDefineHandle.cs: fix bug
	for GetOracleLob in OracleDataReader that was created
	via a REF CURSOR.  Bug occurred because the cursor when created
	did not have a ServiceContext - this was solved by passing
	the connection in which did.  Fixes bug#350408.  In OracleParameter, also
	show the data type that is not implemented.

	* Test/testblob.cs
	* Test/TestOracleClient.cs: updated tests

	* Test/refcursortest.cs: added ref cursor test with blob

svn path=/trunk/mcs/; revision=111595
2008-08-26 06:33:55 +00:00
Senganal T 11479fa2e1 2006-03-10 Senganal T <[email protected]>
* System.Data.OracleClient.Oci/OciStatementHandle.cs : Get StatementType as a ushort value.
	* System.Data.OracleClient.Oci/OciParameterDescriptor.cs : Get DataType as a ushort value.

	Fixes bug #71318.

svn path=/trunk/mcs/; revision=57762
2006-03-10 05:24:51 +00:00
Daniel Morgan 623727e08d REF CURSOR support. See ChangeLog for 2005-12-11 Daniel Morgan <[email protected]>
svn path=/trunk/mcs/; revision=54216
2005-12-11 22:38:21 +00:00
Daniel Morgan bf25ad7058 2005-07-10 Daniel Morgan <[email protected]>
* System.Data.OracleClient/OracleCommand.cs: support
	CommandBehavior of SchemaOnly

	* System.Data.OracleClient/OracleCommandBuilder.cs:
	implement OracleCommandBuilder.  Does not work yet.

	* System.Data.OracleClient/OracleDataReader.cs:
	implement CommandBehavior of KeyInfo which is required
	for OracleCommandBuilder.  Correct data retreived via
	GetSchemaTable()

	* System.Data.OracleClient.Oci/OciParameterDescriptor.cs: add
	method to convert a OciDataType enum to OracleDataType enum
	
	* System.Data.OracleClient.Oci/OciStatementHandle.cs: allow
	execute of DescribeOnly to support CommandBehavior.SchemaOnly

	* Test/OracleAdapterTest.cs: add file for adapter tests

svn path=/trunk/mcs/; revision=47156
2005-07-10 20:43:31 +00:00
Daniel Morgan d3c298e5e0 2005-01-09 Daniel Morgan <[email protected]>
* System.Data.OracleClient/OracleCommand.cs: set Command
	property on OciStatementHandle
	
	* System.Data.OracleClient/OracleConnection.cs: implement
	properties ServerVersion and DataSource, partially
	implement method ICloneable Clone, implement
	connection StateChange and InfoMessage events
	
	* System.Data.OracleClient/OciGlue.cs: add internal properties
	for OciSessionHandle and OciServerHandle
	
	* System.Data.OracleClient/OracleInfoMessageEventArgs.cs:
	implement
	
	* Test/TestOracleClient.cs: add new tests
	
	* System.Data.OracleClient.Oci/OciStatementHandle.cs: 
	- add property for OracleCommand
	- patch from Joost Evertse <[email protected]>
	  for handling OCI_SUCCES_WITH_INFO during Fetch which
	  indicates a Warning info message
	
	* System.Data.OracleClient.Oci/OciCalls.cs: added OCI call
	OCIServerVersion
	
	* System.Data.OracleClient.Oci/OciDefineHandle.cs: flush

svn path=/trunk/mcs/; revision=38585
2005-01-10 03:35:25 +00:00
Daniel Morgan bd13a44741 2005-01-06 Daniel Morgan <[email protected]>
* Assembly/AssemblyInfo.cs: updated copyright
	
	* System.Data.OracleClient/OracleCommand.cs: add 
	connection string parameter "Server" and 
	removed "Database" to match .NET
	
	* System.Data.OracleClient/OracleLob.cs: handle 
		BLOBs and CLOBs that are not null, but are empty
	
	* System.Data.OracleClient/OracleCommand.cs: started 
		implementing Clone and ExecuteOracleScalar
	
	* System.Data.OracleClient/OracleDataReader.cs: modified
	- ms.net has GetDataTypeName return data types upper case
	- implement	GetFieldType
	- implement GetOracleValues, GetOracleValue, 
	  GetOracleDateTime, GetOracleNumber, GetOracleString
	- modified GetOracleLob based on internal change
	- fix GetSchemaTable to return the correct "DataType" 
		instead of always being System.String
	- GetValue should return Blobs as a byte array and Clobs 
		as a string
	- Test/TestOracleClient.cs: updated Mono Oracle Tests
	- System.Data.OracleClient.Oci/OciCalls.cs: update 
		DllImports for data type, actual data size, and iters

	* System.Data.OracleClient.Oci/OciDefineHandle.cs: modified
	- added properties for precision and field type
	- if ROWID is specified in a SELECT statement, handle 
		the data type of OciDataType.RowIdDescriptor by just 
		treating it as 10 byte string
	- do not free a HGlobal handle for a LOB since they do
		not get a HGlobal created for them
	- GetValue should return an OracleLob for BLOBs and CLOBs
	
	* System.Data.OracleClient.Oci/OciDataType.cs: make enum
	OciDataType to be uint
	
	* System.Data.OracleClient.Oci/OciParameterDescriptor.cs:
	- add function to convert Oracle's data type name 
		to .net data type name
		
	* System.Data.OracleClient.Oci/OciRowIdDescriptor.cs: flush	

svn path=/trunk/mcs/; revision=38419
2005-01-06 07:27:41 +00:00
Gonzalo Paniagua Javier 64f41b5283 2004-05-25 Gonzalo Paniagua Javier <[email protected]>
* System.Data.OracleClient/OracleCommand.cs:
	* System.Data.OracleClient/OracleDataReader.cs:
	* System.Data.OracleClient.Oci/OciStatementHandle.cs: patch by Eduard
	Nesiba that implements autocommit behavior for non query statement
	which is out of transaction. In previous implementation changed rows
	stayed locked until client disconnect and hasRows proper settings.

svn path=/trunk/mcs/; revision=28019
2004-05-25 00:49:50 +00:00
Miguel de Icaza 7665cb70ff 2004-05-10 Joerg Rosenkranz <[email protected]>
* System.Data.OracleClient.Oci/OciCalls.cs:
		Added OCI calls OCICharSetToUnicode and OCIUnicodeToCharSet.
 	* System.Data.OracleClient.Oci/OciStatementHandle.cs:
 		Changed statement encoding from UTF8 to OCIUnicodeToCharSet.
 	* System.Data.OracleClient.Oci/OciDefineHandle.cs:
 		Changed string encoding from UTF8 to OCICharSetToUnicode.

svn path=/trunk/mcs/; revision=27855
2004-05-21 22:21:59 +00:00
Miguel de Icaza ca52e918c1 Patch from Joerg Rosenkranz
2004-03-31  Joerg Rosenkranz  <[email protected]>

	* System.Data.OracleClient.Oci/OciDefineHandle.cs:
		Changed DefineChar to allow retrieval of
		multibyte characters (i.e. german umlauts).
	* System.Data.OracleClient.Oci/OciStatementHandle.cs:
		OciDefineHandles are now disposed in the
		Dispose function.

svn path=/trunk/mcs/; revision=24996
2004-04-03 17:19:03 +00:00
Tim Coleman ed01c03f13 Patch submitted by Joerg Rosenkranz:
2004-01-26  Joerg Rosenkranz  <[email protected]>

        * System.Data.OracleClient.Oci/OciCalls.cs:
                Changed binding of OciStmtPrepare from string
                to byte [].
        * System.Data.OracleClient.Oci/OciDefineHandle.cs:
                Character types are converted using UTF8 encoding.
        * System.Data.OracleClient.Oci/OciStatementHandle.cs:
                SQL statement to be prepared is converted to byte
                array using UTF8 encoding.

svn path=/trunk/mcs/; revision=22579
2004-01-28 15:34:04 +00:00
Tim Coleman fe3197aa40 Submitted thanks to patch from Joerg Rosenkranz ...
2004-01-09  Joerg Rosenkranz  <[email protected]>

        * System.Data.OracleClient.Oci/OciCalls.cs:
                Added. It contains all external OCI calls which are
                removed from all other files.
        * System.Data.OracleClient/OciGlue.cs:
                Fix for #52699 (OCI not thread safe).
        * System.Data.OracleClient.Oci/OciHandle.cs:
                Introduced special handling for Bind, Define and
                Environment handles in FreeHandle. Revised the handling for
                other types. Minor change in Dispose.
                Replaced OCI calls.
        * System.Data.OracleClient.Oci/OciDescriptorHandle.cs:
                Special handling for Parameter handles in FreeHandle.
                Replaced OCI calls.
        * System.Data.OracleClient.Oci/OciDefineHandle.cs:
                Character types are converted using the DefaultEncoding.
                Replaced OCI calls.
        * System.Data.OracleClient/OracleCommand.cs:
                Dispose created OciStatementHandles.
        * System.Data.OracleClient/OracleDataReader.cs:
                Dispose used OciStatementHandle.
        * System.Data.OracleClient/OracleTransaction.cs:
                Dispose transaction handle.
        * System.Data.OracleClient.Oci/OciStatementHandle.cs:
                OCI_INVALID_HANDLE results in exception "Invalid handle."
                Replaced OCI calls.
        * System.Data.OracleClient.Oci/OciTransactionHandle.cs:
                Introduced DetachFromServiceContext which is called in Commit
                and Rollback (Fix for #52702).
        * System.Data.OracleClient/OracleParameter.cs:
        * System.Data.OracleClient.Oci/OciEnvironmentHandle.cs:
        * System.Data.OracleClient.Oci/OciErrorHandle.cs:
        * System.Data.OracleClient.Oci/OciLobLocator.cs:
        * System.Data.OracleClient.Oci/OciServerHandle.cs:
        * System.Data.OracleClient.Oci/OciServiceHandle.cs:
        * System.Data.OracleClient.Oci/OciSessionHandle.cs:
                Replaced OCI calls.

svn path=/trunk/mcs/; revision=21877
2004-01-09 14:52:39 +00:00
Tim Coleman 0657be2d9c 2003-03-08 Tim Coleman <[email protected]>
* System.Data.OracleClient.Oci/OciRowIdDescriptor.cs:
        * list:
                New class added
        * System.Data.OracleClient/OciGlue.cs:
        * System.Data.OracleClient/OracleDataReader.cs:
        * System.Data.OracleClient/OracleLob.cs:
        * System.Data.OracleClient.Oci/OciBindHandle.cs:
        * System.Data.OracleClient.Oci/OciDataType.cs:
        * System.Data.OracleClient.Oci/OciDefineHandle.cs:
        * System.Data.OracleClient.Oci/OciDescriptorHandle.cs:
        * System.Data.OracleClient.Oci/OciErrorHandle.cs:
        * System.Data.OracleClient.Oci/OciHandle.cs:
        * System.Data.OracleClient.Oci/OciLobLocator.cs:
        * System.Data.OracleClient.Oci/OciParameterDescriptor.cs:
        * System.Data.OracleClient.Oci/OciServerHandle.cs:
        * System.Data.OracleClient.Oci/OciServiceHandle.cs:
        * System.Data.OracleClient.Oci/OciSessionHandle.cs:
                Small changes
        * System.Data.OracleClient/OracleBoolean.cs:
                Change Null definition
        * System.Data.OracleClient/OracleCommand.cs:
                More implementation, more toward getting ExecuteOracle*
        * System.Data.OracleClient/OracleConnection.cs:
                Add new handle properties
        * System.Data.OracleClient/OracleParameter.cs:
        * System.Data.OracleClient.Oci/OciStatementHandle.cs:
                Move binding operation to oracle parameter.

svn path=/trunk/mcs/; revision=12356
2003-03-08 22:37:09 +00:00
Tim Coleman 8c246fd3c7 2003-03-04 Tim Coleman <[email protected]>
* System.Data.OracleClient.Oci/IOciDescriptorHandle.cs:
	* System.Data.OracleClient.Oci/IOciHandle.cs:
	* System.Data.OracleClient.Oci/OciDescriptorType.cs:
		Removed. These are no longer used.
	* System.Data.OracleClient.Oci/OciParameterDescriptor.cs:
		Add new class
	* list:
		Add System.Data.OracleClient.Oci/OciParameterDescriptor.cs
		Rem System.Data.OracleClient.Oci/IOciDescriptorHandle.cs
		Rem System.Data.OracleClient.Oci/IOciHandle.cs
		Rem System.Data.OracleClient.Oci/OciDescriptorType.cs
	* System.Data.OracleClient/OciGlue.cs:
		Move the OCIAttrGet* methods into OciHandle
	* System.Data.OracleClient/OracleDataReader.cs:
	* System.Data.OracleClient/OracleParameter.cs:
		Change the way that columns are bound and described
	* System.Data.OracleClient.Oci/OciBindHandle.cs:
	* System.Data.OracleClient.Oci/OciDefineHandle.cs:
	* System.Data.OracleClient.Oci/OciDescriptorHandle.cs:
	* System.Data.OracleClient.Oci/OciEnvironmentHandle.cs:
	* System.Data.OracleClient.Oci/OciErrorHandle.cs:
	* System.Data.OracleClient.Oci/OciHandle.cs:
	* System.Data.OracleClient.Oci/OciLobLocator.cs:
	* System.Data.OracleClient.Oci/OciServerHandle.cs:
	* System.Data.OracleClient.Oci/OciServiceHandle.cs:
	* System.Data.OracleClient.Oci/OciSessionHandle.cs:
	* System.Data.OracleClient.Oci/OciStatementHandle.cs:
	* System.Data.OracleClient.Oci/OciTransactionHandle.cs:
		All handles now derive from OciHandle, and these classes
		have been rewritten as such.  Also attempted to implement
		the Dispose () methods for these classes.
	* System.Data.OracleClient.Oci/OciHandleType.cs:
		Add descriptor types into here because handles and
		descriptors are used in many of the same OCI functions.

svn path=/trunk/mcs/; revision=12176
2003-03-04 13:50:35 +00:00
Tim Coleman 7aa6feb8b4 2003-02-18 Tim Coleman <[email protected]>
* System.Data.OracleClient/OciBindHandle.cs:
        * list:
                Add new class
        * System.Data.OracleClient/OracleCommand.cs:
                Add transaction logic for rollback/commit,
                attaching to oracle service context, and a
                couple of test cases.
                Add Parameter handling
        * System.Data.OracleClient/OracleDataReader.cs:
                Change GetValue call
        * System.Data.OracleClient/OracleParameter.cs:
                Make this work
        * System.Data.OracleClient/OracleType.cs:
                Add values to enum
        * System.Data.OracleClient.Oci/OciDefineHandle.cs:
                Add GetValue call which is used by data reader
        * System.Data.OracleClient.Oci/OciStatementHandle.cs:
                Add parameter logic
        * Test/TestOracleClient.cs:
                Add some new test cases.

svn path=/trunk/mcs/; revision=11709
2003-02-19 02:46:22 +00:00
Daniel Morgan 1d31585645 2003-02-16 Daniel Morgan <[email protected]>
* System.Data.OracleClient.Oci/OciStatementHandle.cs
	* System.Data.OracleClient.Oci/OciColumnInfo.cs
	* System.Data.OracleClient/OciGlue.cs
	* System.Data.OracleClient/OracleDataReader.cs: fixes
	  to display character data in SQL# command-line
	  and GTK# versions

	* Test/TestOracleClient.cs: updated test to
	  include reading data via the OracleDataReader

	* System.Data.OracleClient/OracleConnection.cs: removed
	  debug code

svn path=/trunk/mcs/; revision=11614
2003-02-16 10:36:49 +00:00
Tim Coleman 1256a14783 2003-12-13 Tim Coleman <[email protected]>
* System.Data.OracleClient.Oci/OciColumnInfo.cs:
	* System.Data.OracleClient.Oci/OciDataType.cs:
	* System.Data.OracleClient.Oci/OciDefineHandle.cs:
	* list:
		New classes added
	* System.Data.OracleClient/OciGlue.cs:
		Changes to AttrGet functions
	* System.Data.OracleClient/OracleCommand.cs:
	* System.Data.OracleClient/OracleDataReader.cs:
		Start some work on getting data reader going
	* System.Data.OracleClient.Oci/OciAttributeType.cs:
		Add DisplayName
	* System.Data.OracleClient.Oci/OciStatementHandle.cs:
		Add code to get schema for query, as well as
		define output values.

svn path=/trunk/mcs/; revision=11571
2003-02-14 04:32:30 +00:00
Tim Coleman c559a7bf4d 2003-02-12 Tim Coleman <[email protected]>
* System.Data.OracleClient/OracleException.cs:
	* System.Data.OracleClient.Oci/IOciHandle.cs:
	* System.Data.OracleClient.Oci/OciEnvironmentHandle.cs:
	* System.Data.OracleClient.Oci/OciErrorHandle.cs:
	* System.Data.OracleClient.Oci/OciErrorInfo.cs:
	* System.Data.OracleClient.Oci/OciHandle.cs:
	* System.Data.OracleClient.Oci/OciServerHandle.cs:
	* System.Data.OracleClient.Oci/OciServiceHandle.cs:
	* System.Data.OracleClient.Oci/OciSessionHandle.cs:
	* System.Data.OracleClient.Oci/OciStatementHandle.cs:
	* System.Data.OracleClient.Oci/OciTransactionHandle.cs:
	* list:
		New classes added.  This encapsulates the OCI
		functionality into Handle objects.
	* System.Data.OracleClient/OciGlue.cs:
		Move a lot of code into Handle classes.
	* System.Data.OracleClient/OracleCommand.cs:
	* System.Data.OracleClient/OracleConnection.cs:
	* System.Data.OracleClient/OracleTransaction.cs:
		Retrofit for changes in OciGlue.

svn path=/trunk/mcs/; revision=11538
2003-02-13 00:50:39 +00:00