Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
JDBC Articles
Page 2 of 22
Java DatabaseMetaData getTimeDateFunctions() method with example
In this article, we will learn how to retrieve the list of time and date functions in the database using the getTimeDateFunctions() method of the DatabaseMetaData class in Java. getTimeDateFunctions() The getTimeDateFunctions() method retrieves the list of time and date functions supported by the current database. The names returned by this method are the Open CLI time and date function names. Steps to Retrieve Time and Date Functions in Database To get the list of the time and date functions supported by the underlying database − Step 1: Register the Driver: Make sure your database is ...
Read MoreJava sql.Time setTime() method with example
In this article, we will learn the usage of the setTime() method in Java with a complete example. Handling time-related data is an essential aspect of many Java applications, especially when interacting with databases. The java.sql.Time class, designed to handle SQL TIME values. What is setTime() method The setTime() method of the java.util.Time class accepts a variable of long type, representing the number of milliseconds from the epoch time (January 1, 1970, 00:00:00.000 GMT) to the required time, and sets the specified time value to the current Time object. //Setting time time.setTime(time_value_in_long); Use Cases of setTime() Following are the use ...
Read MoreJava ResultSet isAfterLast() Method with Examples
The ResultSet interface in Java is used to retrieve data from a database in a tabular form. The isAfterLast() method is one of the navigation methods in the ResultSet that helps in checking the position of the cursor. Specifically, isAfterLast() checks whether the cursor is positioned after the last row of the result set. Method Definition The isAfterLast() method of the ResultSet interface is used to determine whether the cursor is after the end of the ResultSet.This method returns a boolean this value is true, if the cursor is after the end of the ResultSet else, it returns false. ...
Read MoreJava DatabaseMetaData getMaxBinaryLiteralLength() method with example.
In this article, we will learn about the getMaxBinaryLiteralLength() method of the DatabaseMetaData interface in JDBC. getMaxBinaryLiteralLength() method The getMaxBinaryLiteralLength() method of the DatabaseMetaData interface is used to find out the maximum number of characters (hex) that the underlying database allows for a binary literal. This method returns an integer value, representing the maximum length of a binary literal. If this value is 0 it indicates that there is no limit or, the limit is unknown. Steps to get the DatabaseMetaData object The following are the steps to get the DatabaseMetaData object − ...
Read MoreJava DatabaseMetaData getDatabaseMinorVersion() method with example
In this article, we will learn how to use the getDatabaseMinorVersion() method of the DatabaseMetaData interface in Java to retrieve the minor version of the underlying database. This method helps check the version details of the connected database. What is DatabaseMetaData?The DatabaseMetaData is an interface that provides methods to retrieve metadata about a database, such as the database product name, version, driver name, the total number of tables, views, and more. To get the DatabaseMetaData object, use the getMetaData() method of the Connection interface.Syntax: public DatabaseMetaData getMetaData() throws SQLException; ...
Read MoreJava Connection getTransactionIsolation() method with example
In this article, we learn the Connection getTransactionIsolation() method in Java, which allows you to determine a database connection's current transaction isolation level. Transaction isolation levels dictate how transactions interact, particularly regarding data locking during reads or writes. What is the getTransactionIsolation() Method? The getTransactionIsolation() method is part of the Connection Interface in Java. It returns an integer constant representing the current isolation level of the database connection. JDBC provides support for 5 transaction isolation levels through the Connection interface − TRANSACTION_NONE: It is represented by an integer value 0 and does not support transactions. ...
Read MoreJava Connection setSavepoint() method with example
When working with databases in Java, there are scenarios where you might want to perform complex transactions involving multiple steps. To maintain control and flexibility during such operations, Savepoints come into play. The setSavepoint() method in the java.sql.Connection interface allows you to create a savepoint within a transaction, providing a mechanism to roll back to a specific point if needed. What is Savepoint? A Savepoint is a marker within a database transaction. It enables partial rollbacks, meaning you can undo a subset of changes made during a transaction without affecting the entire operation. This is particularly useful in scenarios where ...
Read MoreJava DatabaseMetaData getCatalogs() method with example
In this article, we’ll look at how to retrieve and display the list of available catalogs (databases) in a MySQL instance using Java’s JDBC (Java Database Connectivity) API. By running a Java program that connects to the MySQL server, we’ll use the DatabaseMetaData class to fetch catalog names with the getCatalogs() method, showing each catalog’s name on the console. This process demonstrates how to access and navigate metadata in MySQL using JDBC, offering insight into the structure of your database environment. Steps to retrieve database catalogs The getCatalogs() method of the DatabaseMetaData interface returns the name of the underlying database ...
Read MoreJava DatabaseMetaData supportsGroupBy() method with example
In this article, we will learn how to check whether a database supports the SQL GROUP BY clause using JDBC in Java. The GROUP BY clause is used to organize identical data into groups in SQL queries, typically following the WHERE clause and preceding the ORDER BY clause. With JDBC, we can determine whether the underlying database supports this clause using the supportsGroupBy() method of the DatabaseMetaData interface. Problem StatementGiven a MySQL database, write a Java program that connects to the database and checks if the database supports the SQL GROUP BY clause.Input Database connection URL, username, and ...
Read MoreJava DatabaseMetaData getMaxStatements() method with example.
In this article, we will learn how to retrieve the maximum number of open statements allowed by a database using the DatabaseMetaData interface in Java. The getMaxStatements() method of the DatabaseMetaData interface is used to find out the maximum number of open statements (objects) that the underlying database allows at one time. This method returns an integer value, representing the maximum number of statements that are allowed to be open at a time. If this value is 0 it indicates that there is no limit or, the limit is unknown. Problem StatementGiven a connection to a database, write a ...
Read More