The database client software installed with all the developer computers.


one server connect to any n number of clients......


Service name with nothing but the assigned to database server.
Port number is unique communications channel every programmer users one port number.

Instead of oracle client software we are developing the java (programmer) application which interacts with database server.



                                                                                Java application

We using java application instead of oracle client program this is because by using oracle client program. If we want to request the server the client is suppose to type the SQL queries and sent the request to the server. But we when the use a java application to send to request to the server. User we need to generate SQL queries. When the user interacts which GUI and the client on the button the java application generate the queries and send to server.
A ‘C’ program’s would like communicate with database server. If two programs would like communicate each other they must use same protocol. If they use different protocol they will not communicate each other.

Oracle database server is developing based on thin protocol. Thin protocol proprietary to Oracle database server.

If we would like to develop a ‘C’ program to communicate with database server. The ‘C’
Program has to send the request by using thin protocol. But Oracle guys are not ready to release thin protocol to out side market.




0 comments:

Post a Comment