• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC type 3 driver

 
Zip Ped
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 517
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much Wei Dai

Rmijdbc worked ,thanks.
 
Maki Jav
Ranch Hand
Posts: 447
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic