MySQL
Ascend to the pinnacle of MySQL mastery with our comprehensive guide to the latest interview question answers. Elevate your understanding of MySQL’s intricate nuances and emerge as a sought-after database expert.
Solidify your grasp of fundamental MySQL concepts, including data modeling, query optimization, and performance tuning. Our in-depth explanations will empower you to articulate your expertise with clarity and precision.
-
Interview Preparation, J2EE, Java 11, Java 14, Java 16, Java 17, Java 8, Maven SVN + Git, Microservices, MySQL, SOA Architecture, Spring Boot, Spring/Azure/AWS Cloud, Tomcat container
Spring Boot : Steps to Configure and Fine-Tune HikariCP DataSource
1. For better performance and concurrency in microservice architecture, HikariCP is recommended along with Spring Boot application. Main question is how to configure HikariCP in our microservice? Answer is, its simple and straight…
-
Interview Preparation, MySQL, OSGI Blueprint with Camel, Red Hat Fuse ESB, Red Hat JBoss Developer Studio, SOA Architecture
Red Hat JBoss Fuse ESB + Apache Camel + Aggregate EIP + MySQL + OSGI Blueprint
In this blog we will implement Apache Camel Enterprise Integration Patterns Aggregate. It concatenates number of messages together into a single message. In this example we will insert multiple records in MySQL…
-
Red Hat JBoss Fuse ESB + Apache Camel + MySQL + OSGI Blueprint DSL
In this blog, we will learn Apache Camel integration with MySQL database with OSGI Blueprint DSL. Application Architecture Overview This example contains step by step guide for MySQL database integration. Here we…
-
Interview Preparation, Java 8, Microservices, MySQL, Spring Boot, Spring Data, Tools SoapUI, Postman etc.
Spring Boot + Spring Data MongoDB + Rest API + Example
High Level Application Architecture Here is the high level application’s architecture with MongoDB integration. Why MongoDB? What are the differences between SQL and NO-SQL databases? A relational database is based on a relational…
-
Spring Boot + Spring Security with Database Authentication (MySQL) + Rest API + Example
Microservice: Application Overview In this example, we are exposing a Rest API (/login) for the end user authentication. URL: http://localhost:8080/springbootdbauth/login. On successful login it will return a message “User: Successfully logged in!”…
-
Spring Boot + Spring Security with inMemoryAuthentication + Add | Delete Operations in MySQL + Custom Login | Logout JSP + Example
In this Spring Boot example, we will discuss inMemoryAuthentication in Spring Security along with custom login, logout JSP pages. Technology Stack Project Structure Maven File (pom.xml) Application Configuration (application.yaml) MySQL Database Bootstrap…
-
MySQL: ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long – Fix
The problem seems with versions of MySQL in combination with old version of mysql-connector.jar. Just tried with below mysql-connector.jar version with MySQL 8.0 and seems to work for me perfectly. If you’re…