Page: http://wiki.cocoondev.org/Wiki.jsp?page=MySQL, version: 7 on Thu Feb 6
10:01:46 2003 by DerekH
- This document explains the specific aspect of connecting Cocoon to a MySQL
Database.\\
?
--
+ This document explains the specific aspects of connecting Cocoon to a MySQL
Database.
? +
- For a general explanation on database connection please refer to the
[official documentation |
http://xml.apache.org/cocoon/developing/datasources.html].
- !!Downloading the jdbc drivers
- The jdbc drivers can be downloaded [here |
http://www.mysql.com/downloads/api-jdbc-stable.html].
- They are an update of the popular 'Mark Matthews' driver. (See later)\\
- Expand the zip or tar and locate the jar file
mysql-connector-java-2.0.14-bin.jar.\\
- Put this in either $COCOON_HOME/web-inf/lib or $TOMCAT_HOME/common/lib/.\\
- If you're using the 'Mark Matthews' driver, the jar file is called something
like mm.mysql-2.0.14-bin.jar
- !!Setting Web.xml
+ For a general explanation on database connections please refer to the
[official Cocoon documentation |
http://xml.apache.org/cocoon/developing/datasources.html].
+
+ !!Installing the JDBC drivers
+
+ * The JDBC drivers can be downloaded from the [mySQL.com |
http://www.mysql.com/downloads/api-jdbc-stable.html] website. (They are an
update of the popular 'Mark Matthews' driver. (See later)\\
+ * Expand the zip or tar file and locate the jar file
{{mysql-connector-java-2.0.14-bin.jar}} (if you're using the 'Mark Matthews'
driver, the jar file is called something like mm.mysql-2.0.14-bin.jar)
+ * Copy this file into either $COCOON_HOME/web-inf/lib or
$TOMCAT_HOME/common/lib/
+
+ !!Setting the web.xml configuration
+
- !!Setting cocoon.xconf
+ !!Setting the cocoon.xconf configuration
+
- search for:
? ^
+ Search for:
? ^
- The ?autoReconnect=true tip is cribbed from the tomcat JNDI datasource HOWTO
[here |
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html]
to get round the fact that MySQL by default drops connections that have been
idle for 8 hours
? ^
------
+ The ?autoReconnect=true tip is cribbed from the [Tomcat JNDI datasource HOWTO
|
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html]
to get around the fact that MySQL by default drops connections that have been
idle for 8 hours
? ^^
+
- !!Setting sitemap.xmap
+
+ !!Setting the sitemap.xmap configuration
+
- When you want to use the connection you just call the jdbc name inside the
pipeline in this way:
? ^^^^
+ When you want to use the connection you just call the JDBC name inside the
pipeline in this way:
? ^^^^
Page: http://wiki.cocoondev.org/Wiki.jsp?page=SpecificDatabaseConnection,
version: 25 on Thu Feb 6 10:05:48 2003 by DerekH
+
- Here you will find the operations and the tricks to connect Cocoon to
__your__ database.\\
?
--
+ Here you will find the operations and the tricks to connect Cocoon to
__your__ database.
+
- In the official documentation there are no informations about where to find
the jdbc driver or the specific class to load. This document's aim is to fill
that gap.
? ^^^ -
+ In the official documentation there is no information about where to find the
[JDBC|http://java.sun.com/products/jdbc/] driver or the specific class to load.
This document's aim is to fill that gap.
? ^^
+++++++++++++++++++++++++++++++++++ ++
- For complete instructions please refer to the official documentation on
[database access | http://xml.apache.org/cocoon/developing/datasources.html].\\
?
--
+ For complete instructions please refer to the official documentation on
[database access | http://xml.apache.org/cocoon/developing/datasources.html].
+
- If your database is not listed and you have succeded in connecting please
contribute to this page.\\
?
^^
+ If your database is not listed and you have succeded in connecting please
contribute to this page.-- [Gabridome]
?
^^^^^^^^^^^^^^
- -- [Gabridome]
+
- I would be very interested to hear whether anyone has attempted to use Cocoon
with Apache Torque which is a Object->relational tool used in Apache Turbine.
This would save a lot of ugly ESQL code.... if it was used. [AlexMcLintock]\\
+ ''I would be very interested to hear whether anyone has attempted to use
Cocoon with Apache Torque which is a Object->relational tool used in Apache
Turbine. This would save a lot of ugly ESQL code.... if it was used.'' --
[AlexMcLintock]\\
? ++
+++++
