Posts related to tag: Database


MySQL: LIMIT Clause

MySQL LIMIT is a clause used in SQL queries to restrict the number of rows returned from a database table. […] Continue reading »

Does Spring Boot automatically close database connection?

Yes, Spring Boot can automatically manage and close database connections for you. Spring Boot provides integration with various database technologies […] Continue reading »

Best Practices to Optimize SQL Query

Efficiently optimizing SQL queries is crucial for ensuring optimal performance and responsiveness in database-driven applications. Whether you’re a database administrator, […] Continue reading »

ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied

In the Oracle database, if you have created a new user and tried to log in with a newly created […] Continue reading »

MongoDB- ADD, MODIFY/RENAME, or DELETE Key

In MongoDB database, db.collection.update({criteria},{$operator: {new value}}) or db.collection.updateMany({criteria},{$operator: {new value}}) method is used to ADD, DELETE, or MODIFY/RENAME the existing […] Continue reading »

MongoDB- INSERT, SELECT, UPDATE, and DELETE Query

This page will help you to perform the basic query/operation with the MongoDB database like SELECT, INSERT, UPDATE, and DELETE. […] Continue reading »

How to set Username, Password, and Roles to MongoDB Database

In this guide, we’ll show you how to set username, password, and roles to the MongoDB database. MongoDB database instance […] Continue reading »

Spring Boot + MongoDB CRUD Example

In this article, we’ll build a Spring Boot REST API which performs the create, read, update, and delete (CRUD) operation […] Continue reading »

Spring Data MongoRepository Interface Methods Example

In this article, we’ll explore the methods available in the MongoRepository interface provided by Spring Data in the package org.springframework.data.mongodb.repository. […] Continue reading »

How to connect Spring Boot application with MongoDB

This guide will help you to establish a database connection bridge between the Spring Boot application and MongoDB database. You […] Continue reading »

Spring Boot REST API File Upload/Save Example

This guide shows you how to upload/save a file using Spring Boot REST API. To upload files via HTTP multi-part […] Continue reading »

1 2