what are the drawbacks of JDBC? explain briefly?
Answers were Sorted based on User's Feedback
Answer / yahoo
1.It can't maintain the database Independent sql statements.
i.e In future if there is required to change the datbase
because of maintainance problem then we need to change all
sql statements according to the new database.
2.We cant move the ResultSet object through the network bcz
it is not serialized by default.
3.It is not at all good in the transaction management.
4.Allot of problems might be happend in case of connection
closing and opening.Is is required to programmer headache
Is This Answer Correct ? | 37 Yes | 1 No |
Answer / modi
Disadvantages of JDBC
1.JDBC is not easily if it is used in large projects. There is a big programming overhead.
2.Programmer must hardcode the Transactions and concurrency code in the application.
3.Handling the JDBC connections and properly closing the connection is also a big issue. Properly closing the connection is must.
4.JDBC is not good for big applications
Is This Answer Correct ? | 23 Yes | 8 No |
Answer / ravi
As mentioned earlier, JDBC is not ideal for big enterprise
level applications where in there is lot of
INSERTIONS/UPDATIONS. Because, lots of transaction control
needs to be programmed by the developer and I would choose
ejb or other ORM mechanism over JDBC.But JDBC is more
beneficial when the application has lots of SELECTS and the
end users are not really bothered about how real time the
data is? But this can also be achieved through JDBC with a
little bit more programming and with the usage of latest
JDBC specs.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / naresh katakam
Usually does not perform as well as type 2 drivers
The vendor client library needs to be installed on the
client machine.
Cannot be used in web-based application due the client side
software needed.
Not all databases have a client side library
This driver is platform dependent
Performance overhead since the calls have to go through the
JDBC overhead bridge to the ODBC driver, then to the native
db connectivity interface.
The ODBC driver needs to be installed on the client
machine.
Considering the client-side software needed, this is not
suitable for applets.
Requires database-specific coding to be done in the middle
tier.
An extra layer added may result in a time-bottleneck. But
typically this is overcome by providing efficient
middleware services described above.
At client side, a separate driver is needed for each
database.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / nikhil
1. java programmer should know how to write queries in sql.
2. database dependent(earlier you are using mysql and later oracle then the queries has to rewritten.)
3. while migrating, editing the .java file is required which is a bad practice.
Is This Answer Correct ? | 4 Yes | 3 No |
How to connect html page to database using jdbc?
Explain the difference between resultset and rowset in jdbc
what is the current version of JDBC? and explain its features?
What is the meaning of batch updates?
Explain about DSN?
How do I disallow NULL values in a table?
What are the different classes through which JDBC represents statements?
Does jdbctemplate close connection?
Is jdbc faster than odbc?
What are database warnings in jdbc and how can we handle database warnings in jdbc?
What is an encrypted internet connection?
Which type of JDBC driver is the fastest one?