×
Home
Jobs
Tools
Coding Ground
Current Affairs
UPSC Notes
Online Tutors
Whiteboard
Net Meeting
Tutorix
Login
Packages
Categories
Java
JSP
iOS
HTML
Android
Python
C Programming
C++ Programming
C#
PHP
CSS
Javascript
jQuery
SAP
SAP HANA
Data Structure
RDBMS
MySQL
Mathematics
8085 Microprocessor
Operating System
Digital Electronics
Analysis of Algorithms
Mobile Development
Front End
Web Development
Selenium
MongoDB
Computer Network
General Topics
Library
Videos
Q/A
eBooks
Login
Library
Videos
eBooks
Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Selected Reading
UPSC IAS Exams Notes
Developer's Best Practices
Questions and Answers
Effective Resume Writing
HR Interview Questions
Computer Glossary
Who is Who
Anvi Jain
has Published
660
Answers
How to handle indexes in JavaDB using JDBC program?
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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?
JDBC
Object Oriented Programming
Programming
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
JDBC
Object Oriented Programming
Programming
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
JDBC
Object Oriented Programming
Programming
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
Print
Add Notes
Bookmark this page
Report Error
Suggestions
Save
Close
Dashboard
Logout