Interested to Buy Any Domain ? << Click Here >> for more details...
what are the drawbacks of JDBC? explain briefly?
- 5 Answers
- 41715 Views
- I also Faced
- E-Mail Answers
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 ? | 38 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 |
What is jdbc architecture?
How data can be inserted into long row column of database?
Why resultset is used in java?
what is connection pooling?
What is com mysql jdbc driver?
What are the sailent features of JDBC 2.0?
What are different types of JDBC Drivers?
How to handle when the database crashes while reading the data from the database?
Can you create an index on sex column where there is M or F?
Write a program JDBCcode forfetching student database with SQL.
How can I get information about foreign keys used in a table?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
Core Java 
