This is an automated email from the ASF dual-hosted git repository. ntimofeev pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/cayenne-website.git
commit 37994c4c6175bd30ee0ab610f25c283ddce06c52 Author: Nikita Timofeev <[email protected]> AuthorDate: Thu Mar 14 17:40:08 2024 +0400 Fix `database-support` page --- src/main/site/content/about/database-support.html | 128 ++++++++++++++++++++++ src/main/site/content/about/database-support.md | 30 ----- 2 files changed, 128 insertions(+), 30 deletions(-) diff --git a/src/main/site/content/about/database-support.html b/src/main/site/content/about/database-support.html new file mode 100644 index 000000000..c342461ad --- /dev/null +++ b/src/main/site/content/about/database-support.html @@ -0,0 +1,128 @@ +--- +title: Database Support +url: /database-support.html +--- +<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 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> \ No newline at end of file diff --git a/src/main/site/content/about/database-support.md b/src/main/site/content/about/database-support.md deleted file mode 100644 index c85aa59aa..000000000 --- a/src/main/site/content/about/database-support.md +++ /dev/null @@ -1,30 +0,0 @@ ---- -title: Database Support -url: /database-support.html -markup: md ---- - -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. - -{#db-support .table .table-bordered} -Database | Driver Name | Sample URL | Notes ------------------------------------------|--------------------------------------------------------------|-------------------------------------------------------------------|------------------------------- -[DB2](http://www.ibm.com/db2/) | com.<wbr>ibm.<wbr>db2.<wbr>jcc.<wbr>DB2<wbr>Driver | jdbc:<wbr>db2:<wbr>//127.0.0.1:<wbr>50000<wbr>/dbname | -[Derby](http://db.apache.org/derby/) | org.<wbr>apache.<wbr>derby.<wbr>jdbc.<wbr>Client<wbr>Driver | jdbc:<wbr>derby:<wbr>//127.0.0.1<wbr>/testdb | client<wbr>/<wbr>server - | org.<wbr>apache.<wbr>derby.<wbr>jdbc.<wbr>Em<wbr>bedded<wbr>Driver| jdbc:<wbr>derby:<wbr>path-to-<wbr>db-dir;<wbr>create=<wbr>true | em<wbr>bedd<wbr>ed -[FrontBase](http://www.frontbase.com/) | jdbc.<wbr>Front<wbr>Base.<wbr>FBJ<wbr>Driver | jdbc:<wbr>Front<wbr>Base:<wbr>//127.0.0.1<wbr>/dbname | -[HSQLDB](http://hsqldb.org/) | org.<wbr>hsqldb.<wbr>jdbc<wbr>Driver | jdbc:<wbr>hsqldb:<wbr>hsql:<wbr>//127.0.0.1 | client<wbr>/<wbr>server - | jdbc:<wbr>hsqldb: | file:<wbr>/path-to-<wbr>hsql-db-<wbr>files | em<wbr>bedd<wbr>ed -[H2](http://www.h2database.com/) | org.<wbr>h2.<wbr>Driver | jdbc:<wbr>h2:<wbr>mem:<wbr>myTestMem;<wbr>MVCC=<wbr>TRUE | em<wbr>bedd<wbr>ed in-<wbr>me<wbr>mory -[Ingres](http://www.ingres.com/products/ingres-database.php)| com.<wbr>ingres.<wbr>jdbc.<wbr>Ingres<wbr>Driver | jdbc:<wbr>ingres:<wbr>//127.0.0.1<wbr>:II7<wbr>/dbname | -[MySQL](http://www.mysql.com/) | com.<wbr>mysql.<wbr>jdbc.<wbr>Driver | jdbc:<wbr>mysql:<wbr>//127.0.0.1<wbr>/dbname | -[OpenBase](http://www.openbase.com) | com.<wbr>open<wbr>base.<wbr>jdbc.<wbr>Ob<wbr>Driver | jdbc:<wbr>open<wbr>base:<wbr>//127.0.0.1<wbr>/dbname | -[Oracle](http://www.oracle.com/) | oracle.<wbr>jdbc.<wbr>driver.<wbr>Oracle<wbr>Driver | jdbc:<wbr>oracle<wbr>:thin:<wbr>@//127.0.0.1<wbr>:1521<wbr>/dbname| -[PostgreSQL](http://www.postgresql.org/) | org.<wbr>postgre<wbr>sql.<wbr>Driver | jdbc:<wbr>postgre<wbr>sql:<wbr>//127.0.0.1<wbr>:5432<wbr>/dbname | -[SQLite 3.*](http://www.sqlite.org/) | org.<wbr>sqlite.<wbr>JDBC | jdbc:<wbr>sqlite:<wbr>path_<wbr>to_<wbr>dbfile | driver from zentus<wbr>.com -[SQLServer](http://www.microsoft.com/sqlserver)| [com.<wbr>microsoft.<wbr>sqlserver.<wbr>jdbc.<wbr>SQLServer<wbr>Driver](http://msdn.microsoft.com/en-us/data/aa937724.aspx)| jdbc:<wbr>sql<wbr>server:<wbr>//127.0.0.1;<wbr>data<wbr>base<wbr>Name=<wbr>dbname | Micro<wbr>soft Driver - | com.<wbr>micro<wbr>soft.<wbr>jdbc.<wbr>sql<wbr>server.<wbr>SQL<wbr>Server<wbr>Driver | jdbc:<wbr>micro<wbr>soft:<wbr>sql<wbr>server:<wbr>//127.0.0.1<wbr>;data<wbr>base<wbr>Name<wbr>=dbname;<wbr>Select<wbr>Method<wbr>=cursor | Micro<wbr>soft Driver, SQL Server prior to 2005 - | net.<wbr>source<wbr>forge.<wbr>jtds.<wbr>jdbc.<wbr>Driver | jdbc:<wbr>jtds:<wbr>sql<wbr>server:<wbr>//127.0.0.1<wbr>:5000<wbr>/dbname | [jTDS Driver](http://jtds.sourceforge.net/) -[Sybase](http://www.sybase.com/) | com.<wbr>sybase.<wbr>jdbc3.<wbr>jdbc.<wbr>Syb<wbr>Driver | jdbc:<wbr>sybase:<wbr>Tds:<wbr>127.0.0.1<wbr>:5000<wbr>/dbname | Sy<wbr>base driver - | net.<wbr>source<wbr>forge.<wbr>jtds.<wbr>jdbc.<wbr>Driver | jdbc:<wbr>jtds:<wbr>sybase:<wbr>//127.0.0.1<wbr>:5000<wbr>/dbname;<wbr>useLOBs=<wbr>false;<wbr>TDS=4.2 | [jTDS Driver](http://jtds.sourceforge.net/) \ No newline at end of file
