aspose file tools*
The moose likes JDBC and the fly likes JDBC type 3 driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC type 3 driver" Watch "JDBC type 3 driver" New topic
Author

JDBC type 3 driver

Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
Hi,

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.


Thanks,
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41573
    
  54
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 ]

Ping & DNS - my free Android networking tools app
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
Ok.

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.

http://techrepublic.com.com/5100-6329-5195935.html

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, http://rmijdbc.objectweb.org/Access/access.html )
Or
HXTT Access(commercial, type 4, http://www.hxtt.com/access.html )

Daiwei
System Analyst
www.hxtt.com
MInu
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: 435
Well just as an after thought...

You may design your own type 3 driver....
http://www.javaworld.com/javaworld/jw-05-2002/jw-0517-jdbcdriver.html


Maki Jav


Help gets you when you need it!
 
Consider Paul's rocket mass heater.
 
subject: JDBC type 3 driver