"Hewko, Doug" wrote:
>
> Hi! I would like to try the database example on the Cocoon2 default page. I
> have MS Access 2000 (standalone) installed. Where do I get an interpretter
> to communicate between my database and Cocoon2? I looked on Apache's Cocoon
> web site without any luck. I checked Microsoft but could find nothing to
> link to MS Access.
>
> Any other suggestions?
Please don't use MS Access.
Microsoft will never lift a finger to support Java--so none of their databases
will have a JDBC driver. The Cocoon website is not a place to find information
on drivers, so you are on your own to find a decent JDBC compliant driver for
MS Access.
There was also a recent discussion on this list regarding the JdbcOdbcBridge
driver that Sun provides in its JREs. You can't really use that for technical
reasons that I really don't want to get into right now.
Here is my experience with Access in general, and why you should never develop
with it for serious solutions:
* MS Access allows you to be lazy, and will keep working even when the database
is not set up correctly. This means when you plan to move the database to a
real RDBMS you will have to rework your database and ultimately your code.
* MS Access SQL is not standard--esp. concerning dates. If you access custom
code (aka modules) from Access SQL statements--you have to rewrite the query
when you migrate.
* MS Access table structure is to easy to manipulate. Many fledgling companies
think that this is an asset--as did mine before I joined. What this results
in is each developer with a slightly different schema and code that won't work
universally.
* MS Access has no security. Anyone can access the data and manipulate it. It's
so called security layer is easy to circumvent and only serves to lend a false
sense of security.
* MS Access cannot be centrally managed in an effective manner. It is true that
you can send out replicated databases--but in practice replecation has proven
to be both unweildy and still does not address central management of the database.
Central management is essential to web-based access.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
