Yep, make sure in your SQLMap.config you specified this as your driver.
in the <database> section based on what you sent in your email that
should read:
<database>
<!-- Optional ( default ) -->
<provider name="Oracle"/>
<dataSource ....."/>
</database>
Best regards,
Mark Gillen
Assurant Corporate Technology (ACT)
Business & Enterprise Application Services
Miami -T-2, Technology Bldg.
(305) 253-2244 Ext. 32013
[email protected]
Ranjith Venkatesh <[email protected]>
02/05/2009 10:13 AM
Please respond to
[email protected]
To
"[email protected]" <[email protected]>
cc
Subject
RE: Error occurred while loading providers - Oracle Provider
Not really. I just want my Oracle 10.1 to work alongwith IBATIS. Let me
try with ODP too. Any other hints?
Ranjith Venkatesh
Senior Associate Technology | Sapient
Sapient GmbH
Kellerstr. 27
81667 München
Deutschland
Tel.: + 49 89 552 987-784
Mobil: + 49 162 2773-784
Fax: + 49 89 552 987-100
E-Mail: [email protected]
Geschäftsführung: Dr. Christian Oversohl, Wolf Ingomar Faecks
Handelsregister: Amtsgericht München HRB 161057, Sitz der Gesellschaft:
München
USt.-IdNr. DE-210831918
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort die Sapient GmbH
unter +49 89 552 987-0 und löschen Sie diese E-Mail. Das unerlaubte
Kopieren sowie die unbefugte Weitergabe dieser E-Mail und der darin
enthaltenen Informationen ist nicht gestattet. Vielen Dank.
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this email in error)
please immediately notify Sapient GmbH on +49 89 552 987-0 and delete this
e-mail. Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden. Thank you for your
cooperation.
From: [email protected] [mailto:[email protected]]
Sent: Thursday, February 05, 2009 3:57 PM
To: [email protected]
Subject: Re: Error occurred while loading providers - Oracle Provider
Did you perhaps intend to enable the Oracle ODP provider instead of the
System.Data.Oracle Client?
Best regards,
Mark Gillen
Assurant Corporate Technology (ACT)
Business & Enterprise Application Services
Miami -T-2, Technology Bldg.
(305) 253-2244 Ext. 32013
[email protected]
Ranjith Venkatesh <[email protected]>
02/05/2009 09:43 AM
Please respond to
[email protected]
To
"[email protected]" <[email protected]>
cc
Subject
Error occurred while loading providers - Oracle Provider
What am I doing wrong here?
.NET Version : 2.0
Visual Studio 2005
Oracle 10.1
IBATIS - DataMapper 1.6.1
Provider Entry:
<provider name="Oracle"
description="Oracle Provider"
enabled="true"
assemblyName="System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" connectionClass="
System.Data.OracleClient.OracleConnection"
commandClass="System.Data.OracleClient.OracleCommand"
parameterClass="System.Data.OracleClient.OracleParameter"
parameterDbTypeClass="System.Data.OracleClient.OracleType"
parameterDbTypeProperty="OracleType"
dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"
commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder
"
usePositionalParameters="true"
useParameterPrefixInSql="false"
useParameterPrefixInParameter="false"
parameterPrefix=""/>
Error Message:
IBatisNet.Common.Exceptions.ConfigurationException was unhandled
Message="\r\n- The error occurred while loading Providers.\r\n-
initialize provider \r\n- Check the Oracle."
Source="IBatisNet.DataMapper"
StackTrace:
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean
isCallFromDao)
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
document, Boolean useConfigFileWatcher)
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(String
resource, ConfigureHandler configureDelegate)
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(ConfigureHandler
configureDelegate)
at IBatisNet.DataMapper.Mapper.InitMapper()
at IBatisNet.DataMapper.Mapper.Instance()
at HelloWorld.ConsoleApp.Main(String[] args) in
D:\Projects\E.ON\eonenergytrading_dw_integration\trunk\Development\POC\IbatisTest\HelloWorld\ConsoleApp.cs:line
31
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[]
args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at
Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Ranjith Venkatesh
Senior Associate Technology | Sapient
Sapient GmbH
Kellerstr. 27
81667 München
Deutschland
Tel.: + 49 89 552 987-784
Mobil: + 49 162 2773-784
Fax: + 49 89 552 987-100
E-Mail: [email protected]
Geschäftsführung: Dr. Christian Oversohl, Wolf Ingomar Faecks
Handelsregister: Amtsgericht München HRB 161057, Sitz der Gesellschaft:
München
USt.-IdNr. DE-210831918
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort die Sapient GmbH
unter +49 89 552 987-0 und löschen Sie diese E-Mail. Das unerlaubte
Kopieren sowie die unbefugte Weitergabe dieser E-Mail und der darin
enthaltenen Informationen ist nicht gestattet. Vielen Dank.
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this email in error)
please immediately notify Sapient GmbH on +49 89 552 987-0 and delete this
e-mail. Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden. Thank you for your
cooperation.
This e-mail message and all attachments transmitted with it may contain
legally privileged and/or confidential information intended solely for the
use of the addressee(s). If the reader of this message is not the intended
recipient, you are hereby notified that any reading, dissemination,
distribution, copying, forwarding or other use of this message or its
attachments is strictly prohibited. If you have received this message in
error, please notify the sender immediately and delete this message and
all copies and backups thereof.
Thank you.
**************************************************************************************
This e-mail message and all attachments transmitted with it may contain legally
privileged and/or confidential information intended solely for the use of the
addressee(s). If the reader of this message is not the intended recipient, you
are hereby notified that any reading, dissemination, distribution, copying,
forwarding or other use of this message or its attachments is strictly
prohibited. If you have received this message in error, please notify the
sender immediately and delete this message and all copies and backups thereof.
Thank you.
**************************************************************************************
