in the cocoon.xconf I have come across the following code and wondered if this needed to be amended for mySQL:
<!--..... Start configuration from 'db-modules' -->
<!-- =============== Database Modules ==================== -->
<autoincrement-modules>
<component-instance class="org.apache.cocoon.components.modules.database.HsqlIdentityAutoInc rementModule" logger="core.modules.auto" name="auto"/>
<!--
Choose the one suitable for your DBMS. You *can* have more than
one at a time, but they need to have different names. You then
need to specify explicitly, which one to use in your descriptor
file.
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.ManualAutoIncrement Module"/>
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.IfxSerialAutoIncrem entModule"/>
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.McKoiSequenceModule "/>
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.MysqlAutoIncrementM odule"/>
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.PgsqlAutoIncrementM odule"/>
<component-instance logger="core.modules.auto" name="auto" class="org.apache.cocoon.components.modules.database.SQLServerIdentityAu toIncrementModule"/>
-->
</autoincrement-modules>
<!--..... End configuration from 'db-modules' -->
<!--..... Start configuration from 'hsqldb' -->
<!--+
| HSQLDB Server for samples:
|
| port : number port where the server is listening
| silent : true/false display all queries
| trace : true/false display JDBC trace messages
+-->
<hsqldb-server class="org.apache.cocoon.components.hsqldb.ServerImpl" logger="core.hsqldb-server" pool-max="1" pool-min="1">
<parameter name="port" value="9002"/>
<parameter name="silent" value="true"/>
<parameter name="trace" value="false"/>
</hsqldb-server>
<!--..... End configuration from 'hsqldb' -->
regards
Uzo On 28 Dec 2003, at 13:39, beyaRecords - The home Urban music wrote:
Luca, as requested, here is my sitemap snippet:
<map:match pattern="tickets"> <map:generate type="serverpages" src="xsp/tickets.xsp"/> <map:transform type="xslt" src="style/main.xsl"/> <map:serialize type="html"/> </map:match>
regards
Uzo On 28 Dec 2003, at 12:30, Luca Morandini wrote:
Hi,
I am having an issue connecting to a MySQL database. Basically, any esql tags with data between them is being written to the screen instead of being processed and no connection to the database is being made. For example instead of <esql:pool>mysql</esql:pool> being processed, 'mysql' is being printed to the screen. What am i not doing correctly? The process I followed to try and ensure database connectivity was this:
<cut/>
Could you please post the relevant sitemap fragment as well ?
Regards,
----------------------------------- Luca Morandini - GIS Consultant [EMAIL PROTECTED] http://xoomer.virgilio.it/ukmorand/ -----------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
