Blog Archives

02: JDBC with MySQL, Datasource, and connection pool Tutorial

Step 1: pom.xml file with commons-dbcp2 for the connection pooling and abstraction layer for the datasource.

db.properties for connection details

Step 2: Create a new source folder “src/main/resources”.

Step 3: Define the MySQL database “learnjavadb” connection properties in a new file named “db.properties”

Read more ›



12 FAQ JDBC interview Q&As

Q1. What are JDBC Statements? What are different types of statements? How can you create them? A1. A statement object is responsible for sending the SQL statements to the Database. Statement objects are created from the connection object and then executed. The types of statements are: Statement (regular statement as...

Members Only Content
Log In Register Home


JDBC NamedParameterStatement versus PreparedStatement

Q. When will you use NamedParameterStatement over PreparedStatement?
A.

Reason 1:  PreparedStatement uses anonymous parameters that are accessed by index, which is ok when you have 2 or 3 parameters,

Read more ›



JDBC Overview Interview Questions and Answers

Q. What is JDBC? How do you connect to a database? A.  JDBC stands for Java DataBase Connectivity. It is an API which provides easy connection to a wide range of databases. … Read more ›...

Members Only Content
Log In Register Home


Spring, JavaConfig (i.e @Configuration) & JDBC by example

Example #1 Wiring JDBC Datasource application.yml where the datasource properties are read. Example #2 Wiring JDBC Datasource with JNDI Example #3 Wiring JDBC Embedded Datasource for integration testing Example #4 Wiring up the JdbcTemplate by passing in the datasource Example #5 Wiring up a DAO class that uses the JdbcTemplate...

Members Only Content
Log In Register Home


Why & What are the benefits

🎯 Why java-success.com?

🎯 What are the benefits of Q&As approach?

Learn by categories such as FAQs – Core Java, Key Area – Low Latency, Core Java – Java 8, JEE – Microservices, Big Data – NoSQL, Architecture – Distributed, Big Data – Spark, etc. Some posts belong to multiple categories.

800+ Java & Big Data Q&As Menu

Top