You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by bu...@apache.org on 2012/11/03 16:55:43 UTC
svn commit: r837155 - in /websites/staging/cayenne/trunk/content: ./
database-support.html why-cayenne.html
Author: buildbot
Date: Sat Nov 3 15:55:42 2012
New Revision: 837155
Log:
Staging update by buildbot for cayenne
Added:
websites/staging/cayenne/trunk/content/database-support.html
Modified:
websites/staging/cayenne/trunk/content/ (props changed)
websites/staging/cayenne/trunk/content/why-cayenne.html
Propchange: websites/staging/cayenne/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Sat Nov 3 15:55:42 2012
@@ -1 +1 @@
-1405360
+1405372
Added: websites/staging/cayenne/trunk/content/database-support.html
==============================================================================
--- websites/staging/cayenne/trunk/content/database-support.html (added)
+++ websites/staging/cayenne/trunk/content/database-support.html Sat Nov 3 15:55:42 2012
@@ -0,0 +1,200 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
+<html lang="en">
+<head>
+<title>Apache Cayenne » Database Support</title>
+<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
+<meta name="description" content="Apache Cayenne is a powerful, full-featured, open-source object relational mapping framework created for developers working with relational databases.">
+<meta name="robots" content="index,follow">
+<link rel="stylesheet" type="text/css" media="screen, projection" href="/css/styles.css">
+<link rel="stylesheet" type="text/css" media="print" href="/css/print.css">
+<link rel="shortcut icon" href="/img/favicon.ico" type="image/ico">
+<script type="text/javascript" src="/js/scripts.js"></script>
+</head>
+<body>
+<div id="wrap"><div id="wrap-inner">
+
+<div id="header">
+ <h1><a href="/" title="Return to Apache Cayenne home"><span>The Apache Cayenne Project</span></a></h1>
+ <h2><a href="http://www.apache.org" title="The Apache Software Foundation"><span>The Apache Software Foundation</span></a></h2>
+</div>
+
+<div id="container">
+
+
+<div id="sidebar">
+<ul id="nav">
+ <li><a href="/about.html">About</a>
+ <ul>
+ <li><a href="/why-cayenne.html">Why Cayenne?</a></li>
+ <li><a href="/download.html">Download</a></li>
+ <li><a href="/success-stories.html">Success Stories</a></li>
+ <li><a href="/support.html">Support</a></li>
+ </ul>
+ </li>
+ <li><a href="/documentation.html">Documentation</a>
+ <ul>
+ <li><a href="/doc30/tutorial.html">Getting Started</a></li>
+ <li class="trigger"><a href="/doc30/documentation.html">Version 3 (released)</a>
+ <ul>
+ <li><a href="/doc30/overview.html">Overview</a></li>
+ <li><a href="/doc30/cayenne-guide.html">Cayenne Guide</a></li>
+ <li><a href="/doc30/remote-object-persistence-guide.html">Remote Client Guide</a></li>
+ <li><a href="/doc30/modeler-guide.html">Modeler Guide</a></li>
+ <li><a href="/doc30/api/index.html">JavaDoc</a></li>
+ </ul>
+ </li>
+ <li class="trigger"><a href="/doc20/documentation.html">Version 2 (released)</a>
+ <ul>
+ <li><a href="/doc20/user-guide.html">User Guide</a></li>
+ <li><a href="/doc20/remote-object-persistence-guide.html">Remote Client Guide</a></li>
+ <li><a href="/doc20/modeler-guide.html">Modeler Guide</a></li>
+ <li><a href="/doc20/api/cayenne/index.html">JavaDoc</a></li>
+ </ul>
+ </li>
+ <li class="trigger"><a href="/doc12/documentation.html">Version 1.2 (archived)</a>
+ <ul>
+ <li><a href="/doc12/user-guide.html">User Guide</a></li>
+ <li><a href="/doc12/remote-object-persistence-guide.html">Remote Client Guide</a></li>
+ <li><a href="/doc12/modeler-guide.html">Modeler Guide</a></li>
+ <li><a href="/doc12/api/cayenne/index.html">JavaDoc</a></li>
+ </ul>
+ </li>
+ </ul>
+ </li>
+ <li><a href="/collaboration.html">Collaboration</a>
+ <ul>
+ <li><a href="http://issues.apache.org/jira/browse/CAY">Bug/Feature Tracker</a></li>
+ <li><a href="/mailing-lists.html">Mailing Lists</a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/CAY/Index">Wiki</a></li>
+ <li><a href="/code-repository.html">Code Repository</a></li>
+ <li><a href="/developer-guide.html">Developer Guide</a></li>
+ <li><a href="/how-can-i-help.html">How Can I Help?</a></li>
+ <li><a href="/contributors.html">Contributors</a></li>
+ </ul>
+ </li>
+</ul>
+</div>
+
+
+<hr>
+<div id="content">
+ <h2 id="database-support">Database Support</h2>
+<p>This page provides useful information about JDBC driver settings for various database. All databases below have custom Cayenne DbAdapters and are automatically recognized by Cayenne AutoAdapter.</p>
+<table>
+<thead>
+<tr>
+<th>Database</th>
+<th>Driver Name</th>
+<th>Sample URL</th>
+</tr>
+</thead>
+<tbody>
+<tr>
+<td>DB2</td>
+<td>com.ibm.db2.jcc.DB2Driver</td>
+<td>jdbc:db2://127.0.0.1:50000/dbname</td>
+</tr>
+<tr>
+<td>Derby</td>
+<td>org.apache.derby.jdbc.ClientDriver</td>
+<td>jdbc:derby://127.0.0.1/testdb</td>
+</tr>
+<tr>
+<td></td>
+<td>org.apache.derby.jdbc.EmbeddedDriver</td>
+<td>jdbc:derby:path-to-hsql-db-files;create=true</td>
+</tr>
+<tr>
+<td>FrontBase</td>
+<td>jdbc.FrontBase.FBJDriver</td>
+<td>jdbc:FrontBase://127.0.0.1/dbname</td>
+</tr>
+<tr>
+<td>HSQLDB</td>
+<td>org.hsqldb.jdbcDriver</td>
+<td>jdbc:hsqldb:hsql://127.0.0.1</td>
+</tr>
+<tr>
+<td></td>
+<td>jdbc:hsqldb:</td>
+<td>file:/path-to-hsql-db-files</td>
+</tr>
+<tr>
+<td>H2</td>
+<td>org.h2.Driver</td>
+<td>jdbc:h2:mem:myTestMem;MVCC=TRUE</td>
+</tr>
+<tr>
+<td>Ingres</td>
+<td>com.ingres.jdbc.IngresDriver</td>
+<td>jdbc:ingres://127.0.0.1:II7/dbname</td>
+</tr>
+<tr>
+<td>MySQL</td>
+<td>com.mysql.jdbc.Driver</td>
+<td>jdbc:mysql://127.0.0.1/dbname</td>
+</tr>
+<tr>
+<td>OpenBase</td>
+<td>com.openbase.jdbc.ObDriver</td>
+<td>jdbc:openbase://127.0.0.1/dbname</td>
+</tr>
+<tr>
+<td>Oracle (11, 10, 9, 8i, 8)</td>
+<td>oracle.jdbc.driver.OracleDriver</td>
+<td>jdbc:oracle:thin:@//127.0.0.1:1521/dbname</td>
+</tr>
+<tr>
+<td>PostgreSQL (7,8,9)</td>
+<td>org.postgresql.Driver</td>
+<td>jdbc:postgresql://127.0.0.1:5432/dbname</td>
+</tr>
+<tr>
+<td>SQLite 3.*</td>
+<td>org.sqlite.JDBC</td>
+<td>jdbc:sqlite:path_to_dbfile</td>
+</tr>
+<tr>
+<td>SQLServer</td>
+<td>com.microsoft.sqlserver.jdbc.SQLServerDriver</td>
+<td>jdbc:sqlserver://127.0.0.1;databaseName=dbname</td>
+</tr>
+<tr>
+<td></td>
+<td>com.microsoft.jdbc.sqlserver.SQLServerDriver</td>
+<td>jdbc:microsoft:sqlserver://127.0.0.1;databaseName=dbname;SelectMethod=cursor</td>
+</tr>
+<tr>
+<td></td>
+<td>net.sourceforge.jtds.jdbc.Driver</td>
+<td>jdbc:jtds:sqlserver://127.0.0.1:5000/dbname</td>
+</tr>
+<tr>
+<td>Sybase</td>
+<td>com.sybase.jdbc3.jdbc.SybDriver</td>
+<td>jdbc:sybase:Tds:127.0.0.1:5000/dbname</td>
+</tr>
+<tr>
+<td></td>
+<td>net.sourceforge.jtds.jdbc.Driver</td>
+<td>jdbc:jtds:sybase://127.0.0.1:5000/dbname;useLOBs=false;TDS=4.2</td>
+</tr>
+</tbody>
+</table>
+ <hr>
+ <p id="footer">Copyright © 2001-2012 Apache Software Foundation. Apache Cayenne, Cayenne, Apache, the Apache feather logo, and the Apache Cayenne project logo are trademarks of The Apache Software Foundation. <a href="/privacy-policy.html">Privacy policy</a>.
+</div>
+</div>
+
+</div></div>
+<script type="text/javascript">
+var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
+document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
+</script>
+<script type="text/javascript">
+try {
+var pageTracker = _gat._getTracker("UA-7036673-1");
+pageTracker._trackPageview();
+} catch(err) {}</script>
+</body>
+</html>
Modified: websites/staging/cayenne/trunk/content/why-cayenne.html
==============================================================================
--- websites/staging/cayenne/trunk/content/why-cayenne.html (original)
+++ websites/staging/cayenne/trunk/content/why-cayenne.html Sat Nov 3 15:55:42 2012
@@ -78,14 +78,15 @@
<hr>
<div id="content">
- <p>Cayenne is a Java <em>object relational mapping (ORM) framework</em>. In other
+ <h2 id="why-cayenne">Why Cayenne?</h2>
+<p>Cayenne is a Java <em>object relational mapping (ORM) framework</em>. In other
words, it is a tool for Java developers who need to talk to a database (or
many databases). Rather than hardcoding SQL statements through Java code,
Cayenne allows a programmer to work only with Java objects abstracted from
the database. Here are just a few benefits of the Cayenne approach to
persistence:</p>
<ul>
-<li>Portability between almost any <a href="caydoc:database-support.html">database</a>
+<li>Portability between almost any <a href="/database-support.html">database</a>
that has a JDBC driver without changing a single line of code in your
application.</li>
<li>No knowledge of SQL is required (while it still can be helpful).</li>