Spring Data Rest encounters a composite primary key

If the project persistence layer uses Spring Data JPA and some data tables contain composite primary keys (Union primary keys), how can the interface generated by Spring Data Rest access the data corresponding to a primary key in these data tables? Suppose the database has two data tables film with compound primary key ...

Posted on Sun, 31 May 2020 02:44:39 -0700 by volleytotal.ch

The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese code scrambling, it can be used for personal test!)

The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling) 1, Log in to MySQL to view SHOW VARIABLES LIKE 'character%'; the following character set is displayed as follows:+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+---------- ...

Posted on Sat, 30 May 2020 22:14:46 -0700 by Bob Norris

CDH6.3.2 enable Kerberos authentication

Tags (space separated): building big data platform 1: How to install and configure KDC service 2: How to enable Kerberos through CDH 3: How to log in to Kerberos and access Hadoop related services 1: How to install and configure KDC service 1.1 system environment 1. Operating system: CentOS7.5x64 2.CDH6.3.2 3. Use root user fo ...

Posted on Sat, 30 May 2020 08:55:47 -0700 by radhoo

Database experiment - Data Query Language

(1) Query the basic information of students;   select * from S;           (2) To inquire the basic information of CS students select * from S where Sdept ='CS'; (3) Inquire the student number and name of "CS" students whose age is not between 19 and 21 select Sno, Sname from S where Sdept = 'CS' and Sage not Between 19 and 21; ...

Posted on Fri, 29 May 2020 01:43:07 -0700 by hl_tan

Build hive clusters based on different versions of Hadoop (with configuration files)

Focus on Public Number: Alliance of Java Architects, Daily Technical Updates This tutorial uses two scenarios One is hive-1.21 and hadoop is hadoop 2.6.5 Another is mainly about the construction based on hadoop3.x hive   First come first 1. Local (embedded derby) step This storage requires running a mysql server locally and configuring ...

Posted on Thu, 28 May 2020 09:18:13 -0700 by adam119

Technology sharing how to write MySQL Shell plug-ins

Author: Hong bin The person in charge and technical service director of akerson South District, MySQL ACE, is good at database architecture planning, fault diagnosis, performance optimization analysis, with rich practical experience, helping customers in various industries to solve MySQL technical problems, and providing customers in finance, ...

Posted on Thu, 28 May 2020 02:07:16 -0700 by huzefahusain

How MySQL master-slave synchronization architecture is built

Catalog I. Preface 2. About MySQL Master-Slave Synchronization 3. Deployment Planning 3.1 Server Planning 3.2 Database Catalog Planning 4. Preparation Tools 5.4 Use Universal Binary Package to install MySQL on four machines (node7 as an example) 5.1 Upload MySQL Universal Binary Installation Package to Noe7/usr/local/src directory 5.2 Unz ...

Posted on Wed, 27 May 2020 21:17:41 -0700 by acac

Sensitive Field Mask Processing in System Logs

For the development of financial business, many interfaces need to use user information, and there will inevitably be some sensitive fields in user information, such as user name, bank card number and so on.Therefore, when users save sensitive information and log printing, they cannot save sensitive inf ...

Posted on Wed, 27 May 2020 17:36:58 -0700 by auday1982

SQL scripts for full and differential backup databases

In the work, SQL Job needs to be created to back up the database regularly. Now, the script is recorded as follows. 1. Full backup: -- FULL declare @filename varchar(1024), @file_dev varchar(300) declare @path varchar(1024) set @path = N'F:\Backup\Plan2\'; declare @extension_name varchar(16) set @extension_name = ...

Posted on Wed, 27 May 2020 09:00:31 -0700 by benwhitmore

About Laravel ORM caching the Model::find method

When working on a project some time ago, you want to cache the Model::find method without changing the method signature. And want to be plug and play. 1. First, let's see what the framework does when we call the find method? Find the code of Illuminate\Database\Eloquent\Model, search find, there is no such method. It seems to be leaving__ Call ...

Posted on Wed, 27 May 2020 07:12:29 -0700 by stanleybb