Anvi Jain has Published 660 Answers

How to handle indexes in JavaDB using JDBC program?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 16:17:53
Indexes in a table are pointers to the data, these speed up the data retrieval from a table. If we use indexes, the INSERT and UPDATE statements get executed in a slower phase. Whereas SELECT and WHERE get executed with in lesser time.Creating an indexCTREATE INDEX index_name on table_name (column_name);Displaying ... Read More

How to get the list of all drivers registered with the DriverManager using JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 16:08:27
The java.sql.DriverManager class manages JDBC drivers in your application. This class maintains a list of required drivers and load them whenever it is initialized.Therefore, you need to register the driver class before using it. However, you need to do it only once per application.One way to register a driver class ... Read More

How to Read data from BLOB and CLOB type columns from a table using JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 15:54:20
Clob datatypeCLOB stands for Character Large Object. in general, an SQL Clob is a built-in datatype which is used to store large amount of textual data. Using this datatype, you can store data up to 2, 147, 483, 647 characters. MYSQL database provides support Clob datatype TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT.The ... Read More

How to retrieve binary data from a table using JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 15:41:28
SQL databases provide a datatype named Blob (Binary Large Object) in this, you can store large binary data like images.To retrieve binary (stream) values from a table JDBC provides a method called getBinaryStream() in the PreparedStatement interface.It accepts an integer representing the index of the column of the table and ... Read More

What is the MySQL datatype to store DATALINK object in JDBC

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 15:32:12
A DATALINK object represents an URL value which refers to an external resource (outside the current database/data source), which can be a file, directory etc..MySQL does not provide any separate datatype to store DATALINK/URL value you need to store using TEXT or VARCHAR datatypes as shown in the following query ... Read More

Write a program to get the list of all the supported datatypes in JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 15:20:38
The class named Types of the java.sql package contains the constants that represents the SQL datatypes. All these datatypes are represented by unique integer values.Retrieving the integer values from the Types classTo print all the class names and values of the constants in java.sql.Types class −Retrieve all the fields in ... Read More

Is it mandatory to register the driver while working with JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 15:05:45
Initially, till Java6 it is needed to register the driver using Class.forname() or the registerDriver() method before establishing connection with the database.But, since Java 1.6, JDBC 4.0 API, there is no need to register the driver explicitly, You Just need to set the Class path for the JDBC 4.X driver, ... Read More

How to start a transaction in JDBC?

Anvi Jain
Anvi Jain
Published on 04-Jul-2019 14:49:43
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program.A transaction is the propagation of one or more ... Read More

JDBC Class.forName vs DriverManager.registerDriver

Anvi Jain
Anvi Jain
Published on 03-Jul-2019 17:20:49
To connect with a database using JDBC you need to select get the driver for the respective database and register the driver. You can register a database driver in two ways −Using Class.forName() method − The forName() method of the class named Class accepts a class name as a String ... Read More

Batch Inserts Using JDBC Statements

Anvi Jain
Anvi Jain
Published on 03-Jul-2019 17:11:34
Grouping a set of INSERT Statements and executing them at once is known as batch insert.Batch inserts using Statement objectTo execute a batch of insert statements using the Statement object −Add statements to the batch − Prepare the INSERT quires one by one and add them to batch using the ... Read More
1 2 3 4 5 6 7 ... 66 Next
Advertisements