[Mono-dev] Oracle and Mono

[Daniel Morgan]

Build Mono from Subversion
http://mono-project.com/Compiling_Mono#Building_Mono_from_the_Subversion_Repository

Oracle Documentation
http://tahiti.oracle.com/

Oracle Call Interface Programmer's Guide 
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/toc.htm

Read chapter 2 to get a basic understanding of how to use OCI.

Build and Run the Tests for Oracle client
mcs/class/System.Data.OracleClient/Test

See the README and config files there.
You will need to edit the config files for you connection string

To build the tests in mcs/class/System.Data.OracleClient, run:
$ make test

To run the tests:
$ make run-test

BitConverter is a class usefull for conversion of integers from little-endian to big-endian.  However, it has its problems.  Mono provides a much improved class called Mono.DataConvert.

http://www.mono-project.com/Mono_DataConvert

OCI uses handles to do almost anything: environment, server, session, error, statement, binding, etc.  In our implementation of System.Data.OracleClient, we wrap these handles.  Such as, the environment handle is wrapped via OciEnvironmentHandle.  All these specific OCI wrapper classes are internal and exist in the namespace System.Data.OracleClient.oci.  The calls to OCI native library are in a static class called OciCalls.  These calls call methods in a private class called OciNativeCalls.  This is done so any call to OCI can be traced.  The classes in System.Data.OracleClient are the classes that implement the .net compatible API and wrap the classes in System.Data.OracleClient.oci.




--- On Tue, 10/21/08, Thracx <SpamMonkey01+Mono at gmail.com> wrote:

> From: Thracx <SpamMonkey01+Mono at gmail.com>
> Subject: Re: [Mono-dev] Oracle and Mono
> To: mono-devel-list at lists.ximian.com
> Date: Tuesday, October 21, 2008, 3:24 PM
> Hello All,
> 
> I'm interested in helping to get Oracle working on a
> Solaris 10 Sparc
> machines.  Has any work been started recently that I can
> help with, or is
> there someone familiar with this section of the code which
> could help me get
> started?
> 
> Thanks,
> -Thracx
> 
> 
> PABLOSANTOSLUAC at terra.es wrote:
> > 
> > Hi Daniel,
> > 
> > 
> > I can give hacker access to a Solaris 10 SPARC box.
> Putting the latest 
> > mono there is what I'm really trying to do these
> days.
> > 
> > About 4: it's not normally an option, talk to
> Miguel.
> > 
> > 
> > pablo
> > 
> > Daniel Morgan escribió:
> >> When I say "supported", it means it has
> not been tested nor developed for
> >> the platform.  Thus, it probably does not work on
> these platforms.
> >>
> >> However, if you need access to Oracle via Mono on
> these platforms, there
> >> are some things you can do to get it
> "supported".
> >>
> >> 1. contribute patches which fixes any bugs to
> allow it to work on those
> >> platofrms
> >>
> >> -- or --
> >>
> >> 2. provide some hacker remote access to a sparc
> machine with a recent
> >> version of mono/mcs working on the machine, and
> access to an oracle
> >> database. ssh?
> >>
> >> -- or --
> >>
> >> 3. donate or lend a developer a sparc machine with
> a recent mono which
> >> runs a recent version of mono
> >>
> >> -- or --
> >>
> >> 4. Your best bet - pay Novell for the support. 
> There is some wiki page
> >> where you can get paid support to add a feature of
> fix a bug for mono.
> >>
> >> http://www.mono-project.com/Kickstart
> >>
> >> Note, I do not work for Novell nor am I getting
> anything for this message
> >> - just a public message.
> >>
> >> Most people running oracle is on linux/x86,
> windows, or hp these days.
> >>
> >> --- On Wed, 10/8/08, pablosantosluac at terra.es
> <pablosantosluac at terra.es>
> >> wrote:
> >>
> >>   
> >>> From: pablosantosluac at terra.es
> <pablosantosluac at terra.es>
> >>> Subject: [Mono-dev] Oracle and Mono
> >>> To:
> "mono-devel-list at lists.ximian.com"
> >>> <mono-devel-list at lists.ximian.com>
> >>> Date: Wednesday, October 8, 2008, 11:33 AM
> >>> Hi there,
> >>>
> >>> I've read that Oracle is not supported on
> SPARC nor PPC
> >>> here 
> >>> http://www.mono-project.com/Oracle. Is that
> correct?
> >>>
> >>>
> >>> Thanks
> >>>
> >>>
> >>> pablo
> >>>
> _______________________________________________
> >>> Mono-devel-list mailing list
> >>> Mono-devel-list at lists.ximian.com
> >>>
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
> >>>     
> >>
> >>
> >>       
> >>
> >>   
> > _______________________________________________
> > Mono-devel-list mailing list
> > Mono-devel-list at lists.ximian.com
> >
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
> > 
> > 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Oracle-and-Mono-tp19881320p20097391.html
> Sent from the Mono - Dev mailing list archive at
> Nabble.com.
> 
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list