When we think of Database Connectivity we come across something terms something as , ODBC , Database Drivers etc...soo wht are they?? why we use it?? how to choose . . .all questions comes in mind..! i wil try to explain those things in short ! belive me its not for PROFESSIONALS in these fields..jst for beginners..or newbies...soo if ur a professional pls dnt BLAME ME ! n dont thik its KIDY THINGS . . .newbie struggles to learn tat..!
First thing :
- Consider you have MS Access Database
- You as a programmer Coding ur application in JAVA
- JAVA application needs to be connected to MS Access database
- JAVA (SUN Microsystem) MS Access (Microsoft) JAVA --> JAVA API which cant directly connect to MS Access rt?? soo how to ??
- You must have Drivers installed which can connect to MS Access
- Now JAVA only provides 1 basic driver (JDBC - ODBC bridge)
- it means..Your Java application will use This JDBC ODBC Bridge driver to connect to ODBC driver which in turn wil connect to database
- java application --> JAPA APi -->JDBC ODBC Bridge --> ODBC Driver --> Database
- But JDBC ODBC has some limitations too in such cases...wht u wil do???
- soo insted of using JDBC ODBC driver u wil check for Drivers that wil directly connect to database insted of connectin to ODBC First...rt?
- So u need to contact ur Database Vendor to knw wheather u have JAVA supported drivers or not . . if they have then fine..install it and access database as :
- JAVA --> JAVA API --> DRIVERS -->Database ( now u hv direct access to database) No ODBC used here
- But if ur database vendor dnt provide drivers for JAVA except ODBC then??
- Then u wil go for Third Party Dricvers which u need to install on ur client machine as follows : Java App --> JAVA API --> (Third Party Drivers) --> Database
Java ----> JDBC ---> ODBC ---> Database
Java ----> JDBC ---> THIRD PARTY---> Database
But how to get third party drivers information : well for example....u need to search for thirdparty driver for JDBC then go to vendor website :
http://developers.sun.com/product/jdbc/drivers
This was jst a short introduction of Database Drivers ! i wil publish a file shortly in which u can get information about Database , its connectivity and Driver information n installation tips!
Thank You!
Happy Databasing!...
No comments:
Post a Comment