File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Type 3 vs Type 4 Drivers

 
Aleena Rehman
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear JDBC Gurus,

Can somebody please explain what are the benefits of Type-3 driver over Type-4 driver ? I was having a discussion with one of our customers and he was considering the gateway(MiddleWare) in Type-3 as an additional layer of security, as clients donot talk directly to the db server ?

I am looking for some counter argument and if possible some reference material that can help ?

[edited out e-mail: ]http://faq.javaranch.com/view?UseTheForumNotEmail]
[ February 11, 2007: Message edited by: Jeanne Boyarsky ]
 
Scott Selikoff
author
Saloon Keeper
Posts: 3889
15
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With the risk of being flamed, I find Wikipedia has a decent discussion of the driver levels: http://en.wikipedia.org/wiki/JDBC_type_3_driver

I tend to not worry about the level unless there's a problem with a specific driver. All and all I think the only database it mattered was with oracle and the performance differences were almost non-existent.
 
Aleena Rehman
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Scott,
Thanks for your response, however it probably does not answer my question. I have already gone through Wikipedia's definition of Type-3, but my question is weather type-3 is more/less secure. Does it in any way affect security ?

Regards,
 
Philip Shanks
Ranch Hand
Posts: 189
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see little difference from a security perspective. The primary difference is whether the generic JDBC call is translated to the vendor specific call on the client or on the server. The client, server and data stream are all equally vulnerable in either case.

I think that the layered security approach will be the same regardless of which JDBC driver type is chosen. You will want to limit which clients the DB server will accept connections from, use encrypted connections wherever possible, adequate authentication and strong access policies.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic