Sometimes in your Java application you may want to store some data in a temporary file that can safely be deleted when the work is done. Java IO and NIO APIs itself provide methods to create a temporary file in Java. Table of contents Methods in java.io.File class to create…
In this tutorial we’ll see how to do a batch insert or update using JDBC batch processing. If you have to run a large number of SQL statements it is much more efficient to run them as a batch rather than as individual commands hitting the DB for each command.…
In this post we’ll see how to manage a transaction using JDBC in a Java application. A transaction represents a single unit of work where a set of one or more statements are executed as a unit. In a transaction either all of the statements are executed successfully or none…
Using java.sql.ResultSetMetaData interface you can get metadata about the ResultSet object. When you retrieve data from DB a ResultSet object is returned with each ResultSet object there is an associated ResultSetMetaData object containing information about the returned ResultSet like table name, column count, column’s data type. How to get ResultSetMetaData…
Using java.sql.DatabaseMetaData interface you can get metadata about the DB you are connected to. DatabaseMetaData interface in Java has methods to get information about- Database like DB Product name and version, scehemas available in DB. JDBC Driver like the driver’s name and version Tables in any DB schema, Views in…
In this post we’ll see how to convert 24 hours time format to 12 hours time format and 12 hours time format to 24 hours time format in Java. For the conversion you can either use SimpleDateFormat or Java 8 onward you can use DateTimeFormatter class to do the conversion…
In this post we’ll see how to configure connection pooling using HikariCP in your JDBC application. Maven dependency for HikariCP If you are using Maven then you can add the following dependency in pom.xml which works for Java 8 to Java 11. <dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>3.4.5</version> </dependency> You can also…
In this post we’ll see how to configure connection pooling in your application using C3P0. Maven dependency for MChange C3P0 If you are using Maven then you can add the following dependency in pom.xml <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.5</version> </dependency> You can also download the jars directly from the following location…
In this post we’ll see how to configure connection pooling in your application using Apache DBCP. Why connection pool is needed If a DB connection is created every time user connects to DB and closed later it results in a lot of time getting wasted in creating connection object itself…
For a small application it is OK to use DriveManager to get connection as we saw in the example JDBC Database Connection Steps but any enterprise application will most definitely use DataSource as means of connecting to a data source. With JDBC DataSource objects you get advantage of connection pooling…
