Change your provider to "oracleClient1.0" if your using the System.Data.OracleClient.
Best regards, Mark Gillen Assurant Corporate Technology (ACT) Business & Enterprise Application Services Miami -T-2, Technology Bldg. (305) 253-2244 Ext. 32013 mark.gil...@assurant.com Ranjith Venkatesh <rvenkat...@sapient.com> 02/05/2009 10:56 AM Please respond to user-cs@ibatis.apache.org To "user-cs@ibatis.apache.org" <user-cs@ibatis.apache.org> cc Subject RE: Error occurred while loading providers - Oracle Provider Thanks for keeping the hints flowing. 1. Keeping the providers.config in Debug folder does not help. 2. Renaming the provider to oracle10.1 does nót change much either. 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: rvenkat...@sapient.com 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: mark.gil...@assurant.com [mailto:mark.gil...@assurant.com] Sent: Thursday, February 05, 2009 4:48 PM To: user-cs@ibatis.apache.org Subject: RE: Error occurred while loading providers - Oracle Provider Ranjith, I'm looking at the providers.config file that comes with 1.6.1 and I don't see a provider named "Oracle" I see oracle9.2, oracle10.1, and oracleClient1.0 Best regards, Mark Gillen Assurant Corporate Technology (ACT) Business & Enterprise Application Services Miami -T-2, Technology Bldg. (305) 253-2244 Ext. 32013 mark.gil...@assurant.com Ranjith Venkatesh <rvenkat...@sapient.com> 02/05/2009 10:35 AM Please respond to user-cs@ibatis.apache.org To "user-cs@ibatis.apache.org" <user-cs@ibatis.apache.org> cc Subject RE: Error occurred while loading providers - Oracle Provider This is the entry i have: <database> <provider name="Oracle" /> <dataSource name="dbname" connectionString="Data Source=dbname;Persist Security Info=True;User ID=user;Password=password;Unicode=True" /> </database> 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: rvenkat...@sapient.com 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: mark.gil...@assurant.com [mailto:mark.gil...@assurant.com] Sent: Thursday, February 05, 2009 4:32 PM To: user-cs@ibatis.apache.org Subject: RE: Error occurred while loading providers - Oracle Provider 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 mark.gil...@assurant.com Ranjith Venkatesh <rvenkat...@sapient.com> 02/05/2009 10:13 AM Please respond to user-cs@ibatis.apache.org To "user-cs@ibatis.apache.org" <user-cs@ibatis.apache.org> 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: rvenkat...@sapient.com 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: mark.gil...@assurant.com [mailto:mark.gil...@assurant.com] Sent: Thursday, February 05, 2009 3:57 PM To: user-cs@ibatis.apache.org 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 mark.gil...@assurant.com Ranjith Venkatesh <rvenkat...@sapient.com> 02/05/2009 09:43 AM Please respond to user-cs@ibatis.apache.org To "user-cs@ibatis.apache.org" <user-cs@ibatis.apache.org> 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: rvenkat...@sapient.com 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. 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. **************************************************************************************
