Date: 2004-07-09T04:25:30 Editor: DerekLastname <[EMAIL PROTECTED]> Wiki: Cocoon Wiki Page: SpecificDatabaseConnectionNew URL: http://wiki.apache.org/cocoon/SpecificDatabaseConnectionNew
no comment Change Log: ------------------------------------------------------------------------------ @@ -6,12 +6,12 @@ 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 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 +||'''Database'''||''' jdbc drivers' site '''||''' class to load in web.xml '''||''' Connection string '''|| ||[: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 || -|| [: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 +|| [:Oracle] || [http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html here ] || oracle.jdbc.driver.!OracleDriver || jdbc:oracle:thin:@!YourServerName:1521:Instance_Name || ||[: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 +|| [:As400] || [http://oss.software.ibm.com/developerworks/opensource/jt400/ jtopen project ] ||com.ibm.as400.access.AS400JDBCDriver|| jdbc:as400://!YourServerName || || BasisPlus || [http://www.opentext.com/ OpenText ] || com.opentext.basis.jdbc.!BasisDriver || jdbc:opentext:basis://dbUser:[EMAIL PROTECTED]:2033/dbName|| == Encoding tips ==
