Arushi has Published 199 Answers

How to retrieve the contents of a ResultSet from last to first in JDBC?

Arushi
Arushi
Published on 15-May-2019 16:24:20
ResultSet objectCertain SQL queries (especially SELECT) returns tabular data, In JDBC the object of the java.sql.ResultSet interface holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).ResultSet Cursor/pointerThe ResultSet object has a cursor/pointer which points to ... Read More

Java ResultSet isBeforeFirst() method with example

Arushi
Arushi
Published on 15-May-2019 16:07:38
When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ... Read More

The DatabaseMetaData getResultSetHoldability() method with example

Arushi
Arushi
Published on 15-May-2019 15:48:22
ResultSet holdability determines whether the ResultSet objects (cursors) should be closed or held open when a transaction (that contains the said cursor/ResultSet object) is committed using the commit() method of the Connection interface.The getResultSetHoldability() method of the DatabaseMetaData interface retrieves the default holdability for the ResultSet objects of the underlying database.This ... Read More

Java Connection setTransactionIsolation() method with example

Arushi
Arushi
Published on 15-May-2019 15:29:35
In a database system where more than one transaction is being executed simultaneously and in parallel, the property of isolation states that all the transactions will be carried out and executed as if it is the only transaction in the system. No transaction will affect the existence of any other ... Read More

Java Connection getClientInfo() method with example

Arushi
Arushi
Published on 15-May-2019 15:23:56
The getClientInfo() method of the Connection interface returns the name and values of the client info properties of the current connection. This method returns a properties object.To retrieve the values of the client info properties file.Register the driver using the registerDriver() method of the DriverManager class as −//Registering the Driver DriverManager.registerDriver(new com.mysql.jdbc.Driver());Get ... Read More

Java Connection getMetaData() method with example

Arushi
Arushi
Published on 15-May-2019 15:15:02
Generally, Data about data is known as metadata. The DatabaseMetaData interface provides methods to get information about the database you have connected with like, database name, database driver version, maximum column length etc...The getMetaData() method of the Connection interface retrieves and returns the DatabaseMetaData object. This contains information about the database ... Read More

Java Connection releaseSavepoint() method with example

Arushi
Arushi
Published on 15-May-2019 15:00:59
A save point is a logical rollback point within a transaction. When you set a save point, whenever an error occurs past a save point, you can undo the events you have done up to the created save point using the rollback() method.You can set a save point in a ... Read More

Java Connection getHoldability() method with example

Arushi
Arushi
Published on 15-May-2019 12:49:31
ResultSet holdability determines whether the ResultSet objects (cursors) should be closed or held open when a transaction (that contains the said cursor/ResultSet object) is committed using the commit() method of the Connection interface.The getHoldability() method of the Connection interface is used to retrieves and returns the current holdability value of the ResultSet ... Read More

What is ResultSet holdability in JDBC?

Arushi
Arushi
Published on 15-May-2019 12:31:20
ResultSet holdability determines whether the ResultSet objects (cursors) should be closed or held open when a transaction (that contains the said cursor/ ResultSet object) is committed using the commit() method of the Connection interface.You can set the ResultSet holdability using the setHoldability() method of the Connection interface.con.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);The ResultSet interface provides ... Read More

Java DatabaseMetaData supportsUnion() method with example.

Arushi
Arushi
Published on 14-May-2019 16:07:46
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.To use this UNION clause, each SELECT statement must haveThe same number of columns selectedThe same number of column expressionsThe same data type andHave them in the same orderBut they ... Read More
Previous 1 2 3 4 5 6 7 ... 20 Next
Advertisements