cocoon-docs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Cocoon Wiki] Update of "SpecificDatabaseConnectionNew" by AntonioGallardo
Date Fri, 05 Aug 2005 01:58:25 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Cocoon Wiki" for change notification.

The following page has been changed by AntonioGallardo:
http://wiki.apache.org/cocoon/SpecificDatabaseConnectionNew

The comment on the change is:
formatting code

------------------------------------------------------------------------------
  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] || [http://www.mysql.com/downloads/api-jdbc-stable.html] here || com.mysql.jdbc.Driver
|| jdbc:mysql://!YourHostName:3306/!YourDatabaseName?autoReconnect=true ||
+ ||[: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:Instance_Name ||

+ ||[: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 ||
+ ||[: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 || 
+ ||[: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:dbPassword@dbServer:2033/dbName ||
  
  == Encoding tips ==
@@ -23, +23 @@

  {{{jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&amp;characterEncoding=YourEncoding}}}
  for example: (cocoon.xconf)
  {{{
- 		<jdbc name="pool_name">
+   <jdbc name="pool_name">
- 			<pool-controller min="5" max="10"/>
+     <pool-controller min="5" max="10"/>
- 			<dburl>jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&amp;characterEncoding=ISO-8859-7</dburl>
+     <dburl>jdbc:mysql://YourHostName:3360/YourDataBaseName?useUnicode=true&amp;characterEncoding=ISO-8859-7</dburl>
- 			<user>database_user</user>
+     <user>database_user</user>
- 			<password>database_password</password>
+     <password>database_password</password>
- 		</jdbc>
+   </jdbc>
  }}}
  

Mime
View raw message