尝试创建数据库架构 - 没有可用的数据库提供程序，无法创建连接

Question

我从 Northwind spring.net/NHibernate 示例开始。我正在尝试使用现有示例来生成架构。我将 CustomerEditController web.xml 条目更改为

<object name="CustomerEditController" type="NHibernateCustomerEditController" scope="session">
  <constructor-arg name="sessionFactory" ref="NHibernateSessionFactory"/>
  <constructor-arg name="local" ref="&amp;NHibernateSessionFactory"/>
</object>`

将 NHibernateCustomerEditController 更改为以下内容：

public class NHibernateCustomerEditController : ICustomerEditController
{
    private readonly ISessionFactory sessionFactory;
    private readonly LocalSessionFactoryObject LocalsessionFactory;
    private Customer currentCustomer;

    public NHibernateCustomerEditController(ISessionFactory sessionFactory, LocalSessionFactoryObject local)
    {
        this.sessionFactory = sessionFactory;
        this.LocalsessionFactory = local;
    }

    private ISession Session
    {
        get { return sessionFactory.GetCurrentSession(); }
    }

    public void EditCustomer(Customer customer)
    {
        currentCustomer = customer;
    }

    public void Clear()
    {
        currentCustomer = null;
    }

    public Customer CurrentCustomer
    {
        get
        {
            Customer customer = currentCustomer;

            //since the Customer entity may have been retrieved from a prior request, we need to reattach it to the current session
            // in order to support lazy-loading, etc. on the Customer
            Session.Lock(customer, LockMode.None);

            return customer;
        }
    }
    public void MakeANewDatabase() {
        SchemaExport schema = new SchemaExport(LocalsessionFactory.Configuration);
        schema.Create(true, true);
    }

}

我向客户列表页面添加了一个按钮，该按钮通向 MakeANewDatabase 方法。

当我点击按钮时，我收到错误没有可用的数据库提供程序，无法创建连接。看起来，当创建 SchemaExport 时，DBProvider 为 null。

完整错误文本：

An exception of type 'System.Exception' occurred in Spring.Data.NHibernate30.DLL but was not handled in user code

Additional information: There was no DB provider available, unable to create connection

An exception of type 'NHibernate.HibernateException' occurred in NHibernate.DLL but was not handled in user code

Additional information: There was no DB provider available, unable to create connection

Answer 1

看起来从本地会话工厂拉取的配置未完全填充，通过使用 spring 方法解决了该问题。

public void MakeANewDatabase()
{ 
  LocalsessionFactory.CreateDatabaseSchema(); 
}