server design pattern
Can any one help me in this question in java design pattern ? plz answer?
It is required to design and implement an application resource tier that creates and manages database connections on Oracle, sql server and Microsoft Access. It should be noted that both Oracle and SQL Server support operating under heavy concurrent requests, whereas Microsoft Access does not. Therefore, some sort of connection pooling should be supported by the Microsoft Access connection provider.
Connection properties (Data source, username, password, etc.) along with the type of required connection to create are stored in a properties file.
if any one know the required classes to implement it , plz answer me
If you are designing the code that talks to the different databases, then you definitely need some encapsulation. Design an interface, or borrow one of the provided interfaces, and then implement each class to talk to the appropriate database using said interface. If you need to do connection pooling, it may be convenient to check out the Singleton pattern for your database connections. It may also be in your best interest to load the drivers for each database using an abstract factory pattern.
Remember, the more abstract your design is, the easier it will be to roll out new features in the future. For example, suppose you need to start supporting MySQL in 6 months...
 |
No items matching your keywords were found.
Orbitra: MultiThreading (Part 1 of 3)
Related posts:
- design server design server Dedicated Servers Applications Website hosting is the...
- server design server design What Else Do You Know About Blade Servers...
Related posts brought to you by Yet Another Related Posts Plugin.