Shulou(Shulou.com)06/02 Report--

The main content of this article is "introduction to SpringBoot+JPA+Intersystems Cach é database". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the introduction to SpringBoot+JPA+Intersystems Cach é database.

It is also the first time to use Intersystems's Cach é database, which is said to be the leader in post-relational database (Post Relational database). This database seems to be quite famous abroad. It accounts for the largest proportion of HIS systems (health management information system) in the United States and Europe, and is recognized as the preferred database by the medical community.

Spring Data JPA is actually implemented by hibernate, so to integrate this database is actually the same as connecting to the mysql database, mainly configuring the corresponding database parameters such as url, driver, dialect (in most cases, Hibernate can correctly determine which dialect to use according to url).

You can go directly to Intersystems's official website to find an example, and you can find the Github address of the given hibernate use case: https://github.com/intersystems/quickstarts-java

View hibernate configuration

There are all the jar in lib that require a Cach é database connection, which is provided by the Intersystems vendor. Since the maven central library does not have these two jar packages, it can be installed into the private server library or the local library.

Hibernate's Dialect database dialect implementation class, AbstractSQLExceptionConversionDelegate exception implementation class, and ANSIJoinFragment implementation class are provided in the org/hibernate package.

You can put this org/hibernate package directly into the project or type it as a local jar import, but it's best to change the package name to prevent duplication with the hibernate package name.

Finally get the configuration of SprinBoot:

Spring.datasource.url=jdbc:IRIS://127.0.0.1:1972/XXXspring.datasource.username=xxxspring.datasource.password=xxxspring.datasource.driver-class-name=com.intersystems.jdbc.IRISDriverspring.jpa.show-sql=truespring.jpa.hibernate.ddl-auto=nonespring.jpa.properties.hibernate.format_sql=truespring.jpa.properties.hibernate.max_fetch_depth=1spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.InterSystemsIRISDialectspring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=false

Hibernate.dialect specifies the dialect. If the package name of the above dialect implementation class has been modified, it should be specified as the changed package name path.

If the exception Disabling contextual LOB creation as createClob () method threw error: java.lang.reflect.InvocationTargetException occurs, set hibernate.temp.use_jdbc_metadata_defaults to false, but the exact role of this property has not been delved into.

After the configuration is completed, except for the custom SQL, the rest is Spring Data JPA development.

At this point, I believe you have a deeper understanding of the "introduction to SpringBoot+JPA+Intersystems Cach é database". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.