Return-Path: 
 <docs-return-6613-apmail-cocoon-docs-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-docs-archive@www.apache.org
Received: (qmail 53979 invoked from network); 20 Jun 2005 13:36:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 20 Jun 2005 13:36:10 -0000
Received: (qmail 48649 invoked by uid 500); 20 Jun 2005 13:36:09 -0000
Delivered-To: apmail-cocoon-docs-archive@cocoon.apache.org
Received: (qmail 48617 invoked by uid 500); 20 Jun 2005 13:36:09 -0000
Mailing-List: contact docs-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:docs-help@cocoon.apache.org>
list-unsubscribe: <mailto:docs-unsubscribe@cocoon.apache.org>
List-Post: <mailto:docs@cocoon.apache.org>
Reply-To: docs@cocoon.apache.org
List-Id: <docs.cocoon.apache.org>
Delivered-To: mailing list docs@cocoon.apache.org
Received: (qmail 48603 invoked by uid 99); 20 Jun 2005 13:36:08 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received: from ajax-1.apache.org (HELO ajax.apache.org) (192.87.106.226)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jun 2005 06:36:02 -0700
Received: from ajax.apache.org (ajax.apache.org [127.0.0.1])
	by ajax.apache.org (Postfix) with ESMTP id 944FAE6
	for <docs@cocoon.apache.org>; Mon, 20 Jun 2005 15:35:19 +0200 (CEST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
From: Apache Wiki <wikidiffs@apache.org>
To: docs@cocoon.apache.org
Date: Mon, 20 Jun 2005 13:35:19 -0000
Message-ID: <20050620133519.15604.2731@ajax.apache.org>
Subject: [Cocoon Wiki] Update of "Access" by JosephPecore
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Cocoon Wiki" for change notification.

The following page has been changed by JosephPecore:
http://wiki.apache.org/cocoon/Access

New page:
= Connection to Microsoft Access (via odbc) =
This document explains the specific aspects of connecting Cocoon to a Microsoft Access Database via odbc. 
This should work with any odbc compliant data source.

For a general explanation on database connections please refer to the [http://cocoon.apache.org/2.1/developing/datasources.html official Cocoon documentation ].

== Installing the JDBC drivers ==

 *  odbc is part of JDK, so you don't need to install anything.

== Setting the web.xml configuration ==

In the $COCOON_LIB/WEB-INF/ directory you will find the web.xml file. Open it and look for this rows {{{
<init-param>
  <param-name>load-class</param-name> 
    <param-value>
         }}}
here you have to add the following line:
{{{
<!-- For ODBC: -->
         sun.jdbc.odbc.JdbcOdbcDriver

}}}

== Setting the cocoon.xconf configuration ==

Search for:
{{{<datasources>}}}
add into this element these lines:
{{{
  <jdbc name="YourPoolName">
    <pool-controller min="5" max="10"/>
    <dburl>jdbc:odbc:YourODBCSourceName</dburl>
    <user>YourUsername</user>
    <password>YourPassword</password>
  </jdbc>
}}}


== Setting the sitemap.xmap configuration ==

When you want to use the connection with the SQLTransformer you just call the JDBC name inside the pipeline in this way:
{{{
<map:match pattern="sqlquery">
  <map:generate src="sql/sqlquery.xml"/>
  <map:transform type="sql">
    <map:parameter name="use-connection" value="YourPoolName"/>
  </map:transform>
  <map:transform type="xslt" src="../stylesheets/transformation.xslt"/>
  <map:serialize />
</map:match>
}}}
Obviously you have to adapt this sample to fill your need.[[BR]]
SpecificDatabaseConnection

== Setting up ODBC Source
Windows:
a. Start > Settings > Control Panel > Administrative Tools > Data sources (ODBC)
b. Select the tab labeled ‘System DSN’   (I tried User DSN, but it did not work!)
c. Click ‘Add’
d. Select the type of data source you want to create, e.g. Microsoft Access Driver
e. Supply a name for the data source (This needs to match the YourODBCSourceName cocoon.xconf!
f. The ‘description’ is optional
g. Click the ‘Select’ button under ‘Database’ to bring-up a file browse dialog
h. Use the dialog to select the database file 

== Comments from the readers ==