I am trying to prepare my middle ware independent from the User Interface technology and DBMS used in the back end. that means a middle ware code which has the business logic and works for Web applications , swing applications and so on...
but Here from the Web application and Rich cleint and fat client applications ... the database connections are different .
So I want your suggestions how to Generalize and handle my database connection/s (connection pools) which works for all types of applications and to fix the places where I have to change if my database changes or my application type changes.
and I want to make the places as less as possible where I am depending on the applcaition specific technology.
so I am searching examples for Swing applications and we applications , how the database connections are handled.
Please try to give practical examples where I can learn the standards of dealing with Database connections and what to change if I change from web application to swing and one database to another ...
thanking you in advance.