cocoon-docs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d...@cocoon.apache.org
Subject [Cocoon Wiki] Updated: SpecificDatabaseConnectionNew
Date Fri, 09 Jul 2004 11:23:45 GMT
   Date: 2004-07-09T04:23:45
   Editor: DerekLastname <dhohls@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&amp;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>
+{{{
+		<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>
 }}}

Mime
View raw message