You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by nt...@apache.org on 2024/03/14 13:42:21 UTC
(cayenne-website) branch asf-site updated: Fix database-support page and add for .zip files
This is an automated email from the ASF dual-hosted git repository.
ntimofeev pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/cayenne-website.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 89db06e3c Fix database-support page and add for .zip files
89db06e3c is described below
commit 89db06e3cd94e8ef9fa960865ccacd6a64d9572b
Author: Nikita Timofeev <st...@gmail.com>
AuthorDate: Thu Mar 14 17:42:18 2024 +0400
Fix database-support page and add for .zip files
---
.htaccess | 2 +-
database-support.html | 146 ++++++++++++++++++++++++++++++++++++++++++--------
2 files changed, 124 insertions(+), 24 deletions(-)
diff --git a/.htaccess b/.htaccess
index 3a6a739c5..67f9833b3 100644
--- a/.htaccess
+++ b/.htaccess
@@ -82,7 +82,7 @@ ErrorDocument 404 /404.html
RedirectMatch 404 /\.git
# Cache for one month static assets
-<filesMatch ".(css|jpg|jpeg|png|gif|svg|js|ico)$">
+<filesMatch ".(css|jpg|jpeg|png|gif|svg|js|ico|zip)$">
Header set Cache-Control "max-age=2628000, public"
</filesMatch>
diff --git a/database-support.html b/database-support.html
index a27823b43..04f6712b6 100644
--- a/database-support.html
+++ b/database-support.html
@@ -90,29 +90,129 @@
<article>
<h1 class="text-center">Database Support</h1>
<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>
-<p>{#db-support .table .table-bordered}
-Database | Driver Name | Sample URL | Notes <br>
-—————————————–|————————————————————–|——————————————————————-|——————————-
-<a href="http://www.ibm.com/db2/">DB2</a> | com.<!-- raw HTML omitted -->ibm.<!-- raw HTML omitted -->db2.<!-- raw HTML omitted -->jcc.<!-- raw HTML omitted -->DB2<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->db2:<!-- raw HTML omitted -->//127.0.0.1:<!-- raw HTML omitted -->50000<!-- raw HTML omitted -->/dbname | <br>
-<a href="http://db.apache.org/derby/">Derby</a> | org.<!-- raw HTML omitted -->apache.<!-- raw HTML omitted -->derby.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Client<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->derby:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->/testdb | client<!-- raw HTML omitted -->/<!-- raw HTML omitted -->server
-| org.<!-- raw HTML omitted -->apache.<!-- raw HTML omitted -->derby.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Em<!-- raw HTML omitted -->bedded<!-- raw HTML omitted -->Driver| jdbc:<!-- raw HTML omitted -->derby:<!-- raw HTML omitted -->path-to-<!-- raw HTML omitted -->db-dir;<!-- raw HTML omitted -->create=<!-- raw HTML omitted -->true | em<!-- raw HTML omitted -->bedd<!-- raw HTML omitted -->ed <br>
-<a href="http://www.frontbase.com/">FrontBase</a> | jdbc.<!-- raw HTML omitted -->Front<!-- raw HTML omitted -->Base.<!-- raw HTML omitted -->FBJ<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->Front<!-- raw HTML omitted -->Base:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->/dbname |
-<a href="http://hsqldb.org/">HSQLDB</a> | org.<!-- raw HTML omitted -->hsqldb.<!-- raw HTML omitted -->jdbc<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->hsqldb:<!-- raw HTML omitted -->hsql:<!-- raw HTML omitted -->//127.0.0.1 | client<!-- raw HTML omitted -->/<!-- raw HTML omitted -->server
-| jdbc:<!-- raw HTML omitted -->hsqldb: | file:<!-- raw HTML omitted -->/path-to-<!-- raw HTML omitted -->hsql-db-<!-- raw HTML omitted -->files | em<!-- raw HTML omitted -->bedd<!-- raw HTML omitted -->ed
-<a href="http://www.h2database.com/">H2</a> | org.<!-- raw HTML omitted -->h2.<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->h2:<!-- raw HTML omitted -->mem:<!-- raw HTML omitted -->myTestMem;<!-- raw HTML omitted -->MVCC=<!-- raw HTML omitted -->TRUE | em<!-- raw HTML omitted -->bedd<!-- raw HTML omitted -->ed in-<!-- raw HTML omitted -->me<!-- raw HTML omitted -->mory
-<a href="http://www.ingres.com/products/ingres-database.php">Ingres</a>| com.<!-- raw HTML omitted -->ingres.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Ingres<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->ingres:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->:II7<!-- raw HTML omitted -->/dbname | <br>
-<a href="http://www.mysql.com/">MySQL</a> | com.<!-- raw HTML omitted -->mysql.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->mysql:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->/dbname | <br>
-<a href="http://www.openbase.com">OpenBase</a> | com.<!-- raw HTML omitted -->open<!-- raw HTML omitted -->base.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Ob<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->open<!-- raw HTML omitted -->base:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->/dbname | <br>
-<a href="http://www.oracle.com/">Oracle</a> | oracle.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->driver.<!-- raw HTML omitted -->Oracle<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->oracle<!-- raw HTML omitted -->:thin:<!-- raw HTML omitted -->@//127.0.0.1<!-- raw HTML omitted -->:1521<!-- raw HTML omitted -->/dbname| <br>
-<a href="http://www.postgresql.org/">PostgreSQL</a> | org.<!-- raw HTML omitted -->postgre<!-- raw HTML omitted -->sql.<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->postgre<!-- raw HTML omitted -->sql:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->:5432<!-- raw HTML omitted -->/dbname | <br>
-<a href="http://www.sqlite.org/">SQLite 3.*</a> | org.<!-- raw HTML omitted -->sqlite.<!-- raw HTML omitted -->JDBC | jdbc:<!-- raw HTML omitted -->sqlite:<!-- raw HTML omitted -->path_<!-- raw HTML omitted -->to_<!-- raw HTML omitted -->dbfile | driver from zentus<!-- raw HTML omitted -->.com
-<a href="http://www.microsoft.com/sqlserver">SQLServer</a>| <a href="http://msdn.microsoft.com/en-us/data/aa937724.aspx">com.<!-- raw HTML omitted -->microsoft.<!-- raw HTML omitted -->sqlserver.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->SQLServer<!-- raw HTML omitted -->Driver</a>| jdbc:<!-- raw HTML omitted -->sql<!-- raw HTML omitted -->server:<!-- raw HTML omitted -->//127.0.0.1;<!-- raw HTML omitted -->data<!-- raw HTML omitted -->base<!-- raw HTML omitted -->Name=<!-- r [...]
-| com.<!-- raw HTML omitted -->micro<!-- raw HTML omitted -->soft.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->sql<!-- raw HTML omitted -->server.<!-- raw HTML omitted -->SQL<!-- raw HTML omitted -->Server<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->micro<!-- raw HTML omitted -->soft:<!-- raw HTML omitted -->sql<!-- raw HTML omitted -->server:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->;data<!-- raw HTML omitted -->base<!-- raw HTML omitted [...]
-| net.<!-- raw HTML omitted -->source<!-- raw HTML omitted -->forge.<!-- raw HTML omitted -->jtds.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->jtds:<!-- raw HTML omitted -->sql<!-- raw HTML omitted -->server:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->:5000<!-- raw HTML omitted -->/dbname | <a href="http://jtds.sourceforge.net/">jTDS Driver</a>
-<a href="http://www.sybase.com/">Sybase</a> | com.<!-- raw HTML omitted -->sybase.<!-- raw HTML omitted -->jdbc3.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Syb<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->sybase:<!-- raw HTML omitted -->Tds:<!-- raw HTML omitted -->127.0.0.1<!-- raw HTML omitted -->:5000<!-- raw HTML omitted -->/dbname | Sy<!-- raw HTML omitted -->base driver<br>
-| net.<!-- raw HTML omitted -->source<!-- raw HTML omitted -->forge.<!-- raw HTML omitted -->jtds.<!-- raw HTML omitted -->jdbc.<!-- raw HTML omitted -->Driver | jdbc:<!-- raw HTML omitted -->jtds:<!-- raw HTML omitted -->sybase:<!-- raw HTML omitted -->//127.0.0.1<!-- raw HTML omitted -->:5000<!-- raw HTML omitted -->/dbname;<!-- raw HTML omitted -->useLOBs=<!-- raw HTML omitted -->false;<!-- raw HTML omitted -->TDS=4.2 | <a href="http://jtds.sourceforge.net/">jTDS Driver</a></p>
-
+ All databases below have custom Cayenne DbAdapters and are automatically recognized by Cayenne AutoAdapter.</p>
+<table id="db-support" class="table table-bordered">
+ <thead>
+ <tr>
+ <th>Database</th>
+ <th>Driver Name</th>
+ <th>Sample URL</th>
+ <th>Notes</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td><a href="https://www.ibm.com/db2/">DB2</a></td>
+ <td>com.ibm.db2.jcc.DB2Driver</td>
+ <td>jdbc:db2://127.0.0.1:50000/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://db.apache.org/derby/">Derby</a></td>
+ <td>org.apache.derby.jdbc.ClientDriver</td>
+ <td>jdbc:derby://127.0.0.1/testdb</td>
+ <td>client/server</td>
+ </tr>
+ <tr>
+ <td> </td>
+ <td>org.apache.derby.jdbc.EmbeddedDriver</td>
+ <td>jdbc:derby:path-to-db-dir;create=true</td>
+ <td>embedded</td>
+ </tr>
+ <tr>
+ <td><a href="https://www.frontbase.com/">FrontBase</a></td>
+ <td>jdbc.FrontBase.FBJDriver</td>
+ <td>jdbc:FrontBase://127.0.0.1/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://hsqldb.org/">HSQLDB</a></td>
+ <td>org.hsqldb.jdbcDriver</td>
+ <td>jdbc:hsqldb:hsql://127.0.0.1</td>
+ <td>client/server</td>
+ </tr>
+ <tr>
+ <td> </td>
+ <td> </td>
+ <td>jdbc:hsqldb:file:/path-to-hsql-db-files</td>
+ <td>embedded</td>
+ </tr>
+ <tr>
+ <td><a href="https://www.h2database.com/">H2</a></td>
+ <td>org.h2.Driver</td>
+ <td>jdbc:h2:mem:myTestMem;MVCC=TRUE</td>
+ <td>embedded in-memory</td>
+ </tr>
+ <tr>
+ <td><a href="https://www.ingres.com/products/ingres-database.php">Ingres</a></td>
+ <td>com.ingres.jdbc.IngresDriver</td>
+ <td>jdbc:ingres://127.0.0.1:II7/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://www.mysql.com/">MySQL</a></td>
+ <td>com.mysql.jdbc.Driver</td>
+ <td>jdbc:mysql://127.0.0.1/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://www.openbase.com">OpenBase</a></td>
+ <td>com.openbase.jdbc.ObDriver</td>
+ <td>jdbc:openbase://127.0.0.1/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://www.oracle.com/">Oracle</a></td>
+ <td>oracle.jdbc.driver.OracleDriver</td>
+ <td>jdbc:oracle:thin:@//127.0.0.1:1521/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://www.postgresql.org/">PostgreSQL</a></td>
+ <td>org.postgresql.Driver</td>
+ <td>jdbc:postgresql://127.0.0.1:5432/dbname</td>
+ <td> </td>
+ </tr>
+ <tr>
+ <td><a href="https://www.sqlite.org/">SQLite 3.*</a></td>
+ <td>org.sqlite.JDBC</td>
+ <td>jdbc:sqlite:path_to_dbfile</td>
+ <td>driver from zentus.com</td>
+ </tr>
+ <tr>
+ <td><a href="https://www.microsoft.com/sqlserver">SQLServer</a></td>
+ <td>
+ <a href="https://msdn.microsoft.com/en-us/data/aa937724.aspx">com.microsoft.sqlserver.jdbc.SQLServerDriver</a>
+ </td>
+ <td>jdbc:sqlserver://127.0.0.1;databaseName=dbname</td>
+ <td>Microsoft Driver</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>
+ <td>Microsoft Driver, SQL Server prior to 2005</td>
+ </tr>
+ <tr>
+ <td> </td>
+ <td>net.sourceforge.jtds.jdbc.Driver</td>
+ <td>jdbc:jtds:sqlserver://127.0.0.1:5000/dbname</td>
+ <td><a href="https://jtds.sourceforge.net/">jTDS Driver</a></td>
+ </tr>
+ <tr>
+ <td><a href="https://www.sybase.com/">Sybase</a></td>
+ <td>com.sybase.jdbc3.jdbc.SybDriver</td>
+ <td>jdbc:sybase:Tds:127.0.0.1:5000/dbname</td>
+ <td>Sybase driver</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>
+ <td><a href="https://jtds.sourceforge.net/">jTDS Driver</a></td>
+ </tr>
+ </tbody>
+</table>
</article>
</section>
</main>