Interested to Buy Any Domain ? << Click Here >> for more details...
what are the drawbacks of JDBC? explain briefly?
- 5 Answers
- 41815 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 |
Compare jdbc and odbc and how is jdbc required in this context.
What is db client?
How will you perform truncation using JDBC?
give me a java code snippet to connect Microsoft excel through.... I am trying alot... plz help me.
What is jdbc odbc bridge in java?
What is odbc and jdbc in dbms?
Explain the difference between inner and outer join ?
What is createstatement method in java?
What is JDBC API and when do we use it?
How can we retrieve the file in the oracle database?
what is connection pooling?
What does the jdbc driver interface do?
Core Java 
