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

[Leszek Ciesielski]

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