RE: Oracle 9.2 Problems

Have you tried the Microsoft supplied client, System.Data.OracleClient? It worked well for me.

If there not a reason not to use it (e.g. some incompatibility), you should give it a try. Here's some info that might be useful: http://msdn.microsoft.com/library/default.asp?url="">.

From: Joe Chandler [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 3:32 PM
To: ibatis-user-cs@incubator.apache.org
Subject: Oracle 9.2 Problems

I am trying to use Oracle 9.2 as the provider in .NET c# and it seems that the simple SQL Maps

Work just fine. When I try to pass a parameter the value does not get substituted. For example,

<select id="MoveRequestSummaries"

resultMap="MoveRequestSummaryResult"

parameterClass="MoveRequest">

SELECT

ID,

STATUS,

REQUESTER_EMPLOYEE_ID,

CREATED_BY,

CREATED,

MOVE_DATE

FROM

MM_OWNER_V8.RQST_MOVE

WHERE

STATUS = #Status#

</select>

Always returns 0 rows or an empty result.

When I switch to the MS Oracle provider and run the same Query

Without changing code it returns the expected result.

Here is my provider for oracle:

<provider

name="oracle9.2"

enabled="true"

assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342"

connectionClass="Oracle.DataAccess.Client.OracleConnection"

commandClass="Oracle.DataAccess.Client.OracleCommand"

parameterClass="Oracle.DataAccess.Client.OracleParameter"

parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"

parameterDbTypeProperty="Oracle.DataAccess.Client.OracleDbType"

dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"

commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"

usePositionalParameters = "false"

useParameterPrefixInSql = "true"

useParameterPrefixInParameter = "false"

parameterPrefix=":"

Does anyone have any suggestions?

Thanks in advance,

Joe

Reply via email to