Each database to which Cocoon connect has:

The instructions on how to set up a connection pool in general on a database can be found in the official documentation or in this good article.
Here is a table of the specificity that I and others have found, in connecting Cocoon to different databases:

Database

jdbc drivers' site

class to load in web.xml

Connection string

MySQL

here

com.mysql.jdbc.Driver

jdbc:mysql://!YourHostName:3306/!YourDatabaseName?autoReconnect=true

PostgreSQL

here

org.postgresql.Driver

jdbc:postgresql://!YourServerName:5432/DB_Name

Oracle

here

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@YourServerName:1521:Instance_Name

MsSQL

here

com.microsoft.jdbc.sqlserver.SQL!ServerDriver

jdbc:microsoft:sqlserver://!YourServerName:1433;DatabaseName=YourDatabaseName

As400

jtopen project

com.ibm.as400.access.AS400JDBCDriver

jdbc:as400://!YourServerName

BasisPlus

OpenText

com.opentext.basis.jdbc.BasisDriver

jdbc:opentext:basis://dbUser:dbPassword@dbServer:2033/dbName

Encoding tips

mySQL

If we want to use non-latin characters in mySQL, Greek for example, we need to have a more specific connection string: jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&characterEncoding=YourEncoding for example: (cocoon.xconf)

  <jdbc name="pool_name">
    <pool-controller min="5" max="10"/>
    <dburl>jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&amp;characterEncoding=ISO-8859-7</dburl>
    <user>database_user</user>
    <password>database_password</password>
  </jdbc>

SpecificDatabaseConnectionNew (last edited 2009-09-20 23:40:08 by localhost)