[Mono-dev] Running System.Data.OracleClient test suite

[Konstantin Triger]

That's true. The reason is that I assumed the test suite will work with any recent Oracle database, so the installation instructions
1. May differ from version to version.
2. Should be provided by the vendor with the distribution documentation.

Regards,
Konstantin Triger

> -----Original Message-----
> From: Leszek Ciesielski [mailto:skolima at gmail.com]
> Sent: Tuesday, November 13, 2007 1:43 PM
> To: Konstantin Triger; mono-devel-list
> Subject: Re: [Mono-dev] Running System.Data.OracleClient test suite
> 
> But the readme, while useful, contains only information how to
> populate a working database.
> 
> On Nov 13, 2007 12:06 PM, Konstantin Triger <kostat at mainsoft.com> wrote:
> > Hi Leszek,
> >
> > When I submitted the test suite to mono, I put all the Oracle
> configuration info into
> .../System.Data.OracleClient/Test/System.Data.OracleClient.jvm/readme.txt.
> >
> > Regards,
> > Konstantin Triger
> >
> > > -----Original Message-----
> > > From: mono-devel-list-bounces at lists.ximian.com [mailto:mono-devel-
> list-
> > > bounces at lists.ximian.com] On Behalf Of Leszek Ciesielski
> > > Sent: Monday, November 12, 2007 1:51 PM
> > > To: mono-devel-list
> > > Subject: [Mono-dev] Running System.Data.OracleClient test suite
> > >
> >
> > > Hi,
> > >
> > > running the tests should be something trivial to do and instead
> > > yesterday I spent 2 hours trying to figure out how I got them to run
> > > before... So here's a short instruction.
> > >
> > > Obtaining needed OCI binaries: The machine that will run the tests
> > > needs 'oracle-instantclient-basic" and 'oracle-instantclient-sqlplus'
> > > packages installed - they should be available though your
> > > distributions package manager. Please note that you'll need to create
> > > an Oracle account for downloading anything from oracle.com.
> > >
> > > Obtain and compile mono svn tree
> > > (http://www.mono-
> > >
> project.com/Compiling_Mono#Building_Mono_from_the_Subversion_Repository).
> > > Navigate to mcs/class/System.Data.OracleClient and run 'make run-test'
> > > (for net_1_1 profile) or 'make run-test PROFILE=net_2_0' . Most tests
> > > will be ignored, as there's no database connection configured.
> > >
> > > Setting up Oracle server: Fastest way to get Oracle up & running is to
> > > use free Oracle Express Edition
> > >
> (http://www.oracle.com/technology/software/products/database/xe/htdocs/102
> > > xewinsoft.html),
> > > Universal version. I prefer to use a virtual Windows machine for this,
> > > installation on Linux is quite cumbersome. Remember to turn off the
> > > firewall or at least open port 1521 for incoming connections.
> > >
> > > Create a 'tnsnames.ora' file. It should be located in
> > > '/usr/lib/oracle/10.2.0.3/client/network/admin/tnsnames.ora' - the
> > > '10.2.0.3' part is the instantclient version you have installed.
> > > You'll have to move this file if you ever change the instantclient
> > > version. An example file is attached to this mail, it should be enough
> > > to edit the IP address after "HOST =" .
> > >
> > > Creating user and databases: Use the web frontend on the server
> > > machine to create user 'GHTDB' with password 'GHTDB' and roles
> > > CONNECT, RESOURCE and DBA (yes, this means full access). On the test
> > > machine, navigate to
> > > mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm
> > > and issue the following commands to populate the database:
> > > 'sqlplus "GHTDB/GHTDB at VMWARE" @GHTDB.ORACLE.sql' and 'sqlplus
> > > "GHTDB/GHTDB at VMWARE" @GHTDB.Data.ORACLE.sql' (where VMWARE is the
> > > identifier of the database in the tnsnames.ora file).
> > >
> > > Configuring connection string for the tests: In
> > > mcs/class/System.Data.OracleClient directory , copy
> > > 'System.Data.OracleClient_test_default.dll.config.example' to
> > > 'System.Data.OracleClient_test_default.dll.config' and
> > > System.Data.OracleClient_test_net_2_0.dll.config', then edit the
> > > connection string values to read "Data Source=VMWARE;User
> > > ID=GHTDB;Password=GHTDB;".
> > >
> > > Finally, run the test suite.
> > >
> > > Currently there are about 35 tests that fail AND there are also tests
> > > marked as NotWorking on targets other than JVM. Ideally they should
> > > all pass (the NotWorking attribute was used for tests that hang
> > > instead of simply failing).
> > >
> > > Questions? Comments?
> > >
> > > --
> > > MS-DOS user since 5.0
> > > Windows user since 3.11
> > > Linux user since kernel 2.4
> > > Novell Netware user since 2.2
> > > WARCRAFT user since 1.0
> >
> 
> 
> 
> --
> MS-DOS user since 5.0
> Windows user since 3.11
> Linux user since kernel 2.4
> Novell Netware user since 2.2
> WARCRAFT user since 1.0