Database

Spring Boot MongoDB — step-by-step Databases tutorial on Progressive Robot

Spring Boot MongoDB

URL: https://www.progressiverobot.com/spring-boot-mongodb/ Welcome to Spring Boot [MongoDB](/community/tutorials/mongodb-tutorial) example. Spring Boot is the easiest way to spin a spring project quickly and MongoDB is the most popular NoSQL database. Let's see how to integrate spring with MongoDB database. Spring Boot MongoDB We need following APIs to work with Spring Boot and MongoDB database. Spring Data MongoDB […]

Read more
SQL Injection in Java and How to Easily Prevent it — step-by-step Programming tutorial on Progressive Robot

SQL Injection in Java and How to Easily Prevent it

URL: https://www.progressiverobot.com/sql-injection-in-java/ What is SQL Injection? SQL Injection is one of the top 10 web application vulnerabilities. In simple words, SQL Injection means injecting/inserting SQL code in a query via user-inputted data. It can occur in any applications using relational databases like Oracle, MySQL, PostgreSQL and SQL Server. To perform SQL Injection, a malicious user […]

Read more
How To Use Triggers in MySQL — step-by-step Databases tutorial on Progressive Robot

How To Use Triggers in MySQL

When working with relational databases and SQL, most operations on the data are performed as a result of explicitly executed queries, such as SELECT, INSERT, or UPDATE. However, SQL databases can also be instructed to perform pre-defined actions automatically every time a specific event occurs through triggers. In this tutorial, you’ll use different SQL triggers to automatically perform actions where rows are inserted, updated, or deleted.

Read more
Tomcat DataSource JNDI Example in Java — step-by-step Programming tutorial on Progressive Robot

Tomcat DataSource JNDI Example in Java

URL: https://www.progressiverobot.com/tomcat-datasource-jndi-example-java/ Welcome to Tomcat DataSource JNDI Example Tutorial. We looked at the [JDBC DataSource](/community/tutorials/java-datasource-jdbc-datasource-example "JDBC DataSource Example – Oracle, MySQL and Apache DBCP Tutorial") in the last tutorial and learned how to use that in standalone java application. Tomcat DataSource JNDI ![tomcat datasource, jndi example, tomcat jndi, jndi tutorial](images/tomcat-datasource-jndi-example-java-section-1.png) Actual benefit of DataSource comes […]

Read more
Install MongoDB on Linux — step-by-step Linux tutorial on Progressive Robot

Install MongoDB on Linux

URL: https://www.progressiverobot.com/install-mongodb-linux/ Sometime back I wrote a post on how to [install MongoDB on Mac OS X](/community/tutorials/install-mongodb-mac). However most of the development usually happens on Unix/Linux machines. So today we will look into how to install MongoDB on linux system. Install MongoDB on Linux !install mongodb on linux Current version of MongoDB is 3.4.7 and […]

Read more
Java DataSource, JDBC DataSource Example — step-by-step Programming tutorial on Progressive Robot

Java DataSource, JDBC DataSource Example

URL: https://www.progressiverobot.com/java-datasource-jdbc-datasource-example/ Java DataSource and JDBC DataSource programming is the way to work with database in our java programs. We have already seen that [JDBC DriverManager](/community/tutorials/jdbc-example-mysql-oracle "JDBC Example Tutorial – Drivers, Connection, Statement and ResultSet") can be used to get relational database connections. But when it comes to actual programming, we want more than just […]

Read more
JDBC Interview Questions and Answers — step-by-step Programming tutorial on Progressive Robot

JDBC Interview Questions and Answers

URL: https://www.progressiverobot.com/jdbc-interview-questions-and-answers/ Welcome to JDBC Interview Questions and Answers. JDBC API is used to connect to relational databases and run SQL queries from Java Programs. In the last few articles, we learned about JDBC API and its important features. This article is aimed to provide some of the important JDBC Interview Questions with Answers to […]

Read more
JDBC Tutorial — step-by-step Programming tutorial on Progressive Robot

JDBC Tutorial

URL: https://www.progressiverobot.com/jdbc-tutorial/ Welcome to JDBC tutorial. Java DataBase Connectivity (JDBC) is one of the most widely used API in enterprise applications. This is because most of the applications use some sort of database connectivity. I have recently posted a lot of JDBC tutorials related to basic JDBC, DataSource and it's integration with Spring Framework. JDBC […]

Read more
CHAT