I upgraded to the latest release of the data mapper and most of my problems went away. Let me know if you have any questions.
-Ira. -----Original Message----- From: Mariano [mailto:[EMAIL PROTECTED] Sent: Thursday, December 15, 2005 7:48 AM To: [email protected]; 'Ron Grabowski' Subject: RE: iBatis and Visual Studio 2005 Woes Hi Im not sure , but I had the next problems: properties.config <provider name="oracle9.2" enabled="true" //Activated 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="System.Data.Client.OracleDbType" parameterDbTypeProperty="OracleDbType" dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter" commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder" usePositionalParameters = "false" useParameterPrefixInSql = "true" useParameterPrefixInParameter = "false" parameterPrefix=":" /> My file of sqlmap.config <?xml version="1.0" encoding="UTF-8" ?> <sqlMapConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd"> <properties resource="C:\properties.config"/> <providers resource="C:\providers.config"/> <database> <provider name="oracle9.2"/> <dataSource name="Arquitectura" connectionString="${connectionString}"/> </database> <sqlMaps> <sqlMap resource="C:\CONFIGURACION.xml"/> </sqlMaps> </sqlMapConfig> <!--CONFIGURACION.xml-----> <?xml version="1.0" encoding="utf-8" ?> <sqlMap namespace="Configuracion" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMap.xsd"> <alias> <typeAlias alias="configuracion" type="Ma.Informacion.Configuracion, Ma.Informacion" /> </alias> <!-- XML "behind" document for the People service class. --> <statements> <!-- PROCEDMIENTO SELECT --> <select id="CONFIGURACION" resultClass="configuracion"> SELECT * from configuracion </select> </statements> </sqlMap> Tnks --- "Hoffman, Ira" <[EMAIL PROTECTED]> escribió: > That made Visual Studio 2005 feel better, but I am > still getting a fairly > lengthy error: > > IBatisNet.Common.Exceptions.ConfigurationException: > - The error occurred while Validate SqlMap config. > - The error occurred in The > 'http://ibatis.apache.org/dataMapper:sqlMapConfig' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:properties' > element is not > declared. > Could not find schema information for the attribute > 'file'. > The 'http://ibatis.apache.org/dataMapper:settings' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:setting' > element is not declared. > Could not find schema information for the attribute > 'useFullyQualifiedStatementNames'. > The 'http://ibatis.apache.org/dataMapper:setting' > element is not declared. > Could not find schema information for the attribute > 'cacheModelsEnabled'. > The 'http://ibatis.apache.org/dataMapper:database' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:provider' > element is not declared. > Could not find schema information for the attribute > 'name'. > The 'http://ibatis.apache.org/dataMapper:dataSource' > element is not > declared. > Could not find schema information for the attribute > 'name'. > Could not find schema information for the attribute > 'connectionString'. > The 'http://ibatis.apache.org/dataMapper:sqlMaps' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:sqlMap' > element is not declared. > Could not find schema information for the attribute > 'file'. > . ---> > IBatisNet.Common.Exceptions.ConfigurationException: > Invalid > SqlMap.config document. cause :The > 'http://ibatis.apache.org/dataMapper:sqlMapConfig' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:properties' > element is not > declared. > Could not find schema information for the attribute > 'file'. > The 'http://ibatis.apache.org/dataMapper:settings' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:setting' > element is not declared. > Could not find schema information for the attribute > 'useFullyQualifiedStatementNames'. > The 'http://ibatis.apache.org/dataMapper:setting' > element is not declared. > Could not find schema information for the attribute > 'cacheModelsEnabled'. > The 'http://ibatis.apache.org/dataMapper:database' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:provider' > element is not declared. > Could not find schema information for the attribute > 'name'. > The 'http://ibatis.apache.org/dataMapper:dataSource' > element is not > declared. > Could not find schema information for the attribute > 'name'. > Could not find schema information for the attribute > 'connectionString'. > The 'http://ibatis.apache.org/dataMapper:sqlMaps' > element is not declared. > The 'http://ibatis.apache.org/dataMapper:sqlMap' > element is not declared. > Could not find schema information for the attribute > 'file'. > > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ValidateSchema(XmlNode > section, String schemaFileName) > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument > document, DataSource dataSource, Boolean > useConfigFileWatcher, Boolean > isCallFromDao) > --- End of inner exception stack trace --- > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument > document, DataSource dataSource, Boolean > useConfigFileWatcher, Boolean > isCallFromDao) > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(String > resource, ConfigureHandler configureDelegate) > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(Config > ureHandler configureDelegate) > at MerckSAS.Library.Services.Mapper.InitMapper() > in > c:\Inetpub\wwwroot\MerckSAS\App_Code\Mapper.cs:line > 25 > at MerckSAS.Library.Services.Mapper.Instance() in > c:\Inetpub\wwwroot\MerckSAS\App_Code\Mapper.cs:line > 36 > at MerckSAS.Library.Services.Mapper.Get() in > c:\Inetpub\wwwroot\MerckSAS\App_Code\Mapper.cs:line > 45 > at MerckSasService..ctor() in > c:\Inetpub\wwwroot\MerckSAS\App_Code\MerckSasService.cs:line > 23 > > I went to the URL for the dataMapper and the > document was not found. Could > this be a problem? > > Thanks, > Ira > > > -----Original Message----- > From: Ron Grabowski [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 14, 2005 11:39 AM > To: [email protected] > Subject: Re: iBatis and Visual Studio 2005 Woes > > > The top of your SqlMap.config file should look > something like this: > > <?xml version="1.0" encoding="UTF-8" ?> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > > > The top of your sqlMap files should look like this: > > <?xml version="1.0" encoding="UTF-8" ?> > <sqlMap namespace="Customer" > xmlns="http://ibatis.apache.org/mapping"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > > ----- Original Message ---- > From: "Hoffman, Ira" <[EMAIL PROTECTED]> > To: "[email protected]" > <[email protected]> > Sent: Wednesday, December 14, 2005 6:25:25 AM > Subject: iBatis and Visual Studio 2005 Woes > > All, > > I am trying to develop a .NET 2.0 middle-tier that > leverages iBatis. I have > used iBatis before, in the Java world, and greatly > enjoyed it. However, I am > having problems getting the most basic configuration > working with Visual > Studio 2005 and iBatis. I have created a new ASP > .NET Web Service Project > and am unable to read the sqlMap.config properties > file. Here is the error > message: > > IBatisNet.Common.Exceptions.ConfigurationException: > - The error occurred while Validate SqlMap config. > - The error occurred in The 'file' attribute is not > declared. > The 'useFullyQualifiedStatementNames' attribute is > not declared. > The 'file' attribute is not declared. > . ---> > IBatisNet.Common.Exceptions.ConfigurationException: > Invalid > SqlMap.config document. cause :The 'file' attribute > is not declared. > The 'useFullyQualifiedStatementNames' attribute is > not declared. > The 'file' attribute is not declared. > > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ValidateSchema(XmlNode > section, String schemaFileName) > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument > document, DataSource dataSource, Boolean > useConfigFileWatcher, Boolean > isCallFromDao) > --- End of inner exception stack trace --- > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument > document, DataSource dataSource, Boolean > useConfigFileWatcher, Boolean > isCallFromDao) > at > IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(String > === message truncated === ______________________________________________ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------------
