• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting natively to db2,MSSql,oracle, and access

 
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 502
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic