Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting natively to db2,MSSql,oracle, and access

 
Abed Rabie
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
More of a JDBC question here than a Servlets question, so I am going to move this to the JDBC forum.

Mark
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you define 'natively'? It sounds like you're just looking for a type-4 driver for each database.
 
Abed Rabie
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 502
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic