Connect Java to Postgres on ObjectRocket

Introduction If you’re a Java developer planning to work with a Postgres database in your applications, the first thing you’ll need to do is create the necessary connections. Fortunately, the task of connecting Java to Postgres is an easy one. In this article, we’ll show you how to connect Java to Postgres on ObjectRocket with … Continued

Java and Postgres Connection

Introduction Java Database Connectivity, or JDBC, is an API, or application programming interface, written for JAVA programming language. In order to enable a JAVA and Postgres connection, the JDBC driver must be used for a JAVA application to interact with the Postgres database. The JDBC driver both establishes a connection to the database and also … Continued

Retrieve a Record in PostgreSQL using a Prepared Statement in Java

Introduction A prepared statement is a server-side object linked to database object ID designed to enhance system performance. When executed, the specified prepared statement is parsed and analyzed and then rewritten according to the specified parameters. Prepared statements are used to avoid having the same statement repeatedly parsed, increasing system performance. This tutorial will explain … Continued

PostgreSQL Prepared Statement in Java

Introduction There are multiple statement types understood by PostgreSQL. While PostgreSQL statements can easily be parsed, multiple user performing multiple queries at the same time against the database can sometimes result a bottleneck. To help prevalent this phenomenon, a “prepared” statement can be constructed to avoid the repeated parsing of the same statements. This tutorial … Continued

Java and PostgreSQL Web Application Part 9

Introduction Building a Java web application that can interact with a PostgreSQL database is a complex task that involves a number of steps. Throughout our tutorial series, we’ve been providing step-by-step instructions for building an example application. In this last installment of the series, we’ll show you how to create the delete and search features … Continued

Java and PostgreSQL Web Application PART 8

Introduction This is Part 8 of the multiple-series tutorial that explains how to build a Java PostgreSQL web application from scratch with ECLIPSE, Spring Data, Tomcat, and other databases. Part 7 showed you how to add handlers for creating and inserting records into a database, and then view them on your web application’s home screen. … Continued

Java and PostgreSQL Web Application Part 3

Introduction Creating a Java web application that interacts with PostgreSQL is a complex process that involves quite a few steps. Our multi-part tutorial series takes you through every stage of the process with step-by-step instructions. The previous article in this series discussed the configuration of the dispatcher servlet and the view resolver. In this article, … Continued

Java and PostgreSQL Web Application Part 6

Introduction Welcome to Part 6 in the multiple-series that explains how to build a Java PostgreSQL web application from scratch with ECLIPSE, Spring Data, Tomcat, and other databases. Part 5 went over the code for the web application’s repository interface. Today, in Part 6, you’ll learn about the handler methods to link the database information … Continued

Java and PostgreSQL Web Application Part 7

Introduction Welcome to Part 7 of the multiple-series that explains how to build a Java PostgreSQL web application from scratch with ECLIPSE, Spring Data, Tomcat, and other databases. Part 6 discussed how to use the handler to link information in a database and then display table records on the home page of your web application. … Continued

Java and PostgreSQL Web Application PART 2

Introduction If you’re a Java developer, you may find yourself wanting to build an application that interacts with a PostgreSQL database. This multi-part tutorial will explore this topic in detail, showing how to build a Java web application using the Eclipse IDE and several other technologies. In the first article of this series, we explained … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.