Aquí va!!
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="nhibernate"
type="System.Configuration.NameValueSectionHandler, System,
Version=1.0.3300.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<section name="log4net"
type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2000Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.SqlClientDriver"
/>
<add
key="hibernate.connection.connection_string"
value="Server=192.168.0.194;initial catalog=David;User
ID=sa;Password=setbox;"
/>
</nhibernate>
<log4net debug="false">
<!-- Define some output appenders -->
<appender name="trace" type="log4net.Appender.TraceAppender,
log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c
- %m%n" />
</layout>
</appender>
<appender name="console"
type="log4net.Appender.ConsoleAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c
- %m%n" />
</layout>
</appender>
<appender name="rollingFile"
type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="log.txt" />
<param name="AppendToFile" value="true" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyy.MM.dd" />
<param name="StaticLogFileName" value="true" />
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c
- %m%n" />
</layout>
</appender>
<!-- Setup the root category, add the appenders and set the
default priority -->
<root>
<priority value="DEBUG" />
<appender-ref ref="rollingFile" />
</root>
</log4net>
</configuration>
Se me olvidó decir que probé en vez de
NHibernate.Dialect.MsSql2000Dialect con esté
NHibernate.Dialect.MsSql2005Dialect pero me saltá el siguiente error:
Se generó la excepción NHibernate.MappingException en el programa:
could not instantiate dialect class
2008-06-16 16:31:42,354 [7644] INFO NHibernate.Cfg.Configuration -
searching for mapped documents in assembly: nhiber_win_post
2008-06-16 16:31:42,372 [7644] INFO NHibernate.Cfg.Configuration -
Found mapping documents in assembly:
nhiber_win_post.Tabla1_postgres.hbm.xml
2008-06-16 16:31:42,435 [7644] ERROR NHibernate.Cfg.Configuration -
Could not configure datastore from input stream
Exception: NHibernate.HibernateException
Message: could not instantiate dialect class
Source: NHibernate
at NHibernate.Dialect.Dialect.GetDialect(IDictionary props)
at NHibernate.Cfg.Configuration.Add(XmlDocument doc)
at NHibernate.Cfg.Configuration.AddInputStream(Stream
xmlInputStream)
Nested Exception
Exception: System.TypeLoadException
Message: Could not load type 'NHibernate.Dialect.MsSql2005Dialect'
from assembly 'NHibernate, Version=0.8.4.0, Culture=neutral,
PublicKeyToken=154fdcb44c4484fc'.
Source: mscorlib
at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly,
StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly,
StackCrawlMark& stackMark)
at System.RuntimeType.PrivateGetType(String typeName, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly,
StackCrawlMark& stackMark)
at System.Type.GetType(String typeName, Boolean throwOnError)
at NHibernate.Dialect.Dialect.GetDialect(IDictionary props)
Puede todo radicar de esto? Que no tenga el dialecto de MsSql2005 en
mi versión de NHibernate?
Se me acaba de ocurrir...
On 16 jun, 16:28, "Gustavo Ringel" <[EMAIL PROTECTED]> wrote:
> manda la configuracion de nhibernate por favor (hibernate.cfg.xml o el
> equvialente en el app.config).
>
> Gustavo.
>
> 2008/6/16 Picatoste <[EMAIL PROTECTED]>:
>
>
>
>
>
> > Buenas!
> > Hace mucho que no hago nada de NH, pero quiero hacer un par de
> > cosillas y lo he retomado.
> > He montado un SQL Server 2005 en un VMWARE con Windows Server 2003.
> > El problema que tengo es cuando NH realizá la conexión con la BBDD.
> > Me saltá error en la siguiente linea:
>
> > transaction = session.BeginTransaction();
>
> > He utilizado el log4net para auditar instrucción a instrucción. Pero
> > cual es mi sorpresa cuando a veces me dice que es problema es que el
> > servidor no acepta conexiones remotas, cuando lo he configurado para
> > que si lo haga, y con una aplicación que tengo en local (Aqua) puedo
> > conectarme perfectamente a la BBDD del vmware. Y otras veces dice que
> > el pool de conexiones esta lleno, por que dejo abiertos muchas
> > conexiones, cuando solo abro una y como saltá el error cuando empieza
> > la transacción no puedo cerrarla.
>
> > Os dejo el log de los dos errores:
>
> > ...
> > 2008-06-16 16:05:39,791 [7412] DEBUG
> > NHibernate.Impl.SessionFactoryImpl - Instantiated session factory
> > 2008-06-16 16:05:39,808 [7412] DEBUG NHibernate.Impl.SessionImpl -
> > opened session
> > 2008-06-16 16:05:39,809 [7412] DEBUG
> > NHibernate.Transaction.AdoTransaction - begin
> > 2008-06-16 16:05:39,810 [7412] DEBUG
> > NHibernate.Connection.DriverConnectionProvider - Obtaining
> > IDbConnection from Driver
> > 2008-06-16 16:05:54,903 [7412] ERROR NHibernate.ADOException - Could
> > not create connection from Driver
> > Exception: System.InvalidOperationException
> > Message: Timeout expired. The timeout period elapsed prior to
> > obtaining a connection from the pool. This may have occurred because
> > all pooled connections were in use and max pool size was reached.
> > Source: System.Data
> > at
> > System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
> > owningConnection)
> > at
> > System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> > outerConnection, DbConnectionFactory connectionFactory)
> > at System.Data.SqlClient.SqlConnection.Open()
> > at NHibernate.Connection.DriverConnectionProvider.GetConnection()
>
> > y el otro:
>
> > 2008-06-16 16:07:31,160 [6824] INFO
> > NHibernate.Impl.SessionFactoryObjectFactory - no name configured
> > 2008-06-16 16:07:31,160 [6824] DEBUG
> > NHibernate.Impl.SessionFactoryImpl - Instantiated session factory
> > 2008-06-16 16:07:31,175 [6824] DEBUG NHibernate.Impl.SessionImpl -
> > opened session
> > 2008-06-16 16:07:31,177 [6824] DEBUG
> > NHibernate.Transaction.AdoTransaction - begin
> > 2008-06-16 16:07:31,177 [6824] DEBUG
> > NHibernate.Connection.DriverConnectionProvider - Obtaining
> > IDbConnection from Driver
> > 2008-06-16 16:07:45,976 [6824] ERROR NHibernate.ADOException - Could
> > not create connection from Driver
> > Exception: System.Data.SqlClient.SqlException
> > Message: An error has occurred while establishing a connection to the
> > server. When connecting to SQL Server 2005, this failure may be
> > caused by the fact that under the default settings SQL Server does not
> > allow remote connections. (provider: Named Pipes Provider, error: 40 -
> > Could not open a connection to SQL Server)
> > Source: .Net SqlClient Data Provider
> > at
> > System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
> > owningObject)
> > at
> > System.Data.ProviderBase.DbConnectionPool.PoolCreateRequest(Object
> > state)
> > at
> > System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
> > owningConnection)
> > at
> > System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> > outerConnection, DbConnectionFactory connectionFactory)
> > at System.Data.SqlClient.SqlConnection.Open()
> > at NHibernate.Connection.DriverConnectionProvider.GetConnection()
>
> > Si sirve de algo saltá mas a menudo el de conexiones remotas...
> > Seguramente ambas tienen algun tipo de relación que no consigo
> > entender.
> > Cualquier ayuda será agradecida.
> > Saluditos!- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -
--~--~---------~--~----~------------~-------~--~----~
Para escribir al Grupo, hágalo a esta dirección:
[email protected]
Para más, visite: http://groups.google.com/group/NHibernate-Hispano
-~----------~----~----~----~------~----~------~--~---
