-
What is the use of BLOB, CLOB datatypes in JDBC
vinaymudgil007
- Jun 8th, 2010
These are used to store large amount of data into database like images, movie etc which are extremly large in size.Thanks,Vinay
madhuhari
- Apr 16th, 2007
BLOB(Binary Large Object) and CLOB(CharacterLargeObject) are SQL2 datatypes, which are introduced in JDBC 2.0 version. Suppose you have a requirement like, you want to store your content of resume(la...
-
What is the protocol is used in type4 driver?
vinaymudgil007
- Jun 8th, 2010
Per my understanding and knowledge over the years, its the Native [java specific] protocol that is used in type4 drivers !!!Thanks,Vinay
Spoorthi
- Sep 13th, 2006
jdbc:oracle:thin:@localhost:1521: our GlobalDatabasename
-
Which of the following statements is true regarding the failing of the class.forName in jdk 1.1.x.
A) A workaround is to explicitly call the method DriverManager.registerDriver(new YourDriverClass).B) The problem is due to race condition in the class loader.C) The race condition prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.D) All the above.
-
State true or falseCan we retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column ?
A) TrueB) FalseExplanation: The ResultSet.getXXX methods are the only way to retrieve data from a ResultSet object, which means that you have to make a method call for each column of a row. It is unlikely that this is the cause of a performance problem, however, because it is difficult to see how a column could be fetched without at least the cost of a function call in any scenario.
vinaymudgil007
- Jun 8th, 2010
We can update the Row with the values of the result set via updateRow() but we can't fetch it and hence the answer is "NO" or falseThanks,Vinay
Praveen
- May 17th, 2006
we cannot retrieve a whole row of data at once.In JDBC getXXX() are the methods which are used to get the data from ResultSet by columnwise.
-
A user leaves an online shopping cart without checking out.Which of the following interfaces will notify to rollback the transaction?
A user leaves an online shopping cart without checking out.Which of the following interfaces will notify to rollback the transaction?a)HttpSessionb)HttpSessionBindingListenerc)HttpServletd)SingleThreadModele)FtpSession
vinaymudgil007
- Jun 8th, 2010
(b)HttpSessionBindingListener is the correct answervalueBound() and valueUnbound() are the methods that should be over-ridden to get this implemented.Thanks.Vinay
phanikhk
- Apr 9th, 2008
Any class can implement HttpSessionBindingListener interface. This interface includes two methods, valueBound() and valueUnbound(), that are called whenever the object that implements the interfa...
-
What is the difference between store procedures and prepared statement?
vinaymudgil007
- Jun 8th, 2010
To be straightforward, we can only compare two things when they are in the same scope/domain. This question says to differentiate b/w SPs and prepared statements isn't valid.Stored Procs are persi...
subhankar1982
- Feb 21st, 2009
Generally procedure and functions are written in PL/SQL code and it will reside in databases. When we develop some application in Java using JDBC to deal with specific databases for specific purpose...
-
What are the Database transactions? How we can maintain transactions using JDBC? Explain with example?
vinaymudgil007
- Jun 8th, 2010
Database transactions => A group of SQL queries which should either all be executed or none should be executed will comprise of a tracnsaction.Maintain transactions using JDBC => We can do ...
trcdutt
- Feb 15th, 2008
Here is a skeleton of code for implementing a transaction.import java.sql.Connection;public class Test {public void AllTransactionStatements() { Connection con = getCon(); &nbs...
-
If i give two Class.forName how can i konw which driver is loading? whether it is possible or not?
vinaymudgil007
- Jun 8th, 2010
Yes it possible.... Please see public static Enumeration getDrivers() method in java.sql.DriverManager.DriverManager class which gives the complete list of Drivers available for use as an Enumeration.Thanks,Vinay
Supriya Ahire
- Feb 2nd, 2007
Hello, Yes , U can use two Class.forName() as Drivermanager keeps array internally to store the Drivernames so whichever come first will we loaded & used.Regards, Ms.Supriya Ahire
-
How will you determine which driver is connected to the database
Can u give correct answer for this....!
vinaymudgil007
- Jun 8th, 2010
public static Enumeration getDrivers() method in java.sql.DriverManager class will do this for us.Some more useful information below:public class DriverManager is the basic service for managing a set ...
Nitesh Gupta
- Sep 10th, 2007
Through MethodDriverManger.getDriver(url) you will get the driver name.
-
ODBC & JDBC
What is the purpose of creating ODBC data source in establishing a connection between Java application & database?
sindhumsc
- Aug 24th, 2010
ODBC stands for open database connectivity which helps us to connect then link from Java to database..so if we want to connect from Java to any database one way is to use ODBC which helps to connect Java to any database (like Oracle, MySQL..).
-
Which of the following statement is true regarding the three tier model in the JDBC driver model architecture.
A) A middle tier is introduced in this model.B) Collection of SQL statements from the client and handing it over to the database.C) Maintaining control over accessing and updating of receiving results from database to the client.D) All of the above.
satheesh kumar. sriramaneni
- May 4th, 2006
A is the correct one.
-
Difference between local and global transaction?
vinaymudgil007
- Jun 8th, 2010
The primary difference is that local transaction are single JVM level while global transaction are at multiple JVM level and hence global transactions need different design approach [which can be clas...
ak40732
- Mar 21st, 2006
A transaction is atomic unit of Work.The tasks which are made into the transaction act as a unit which can be executed successfully all,or if at least one task fails to its promise ,then the effect of...
-
JVM and JDBC Connectivity
Explain working of Java Virtual Machine (JVM)
Explain the working cycle of the JDBC-ODBC connectivity?Ashwinshenoy7
- May 9th, 2011
As the question says JVM and JDBC, let me tell you what JVM is initially,JVM is java virtual machine which is platform dependent but Java is platform independent and its source code can be executed on...
-
How many statements can be created with one connection
Chaka
- Jun 13th, 2011
As many as you want, as long as it's one-at-a-time and you reset the Statement object after each usage:Statement st=con.createStatement(SQL_String1)ResultSet rs=st.executeQuery();//process rs herest.close();st=null;st=con.createStatement(SQL_String2)etcetc
manikant
- Oct 31st, 2005
No upper bound
-
What Class.forName( ) method will do
Answered by Jey Ramasamy on 2005-05-10 05:50:07: Class.forName() is used to load the Driver class which is used to connect the application with Database. Here Driver class is a Java class provided by Database vendor.
sankalpshah06
- Jun 21st, 2011
It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a Database.
ashwin1483
- May 15th, 2008
Class.forName is used to create an instance of the driver and register with the DriverManager.
-
SQL query using JDBC
When you execute a SQL query using JDBC, do you get a complete recordset or the partial recordset?
-
What are the three statements in JDBC & differences between them
Answered by Jey on 2005-05-10 05:53:50: 1.Statement which is used to run simple sql statements like select and update 2. PrepareStatment is used to run Pre compiled sql. 3. CallableStatement is used to execute the stored procedures.
Naveen Sharma
- Jul 31st, 2011
Class.forname is used to load a class.
When we are making database connectivity then class.forname(................) must be the first statement.Harish Chevuri
- Jun 3rd, 2011
three statements in jdbc1. statement : whic is used to execute select and non select queries.2. PreapreStatement : which is also used to execute select and non select queries but PrepareStatement whic...
-
-
Retrieving data methods
what methods did you use for retrieving data form a ResultSet object
Mohit Pabari
- Oct 6th, 2011
The getX() method is used, where X is String or Int depending on the type used in the database.
debasish padhy
- Jul 15th, 2011
GetString() method is used to retrieve data from the resultset
-
3.which one is better to create a thread by implementing Runnable or By Extending Thread in java?">
1.why constructor does not have return type in java?2.why static does not support " this" and "super" keyword in java ?3.which one is better to create a thread by implementing Runnable or By Extending Thread in java?
JDBC Interview Questions
Ans