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 <[email protected]>
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>
