JDBC

Home Answers Viewqa Java-Interview-Questions JDBC

QuestionAsk Questions?

samar

JDBC
1 Answer(s) 2 years and 8 months ago
Posted in : Java Interview Questions

what is ACID in transaction?

View Answers

October 28, 2010 at 4:00 PM

Hi,

A transaction is an atomic unit of work that must be completed in its entirety.The transaction succeeds if it committed and fails if it is aborted.Transactions have four essential properties:atomicity,consistency,isolation, and durability(known as the ACID properties).

A (Atomicity) -The sequence of operations must be atomic, either all or no operations are performed.

C (Consistency) - When completed, the sequence of operations must leave data in consistent mode. All the defined relations/constraints must me Maintained.

I (Isolation) - A Transaction must be isolated from all other transactions. A transaction sees the data defore the operations are performed , or after all the operations has performed, it can't see the data in between.

D (Durability) - All oprtaions must be permanently placed on the system. Even in the event of system failure , all the operations must be exhibit.

Thanks.

JDBC
JDBC why we use batch in jdbc

jdbc
jdbc display the records using index in jdbc

jdbc
jdbc Hai , Give a steps for jdbc connectivity

JDBC
JDBC How to add set of queries in a single query in JDBC

jdbc
jdbc please tell me sir.i dont know JDBC connection and how to create table in database

jdbc
jdbc how to write program to save data and retrieve data from the form in Java

jdbc
jdbc why do we need to load jdbc drivers before connecting to database

JDBC
JDBC how to set classpath for eclipse, java, where to copy jdbc connector

JDBC
JDBC in class.forname which driver name we are writing for the connection from jdbc to sqlserver 2008

jdbc
jdbc is it possible to use doget & dopost method with jdbc to call in a servlet programe

Jdbc
Jdbc A java program with jdbc connectivity with insert,delete,update options for name,regno,mark1,mark2,total

jdbc
jdbc define batch updates define batch updates?exp JDBC... links: http://www.roseindia.net/jdbc/Jdbc-batch-update.shtml http://www.roseindia.net/tutorial/java/jdbc/batchupdateresultsetexample.html

JDBC
JDBC save a data in the database I need a code to save a data... between java and mysql using JDBC and saves the data into the database. import... con = null; String url = "jdbc:mysql://localhost:3306/"; String db

JDBC
JDBC code to save a data in the database I need a code to save... the connection between java and mysql using JDBC and saves the data into the database...!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db

jdbc
how can we call stored procedure using jdbc how can we call stored procedure using jdbc Call a Stored Procedure using...(); For more information, visit the following link: JDBC call Stored Procedure

jdbc
how can we set transaction level through jdbc api how can we set transaction level through jdbc api Use Connection.setTransactionIsolation(int) to set the desired tansaction level, which takes one of the 5 arguments

jdbc
jdbc hey sir i just wanna have some ppt on jdbc coz have my exams next week and i have not attended any classes coz of job... I m studyng frm niit

jdbc
jdbc I can't run my jdbc program because it has error in this line: public static void main(String[] args) the error is:illegal static declaration in inner class would you please let me whats the problem? regards

jdbc
using jdbc connection import java.sql.*; public class CreateTable... = DriverManager.getConnection("jdbc:odbc:student"); Class.forName

jdbc
jdbc i had written jdbc connection in method and i need to get connection in another class? import java.sql.*; class... driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/test

jdbc
(); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost... information, visit the following link: JDBC Tutorials

jdbc
jdbc how to update int values of ms-access in jdbc program? In MS Access database, use Number data type for int values. import... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement st=null; st

jdbc - JDBC
Why JDBC JDBC used for what

JDBC - JDBC
JDBC - limitations of jdbc What are the limitations of JDBC

JDBC
retrieve the value from database into dropdown list using JDBC SQL 2005 How to retrieve the value from database into dropdown list using JDBC &...").newInstance(); String connectionURL = "jdbc:mysql://localhost:3306/test";; Connection

JDBC
JDBC write a JDBC program to display the result of any query on a student table in a JTable component. import java.awt....").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost

jdbc
define transactions define transactions Whenever a connection is created by using the JDBC, then by default it is in auto- commit mode. This means that SQL statement will be automatically committed immediately after

jdbc
the Connection.setTransactionIsolation(int level) method isolation level can be set in JDBC. the method can

jdbc
logical group of data with a number of columns. JDBC ResultSet Example Stored

jdbc
level can be set in JDBC. the method can accept any of the arguments listed below

jdbc
{ Connection con; con=DriverManager.getConnection("jdbc:odbc:student

JDBC
= DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root

jdbc
what are different type of locks what are different type of locks Types of locks in JDBC: Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency

jdbc
("jdbc:odbc:student"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver

jdbc
= DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root

JDBC
("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql

jdbc - JDBC
Java JDBC application Database Application in Java JDBC

JDBC - JDBC
JDBC Select Count Example Need an example of count in JDBC

JDBC - JDBC
JDBC -statement types in jdbc statement types in jdbc

jdbc - JDBC
Loading JDBC driver at runtime How to load JDBC Driver at runtime

jdbc

JDBC

jdbc

JDBC

Jdbc

jdbc

JDBC

Latest
Frameworks
Category