• 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
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

Type 1 - Type 4 driver

 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In my application my backend databse is Oracle 8 and webserver is Tomcat
So if use Type 1 Driver JDBC ODBC then should I had to install Oracle 8 client in my Tomcat machine
or if i use Type 4 Pure Java driver then to should I had to install Oracle 8 client.
Regards,
aakash.
 
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Aakash,
I will try to explain what can be done at your end..
Type 1 JDBC drivers use ODBC to get connected to the database. Since it uses ODBC driver your installation has to be on Microsoft platform. If tomcat is installed on win2k machine then just create a DSN pointing to the Database server and that will take care of all things. But this approach is used only in the development scenario.
If the installation is on non-Microsoft platform then you will need to use Type 3 or Type 4 JDBC driver. Type 4 drivers are native net drives and use direct connection to the database.
So while connecting to database use net driver and in the database url, mention the database name and port. I am not very much confident about driver 3 but I think that, the application server takes care of getting connected to database.
Hope this helps.
Rajesh
 
Ranch Hand
Posts: 319
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In both the cases, you need not install Oracle 8 Client in your tomcat machine. Using a Type 4 driver would be a better approach though.
sudharsan
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic