We can create a Spring Boot application that uses JDBC as quickly as making its JPA variant without hassle. But no doubt, JDBC applications are much faster than those relying on ORM technology. For many, the idea of a JDBC
Specify Non-default PostgreSQL Schema When Connecting Using JDBC
By default, we use the public schema when we connect to PostgreSQL. Some applications use multiple schemas to store data in the database. Therefore, they need to specify explicitly which PostgreSQL schemas to use. This post shows how to connect
How to use Hibernate with simple JDBC application
This article demonstrates how to use Hibernate 4.3.x with MySQL 5.6.16 in Java using JDBC.
Java – Closing JDBC Database Resources with try-with-resources
This post demonstrates how to use Java JDBC API with try-with-resources database resources in the following order – ResultSet, Statement, and Connection. The try-with-resources is a new exception handling mechanism that makes it easier to correctly close resources used within
How to connect Java to MySQL using JDBC
This post shows how to connect Java to MySQL using JDBC. Therefore, nothing fancy here. Just JDBC basics. MySQL JDBC Requirements We used the following items for this post. Although we can use newer versions, the Java JDBC codes pretty
How to connect Java to PostgreSQL using JDBC
This is a simple post that shows how to connect Java to PostgreSQL using JDBC. Although most Java developers do not use this technique anymore, frameworks still do, and the codes are abstracted away from us. Meanwhile, some may still
How to connect to MariaDB using JDBC
This article demonstrates how to connect to MySQL using JDBC.
How to Configure a JDBC Resource in SAP NetWeaver AS
Background [wp_ad_camp_1] SAP NetWeaver AS, like other Application Servers for Java, has a facility to configure JDBC resources that can be used by Web Dynpro for Java applications running within it Turreta.com recommends using the latest available version of the
Connecting Tomcat 7 Web Application to Database Using JNDI
Several weeks ago, I looked at the some decompiled Java codes from a fairly small web application that basically records cheque numbers and generates reports. To my surprise, it was written in dreadful codes full of clutter and signs of haste! I almost cried. Just imagine the following code littered all around the application and entangled by a lot of package-level instance variables. Not to mention the SQL-statements-in-Servlets type of design pattern.