Dear All, This is actually continuation of an earlier topic. I understand the jdbc.odbc driver shipping with the standard JDK from sun is really a poorman's tool. I am devloping a prototype for my Uni. project. The group involved wants this totally free of cost initially with all open source/free implemetations, as this is for private and not company use, as a way to learn stuff. Provided they like this, they might scale this up, with their bosses' permission. My question is, how do I present this in a way it will be accepted as a uni-project. Will using rmi-jdbc dress this up a bit, making it look professional? Is it possible to run RmiJdbc(remote database server to be used with MS-Access) along with Tomcat? Thanks!! [LIST]
Michael Brewer
Ranch Hand
Joined: Jun 27, 2002
Posts: 54
posted
0
Originally posted by bbkstud: Dear All, jdbc dress this up a bit, making it look professional? Is it possible to run RmiJdbc(remote database server to be used with MS-Access) along with Tomcat?
If you're just concerned about looking professional. Don't worry. Plenty of large, national financial institutions use MS Access. However, I would recommend PostgreSQL as your database of choice. It's ACID compliant and free.
bbkstud
Greenhorn
Joined: Jun 26, 2002
Posts: 4
posted
0
Hi, Thanks for the response. But do I need to use serialization to be thread safe? Can Access handle multiple transactions?Does Access allow simultaneous insert, update, delete?
"bbkstud", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp. We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements. Thanks. Dave
Bosun Bello
Ranch Hand
Joined: Nov 06, 2000
Posts: 1506
posted
0
bbkstud, I am assuming you meant synchronization. If you are concerned about simultaneous access to the DB, I would not use MS Access. It does not scale very well, if many users will be hitting it. You can also try mySQL at www.mysql.com
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Michael Brewer
Ranch Hand
Joined: Jun 27, 2002
Posts: 54
posted
0
Originally posted by bbkstud: Does Access allow simultaneous insert, update, delete?
I used to support Access 2000 for Microsoft, but I can't answer this question. Jet 4.0 (Access' DBMS) now allows for row-level locking which I would assume would allow for simultaneous inserts, updates, and deletes. Another consideration aside from PostgreSQL and mySQL would be MSDE. MSDE is the Microsoft Data Engine. It's free with MS Office (and may be a free download otherwise). It is SQL Server 7 without the visual tools and throttled to perform poorly with more than 10 users concurrently. What is your development platform? Windows 2000?
bbkstud
Greenhorn
Joined: Jun 26, 2002
Posts: 4
posted
0
Hi, Thank you very much. It is windows '98 and,(wait for it!!) office '95!! My proposer says he will give copies/install it on individual PCs to start off with. I guess I might have to do a version using Oracle at College!! Thanks a lot for your input and I might have to just stick to what the proposer guy says, staying away from concurrent transaction, cached rowset implementation et., etc.!! Thanks once again
0
[LIST] 
Jet 4.0 (Access' DBMS) now allows for row-level locking which I would assume would allow for simultaneous inserts, updates, and deletes. Another consideration aside from PostgreSQL and mySQL would be MSDE. MSDE is the Microsoft Data Engine. It's free with MS Office (and may be a free download otherwise). It is SQL Server 7 without the visual tools and throttled to perform poorly with more than 10 users concurrently.