JDBC Tutorial Archives •

How To Fix MySQL JDBC 08001 Database Connection Error

When you use MySQL JDBC driver to connect to MySQL database server. You may encounter bellow error messages. try { Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dev2qa?useSSL=false”,”test”,”666888″); } catch (SQLException ex) { ex.printStackTrace(); System.out.println(“SQL State : ” + ex.getSQLState()); } Below are the error messages. INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@36d64342: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,userAccountDao]; root of factory hierarchy com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: …

How To Fix MySQL JDBC 08001 Database Connection Error Read More »

JDBC CallableStatement Stored Procedure Output Parameters Example

Leave a Comment / JDBC Tutorial / CallableStatement, JDBC, Output Parameter

This example will show you how to use java.sql.CallableStatement to get output data from a stored procedure. This example will use Microsoft SQL Server, the java code for other databases is the same. If you do not know how to create stored procedures in Microsoft SQL Server, you can read the article JDBC CallableStatement Stored …

JDBC CallableStatement Stored Procedure Output Parameters Example Read More »

JDBC CallableStatement Stored Procedure Input Parameters Example

Leave a Comment / JDBC Tutorial / CallableStatement, Input Parameter, JDBC

This example will show you how to use java.sql.CallableStatement to call a Microsoft SQL Server stored procedure with input parameters. If you use other databases such as Oracle, MySQL, etc, the java code is almost the same.

JDBC PreparedStatement Example – Batch Insert, Update, Delete

Leave a Comment / JDBC Tutorial / Batch, JDBC, PreparedStatement

java.sql.PreparedStatement class is more powerful and efficient than java.sql.Statement, This example will show you how to execute PreparedStatement in batch.

How To Load JDBC Configuration From Properties File Example

Leave a Comment / JDBC Tutorial / JDBC, MySQL

If you need to switch between different databases using JDBC, you can store different database JDBC connection-related information in a properties file. And then you can load the JDBC properties data in java source code to use them. This example will show you how to do it, and how you can utilize its benefits.

Use JDBC To Connect Microsoft SQL Server

Leave a Comment / JDBC Tutorial / Sql Server

This article will tell you how to connect Microsoft SQL Server using JDBC.

JDBC PreparedStatement Example – Create Table And Insert, Update, Delete Records

Leave a Comment / JDBC Tutorial / PreparedStatement

java.sql.PreparedStatement is a more powerful database operation class than java.sql.Statement. You can send a pre-compiled SQL statement to the database server with specified parameters. It is more efficient than java.sql.Statement when executing similar SQL commands repeatedly. This article will show you how to use the java.sql.PreparedStatement object to implement create table, insert, update or delete …

JDBC PreparedStatement Example – Create Table And Insert, Update, Delete Records Read More »

JDBC Statement Example – Batch Insert, Update, Delete

Leave a Comment / JDBC Tutorial / MySQL, Statement

When you have a lot of insert or update sql commands to execute, you can use java.sql.Statement addBatch(String sqlCmd) method to group them together and then run java.sql.Statement executeBatch() to commit all the commands to the database server at once.

How To Get Database Meta Data

JDBC PreparedStatement Example – Select Data List From Table

Leave a Comment / JDBC Tutorial / PreparedStatement

To select data from table use java.sql.PreparedSatement, you need first create a select sql command, and then get data list by execute java.sql.PreparedSatement.executeQuery() method. This article will show you examples.