Date: 2004-07-09T04:23:45 Editor: DerekLastname <[EMAIL PROTECTED]> 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> }}}
