Connect To Oracle From BizUnit

Feb 22, 2008 at 2:50 PM
Hi,



I m using BizUnit framework for testing a BizTalk flow.

The Biztalk flow retrieves a data from a SQL server and does some business operations and finally inserts data in oracle table.

I m preparing a unit test based on C# test project and BizUnit framework.

I m not having a problem to connect to SQL SERVER But a big with Oracle !!!!!!



Is it possible to be connected to oracle instance from BizUnit? I m having some problems when using the following:



<TestStep assemblyPath="" typeName="Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBExecuteNonQueryStep">

<DelayBeforeExecution>1</DelayBeforeExecution>

<ConnectionString>Driver={Microsoft ODBC for Oracle};Server=MyServer;Data Source=MySource;User id=MyUser;Password=MyPass</ConnectionString>

<SQLQuery>

<RawSQLQuery>

select * from MySchema.MyTable

</RawSQLQuery>

<SQLQueryParams>

</SQLQueryParams>

</SQLQuery>

</TestStep>



I m using a tns name.



Have any idea? Have you try to connect to oracle from BizUnit and how?



Thanks In advance?
Feb 25, 2008 at 9:15 PM
Hi Chakib,
Have you tried using the BizUnitExtensions project? that has some Oracle steps in it .
www.codeplex.com/bizunitextensions

check it out and let me know if it works for you#

benjy


Chakib wrote:
Hi,



I m using BizUnit framework for testing a BizTalk flow.

The Biztalk flow retrieves a data from a SQL server and does some business operations and finally inserts data in oracle table.

I m preparing a unit test based on C# test project and BizUnit framework.

I m not having a problem to connect to SQL SERVER But a big with Oracle !!!!!!



Is it possible to be connected to oracle instance from BizUnit? I m having some problems when using the following:



<TestStep assemblyPath="" typeName="Microsoft.Services.BizTalkApplicationFramework.BizUnit.DBExecuteNonQueryStep">

<DelayBeforeExecution>1</DelayBeforeExecution>

<ConnectionString>Driver={Microsoft ODBC for Oracle};Server=MyServer;Data Source=MySource;User id=MyUser;Password=MyPass</ConnectionString>

<SQLQuery>

<RawSQLQuery>

select * from MySchema.MyTable

</RawSQLQuery>

<SQLQueryParams>

</SQLQueryParams>

</SQLQuery>

</TestStep>



I m using a tns name.



Have any idea? Have you try to connect to oracle from BizUnit and how?



Thanks In advance?


Feb 29, 2008 at 10:32 AM
Hi Benjy,

thanks for your advise. The BizUnit oracle extension on www.codeplex.com/bizunitextensions runs correctly and presents important features: RunQuery, validate…

ChAkIb