You are viewing a plain text version of this content. The canonical link for it is here.
Posted to docs@cocoon.apache.org by do...@cocoon.apache.org on 2004/07/09 13:23:45 UTC
[Cocoon Wiki] Updated: SpecificDatabaseConnectionNew
Date: 2004-07-09T04:23:45
Editor: DerekLastname <dh...@csir.co.za>
Wiki: Cocoon Wiki
Page: SpecificDatabaseConnectionNew
URL: http://wiki.apache.org/cocoon/SpecificDatabaseConnectionNew
no comment
Change Log:
------------------------------------------------------------------------------
@@ -2,12 +2,13 @@
* a different site where you can download the appropriate jdbc drivers
* a different invocation of the class to load in web.xml file
* a different connection string
- * some little differences you have to keep into count
+ * some little differences you have to take into account
The instructions on how to set up a connection pool in general on a database can be found in the [http://xml.apache.org/cocoon/developing/datasources.html official documentation ] or in this [http://outerthought.net/wiki/Wiki.jsp?page=ConnectionPooling good article ].[[BR]]
-Here is a table of the specificity me and others have found in connecting Cocoon to different databases
+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 '''|||| notes
||[:MySQL] || [http://www.mysql.com/downloads/api-jdbc-stable.html here ] || com.mysql.jdbc.Driver || jdbc:mysql://!YourHostName:3306/!YourDatabaseName?autoReconnect=true ||
-||[:postgreSQL] || [http://jdbc.postgresql.org/download.html here ] || org.postgresql.Driver || jdbc:postgresql://!YourServerName:5432/DB_Name ||
+||[:PostgreSQL] || [http://jdbc.postgresql.org/download.html] here || org.postgresql.Driver || jdbc:postgresql://!YourServerName:5432/DB_Name ||
|| [:Oracle] || [http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html here ] || oracle.jdbc.driver.!OracleDriver || jdbc:oracle:thin:@!YourServerName:1521:Istance_Name || some Oracle are db spcific like autocommit or oradb
||[:MsSQL] || [http://www.microsoft.com/sql/default.asp here ] || com.microsoft.jdbc.sqlserver.SQL!ServerDriver || jdbc:microsoft:sqlserver://!YourServerName:1433;!DatabaseName=!YourDatabaseName||
|| [:As400] || [http://oss.software.ibm.com/developerworks/opensource/jt400/ jtopen project ] ||com.ibm.as400.access.AS400JDBCDriver|| jdbc:as400://!YourServerName || There is an As400 about the version of jdk
@@ -19,11 +20,11 @@
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&characterEncoding=ISO-8859-7</dburl>
- <user>database_user</user>
- <password>database_password</password>
- </jdbc>
+{{{
+ <jdbc name="pool_name">
+ <pool-controller min="5" max="10"/>
+ <dburl>jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&characterEncoding=ISO-8859-7</dburl>
+ <user>database_user</user>
+ <password>database_password</password>
+ </jdbc>
}}}