Blog Archives

♦ 12 FAQ JDBC interview questions and answers

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…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in FAQs JEE, JDBC, member-paid Tagged with: ,

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

Posted in JDBC, JDBC Tutorial

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, but for larger queries with many parameters it os more

Posted in JDBC

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. To connect to a database we need to…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in JDBC, member-paid

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…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in JDBC, member-paid, Spring JavaConfig

Learn by Java topics ♥Free | ♦FAQs

open all | close all

100+ Java Tutorials by topics

open all | close all