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
