Vikyath Ram has Published 176 Answers

Java Connection commit() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

The commit() method of the Connection interface saves all the modifications made since the last commit.con.save()If any issue occurs after the commit you can revert all the changes done till this commit by invoking the rollback() method.Con.rollback()To commit a transactionRegister the driver using the registerDriver() method of the DriverManager class as −//Registering the Driver DriverManager.registerDriver(new ... Read More

Java Connection getNumeric() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

The getNumeric() method of the Connection interface retrieves the list of math functions supported by the current database. The names returned by this method are the Open CLI math function names.This method returns a String value holding the list of functions separated by commas (", ").To get the list of the numeric ... Read More

Java Connection getStringFunctions() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

The getStringFunctions() method of the Connection interface retrieves the list of String functions supported by the current database. The names returned by this method are the Open CLI String function names.This method returns a String value holding the list of functions separated by commas (", ").To get the list of ... Read More

Java Connection getSystemFunctions() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

This method retrieves the list of System functions supported by the current database. The names returned by this method are the Open CLI System function names.This method returns a String value holding the list of functions separated by commas (", ").To get the list of the System functions supported by ... Read More

Java DatabaseMetaData getTimeDateFunctions() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

This 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.This method returns a String value holding the list of functions separated by commas (", ").To get the list of the ... Read More

Java DatabaseMetaData getTypeInfo() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

The getTypeInfo() method of the DatabaseMetadata interface is used to get the description of all the data-types supported by the underlying database.This method returns a ResultSet object describing data types supported. This object holds values for the following details (as column names) −Column NameData TypeDescriptionTYPE_NAMEStringName of the data type.DATA_TYPEintInteger value representing ... Read More

Java DatabaseMetaData getSearchStringEscape() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

The getSearchStringEscape() method of the DatabaseMetaData interface is used to get the that is used to escape the wildcard characters ('_' or, '%') by the underlying database.This method returns a string parameter representing the value that is used to escape wildcard charactersTo get the DatabaseMetaData object −Make sure your database is up ... Read More

Java ResultSet isLast() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

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 ResultSet ... Read More

Java ResultSet isClosed() method with example

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

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

How to move the ResultSet cursor to the next row in JDBC?

Vikyath Ram

Vikyath Ram

Updated on 30-Jul-2019 22:30:26

Whenever we execute SQL statements using the executeQuery() method, it returns a ResultSet object which holds the tabular data returned by the SELECT queries(in general).The ResultSet object contains a cursor/pointer which points to the current row. Initially this cursor is positioned before first row (default position).You can move the cursor of the ... Read More

Advertisements