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

JDBC type 3 driver

 
Zip Ped
Ranch Hand
Posts: 336
  • 0
  • 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
Pie
Posts: 42966
73
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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: 445
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic