How do I write the configuration of Hibernate to connect to the H2 database?

There is no database driver for h2.

Are there several? Isn't it JDBC?,It's just that Hibernate has encapsulated it with you.,If you want to do it better.,It's a connection pool.,But I think it should also support ODBC data sources! Hibernate doesn't need you to write the connection ** yourself, you just need to configure it.

Leave your database connection to Spring and let him build two SessionFactories togetherSimilarly, if you want to connect two pieces of data, you need to create two sessionfactories

You then create a new spirng configuration file, reference the two spring files, and then let the spring configuration file be loaded.

New Profile Reference:

What does it mean to write a database, do you want to do read/write splitting, in general, if you use hibernate, there must be a figure of spring, which can be achieved by inheriting the abstractroutingdatasource class in spring. Take a look at this link, the configuration of the database and the switching of data sources are available.

Hibernate's data source configuration is also available downstairs**.

Create a new file to: properties as the suffix file, you can read the database connection parameters from the file! Easier to change.

These can be found in the files under hibernate.

The sqlserver database connection is placed in the configuration file, just for the scenario of external programs accessing sqlserver, several different connection methods (odbc, ef, nhibernate, mybitas, etc.), the connection string is also different, you search on the Internet, the sqlserver connection string format is known, the configuration file is divided into 2 types, one is the config file that comes with the project, This kind of file is read and write access. .net has its own method support, and the description of the file format and corresponding nodes is also very detailed; Create a configuration file by yourself (it can be txt, xml, etc., the format can be controlled by yourself, but you need to write the corresponding read and write methods by yourself);

The above 2 ways, each has its own advantages and disadvantages, the first one, use the system's own configuration file, easy to operate, but this file has a place to note, that is, it is generally to load file information when the system starts, in the process of program running, the value of the configuration file is modified, and the software needs to be restarted next time to take effect.

However, in the process of running the program, the probability of change is small, and the self-contained config file can meet the needs.

You don't need to set the database dialect, it's not necessary. I only need it when I want to hibernate.