File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC type 3 driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC type 3 driver" Watch "JDBC type 3 driver" New topic

JDBC type 3 driver

Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336

I am building a web application and I need a connection between the Model class and a MS Access database. I have tested it using JDBC DBC bridge for prototyping. However as my WAR file(containing the model class) is going to be placed on a remote server and my database on another machine, I need to install a type 3 driver. I am limited to using MS access. Any suggestions on how to use and install the driver?

I am planning to make an WAR file sitting on a webserver to talk to the Access DB. Using struts for the front end controller. Please correct me if my approach to the application is wrong.

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
I'm not sure what it needs to be a type 3 driver -which requires special software to be installed on the server-; I think a type 4 would be more appropriate. A list of possible drivers can be found here.
[ January 25, 2006: Message edited by: Ulf Dittmer ]
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336

I need some more help. If I need to call access my MS Access database from my model class placed in the WAR file, what parameters do I need to setup?
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
I read this article and it says that MS Access has no Type 4 drivers.

Does anyone have any experience in using a Type 3 driver?
Wei Dai
Ranch Hand

Joined: Jun 22, 2005
Posts: 86
Rmijdbc (free, type 3, )
HXTT Access(commercial, type 4, )

System Analyst
Ranch Hand

Joined: Oct 09, 2003
Posts: 517
Thank you very much Wei Dai

Rmijdbc worked ,thanks.

God Gave Me Nothing I Wanted<br />He Gave Me Everything I Needed<br /> - Swami Vivekananda
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 439
Well just as an after thought...

You may design your own type 3 driver....

Maki Jav

Help gets you when you need it!
I agree. Here's the link:
subject: JDBC type 3 driver
It's not a secret anymore!