Forums Register Login

jdbc question

+Pie Number of slices to send: Send
Greetings everyone.
What is the difference between jdbc and odbc and the advantages of each.
Also what is the difference between 3tier and 2nd tier model?
Any useful answer would be appreciated
+Pie Number of slices to send: Send
JDBC and ODBC are sort of competitors. ODBC is Microsofts API for accessing data in an RDBMS. By changeing drivers one could port a program from MySQL to Oracle. The program does not have to change because it uses a standard API to access the database.
JDBC is a similar technology in JavaLand.
In a two tier architecture the application program that makes access directly to the database and publishes an output.
In a three tier architecture some middleware ( classes objects ) provide a buffer between the database and the client. Suppose you had a database tables of customers, phone numbers, and addresses. A given client might need data out of these three tables for an address book like presentation.
Now an application client ( SWING ) might fetch all this data itself. A second web client could fetch it all too. Now if there is a change in the database where the customer table gets split into two tables both clients have to be re-worked.
If the database is hidden behind a class and the customer table gets split then maybe only the class the supports both the web client and the application client will need to be modifed.
Its gets easier if both clients use a common class to validate addresses rather than each having their own private routines.
It's a beautiful day in this neighborhood - Fred Rogers. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 658 times.
Similar Threads
Oracle Drivers
What is difference between jdbc 2.0 and jdbc 4.0?
Difference between JDBCs
multi tiered jdbc driver?
SQL statements
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 02:07:15.