File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Type 1 - Type 4 driver

 
aakash bhatt
Ranch Hand
Posts: 182
  • 0
  • Mark post as helpful
  • send pies
  • 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.
 
rajesh godbole
Ranch Hand
Posts: 31
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
Sudharsan Govindarajan
Ranch Hand
Posts: 319
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic