File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connecting natively to db2,MSSql,oracle, and access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting natively to db2,MSSql,oracle, and access" Watch "Connecting natively to db2,MSSql,oracle, and access" New topic
Author

Connecting natively to db2,MSSql,oracle, and access

Abed Rabie
Ranch Hand

Joined: Jun 24, 2003
Posts: 74
Dear all,

Did anyone know the way to connect to those different databases natively (db2,MSSql,oracle, and access).

Thanks alot for your help

best regards

Aabed


Abed Rabie
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

More of a JDBC question here than a Servlets question, so I am going to move this to the JDBC forum.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Can you define 'natively'? It sounds like you're just looking for a type-4 driver for each database.
Abed Rabie
Ranch Hand

Joined: Jun 24, 2003
Posts: 74
I mean, I'd like to connect to each one without using the odbc of the system. I want to connect to the database directly without using the odbc.

Hope you get my point

Thanks and best regards

Aabed
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

You only connect to the database using ODBC if you use the Type-1 driver also known as the jdbc-odbc bridge. Types 2 and 3 are a mixture (you can search the forum for a more complete definition), but Type-4 drivers are Java libraries usually developped by the database vendor which allows Java code to talk directly to the database ie no ODBC, no client-side installations, all Java and the Database.

Dave
Jayesh Lalwani
Ranch Hand

Joined: Nov 05, 2004
Posts: 502
I think if you want your application to talk directly o the database without JDBC or ODBC, you will have to search for documentation of each of those databases

But why would you want to do that? Are you trying to use something specific that is available in the vendor's native API? Or are you trying to do regular database access? Most major database vendors supply their own JDBC drivers, and I guess a JDBC driver implemented by the database vendor would be much more efficient than anything that I can come up with
Abed Rabie
Ranch Hand

Joined: Jun 24, 2003
Posts: 74
Dear Jayesh Lalwani,

So can you help me to know the native driver for each of those databases.

Thanks again for help

Best regards

Aabed
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting natively to db2,MSSql,oracle, and access