I need to write a database connection layer using java and jdbc. It should be able to connect to various databases including oracle, db2, sql server.
I have been able to write a small class using jdbc-odbc bridge drivers. But these drivers requires end user to create a DSN on their machine.
1. I need to know which drivers should I use so that end users do not need to create DSN. they will just provide necessary DB information to my class and class will take care of everything.
2. Are these free drivers?
3. I have never written a complete DB layer. What are the essential methods this should have?
Depending on the answers I'll post further queries.