<div>
What is the context - a web application? You can, btw, create a DSN-less connection
</div>


What is the context - a web application? You can, btw, create a DSN-less connection

<div>
A standalone Java application. 
</div>


<div>
Gotta go now. Will look at these tomorrow and try them. Hopefully they will help me in addressing this problem.<br />
<br />

</div>


Gotta go now. Will look at these tomorrow and try them. Hopefully they will help me in addressing this problem.



<div>
Why to reinvent the wheel?<br />
Use Hibernate instead: <a href="http://www.hibernate.org/" rel="ugc">http://www.hibernate.org/</a><br />

</div>


Why to reinvent the wheel?
Use Hibernate instead: http://www.hibernate.org/ [http://www.hibernate.org/]


<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
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. <br />
<br />
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. <br />
<br />
1. I need to know which drivers should I use &nbsp;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.<br />
2. Are these free drivers?<br />
3. I have never written a complete DB layer. What are the essential methods this should have?<br />
<br />
Depending on the answers I'll post further queries.<br />
<br />
Regards<br />
Ajay<br />

</div>
</div>


Hi All

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.

Regards
Ajay


Database connection layer in java

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.