| <!DOCTYPE html> |
| <html lang="en"> |
| <head> |
| <meta charset="utf-8"> |
| <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.3"> |
| <link rel="apple-touch-icon" sizes="180x180" href="/img/favicon/apple-touch-icon-04cb17e028.png"> |
| <link rel="icon" type="image/png" sizes="32x32" href="/img/favicon/favicon-32x32-12431ee8eb.png"> |
| <link rel="icon" type="image/png" sizes="16x16" href="/img/favicon/favicon-16x16-4f316e4d55.png"> |
| <link rel="manifest" href="/img/favicon/manifest-65e6aaa49e.json"> |
| <link rel="mask-icon" href="/img/favicon/safari-pinned-tab-558c1991b1.svg" color="#dc5656"> |
| <link rel="shortcut icon" href="/img/favicon/favicon-6cef91375b.ico"> |
| <meta name="msapplication-TileColor" content="#ffffff"> |
| <meta name="msapplication-TileImage" content="/img/favicon/mstile-144x144-34e7696278.png"> |
| <meta name="msapplication-config" content="/img/favicon/browserconfig-82ff158058.xml"> |
| <meta name="theme-color" content="#ffffff"> |
| <link rel="stylesheet" href="https://cayenne.apache.org/css/styles-9ee2e6e330.css"/> |
| <script src="https://cayenne.apache.org/js/bundle-c0e6356367.js"></script> |
| <script src="https://www.apachecon.com/event-images/snippet.js"></script> |
| <title>Database Support · Apache Cayenne</title> |
| </head> |
| <body> |
| |
| |
| |
| <header class="page-header"> |
| <nav id="topbar" class="bg-dark" aria-label="breadcrumb" role="navigation"> |
| <ul class="breadcrumb breadcrumb-sm breadcrumb-dark container mb-0"> |
| <li class="breadcrumb-item dropdown"> |
| <a class="dropdown-toggle text-nowrap pr-1" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> |
| <img class="mw-15px mr-1" src="/img/feather-641aa69d09.svg" />Apache Software Foundation</a> |
| <div class="dropdown-menu rounded-0" aria-labelledby="navbarDropdown"> |
| <a class="dropdown-item" href="https://www.apache.org">Apache Homepage</a> |
| <a class="dropdown-item" href="https://www.apache.org/licenses/">License</a> |
| <a class="dropdown-item" href="https://www.apache.org/foundation/sponsorship.html">Sponsorship</a> |
| <a class="dropdown-item" href="https://www.apache.org/foundation/thanks.html">Thanks</a> |
| <a class="dropdown-item" href="https://www.apache.org/security/">Security</a> |
| <a class="dropdown-item" href="https://privacy.apache.org/policies/privacy-policy-public.html">Privacy</a> |
| <a class="ml-1 mt-1 acevent" data-format="wide" data-mode="dark" data-width="120"></a> |
| </div> |
| </li> |
| </ul> |
| </nav> |
| <nav class="navbar navbar-expand-lg navbar-dark bg-primary"> |
| <div class="container"> |
| <a class="navbar-brand" href="https://cayenne.apache.org/"> |
| <img src="/img/logo_mono_full-d7a19eef61.svg" alt="Apache Cayenne" /> |
| </a> |
| <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#mainMenu" aria-controls="mainMenu" aria-expanded="false" aria-label="Toggle navigation"> |
| <span class="navbar-toggler-icon"></span> |
| </button> |
| |
| <div class="collapse navbar-collapse" id="mainMenu"> |
| <ul class="navbar-nav mt-3 mt-lg-0 mr-auto"> |
| |
| <li class="nav-item"> |
| <a class="nav-link" href="/download/">DOWNLOAD</a> |
| </li> |
| |
| <li class="nav-item"> |
| <a class="nav-link" href="/docs/4.2/getting-started-guide/">DOCUMENTATION</a> |
| </li> |
| |
| <li class="nav-item"> |
| <a class="nav-link" href="/about/support/">SUPPORT</a> |
| </li> |
| |
| </ul> |
| <ul class="navbar-nav flex-row justify-content-center mt-2 mt-lg-0 mb-2 mb-lg-0 " id="social-links-menu"> |
| <li class="nav-item d-flex"> |
| <a class="nav-link d-flex justify-content-center align-items-center" href="https://github.com/apache/cayenne"> |
| <img src="/img/icon_octocat_stars-c24dac94b8.svg" alt="GitHub" /> |
| </a> |
| </li> |
| <li class="nav-item d-flex"> |
| <a class="nav-link d-flex justify-content-center align-items-center" href="https://twitter.com/ApacheCayenne"> |
| <img src="/img/icon_twitter-220a129d14.svg" alt="Twitter" /> |
| </a> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </nav> |
| </header> |
| |
| |
| |
| |
| <main class="container py-5"> |
| <section> |
| <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> |
| <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> |
| |
| <img referrerpolicy="no-referrer-when-downgrade" src="https://static.scarf.sh/a.png?x-pxid=5c836e39-be6b-4a21-a946-a97b5b69f172" /> |
| |
| <footer class="bg-dark"> |
| <div class="footer-nav container text-center text-lg-left pb-3"> |
| <div class="row pt-5 pb-3"> |
| |
| <div class="col-sm-6 col-lg-3"> |
| <h4>About</h4> |
| <ul class="list-unstyled"> |
| |
| <li> |
| <a href="/why-cayenne.html">Why Cayenne?</a> |
| </li> |
| |
| <li> |
| <a href="/download/">Download</a> |
| </li> |
| |
| <li> |
| <a href="/success-stories.html">Success Stories</a> |
| </li> |
| |
| <li> |
| <a href="/about/support/">Support</a> |
| </li> |
| |
| </ul> |
| </div> |
| |
| <div class="col-sm-6 col-lg-3"> |
| <h4>Documentation</h4> |
| <ul class="list-unstyled"> |
| |
| <li> |
| <a href="/docs/4.0/getting-started-guide/">Getting Started (4.0)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.1/getting-started-guide/">Getting Started (4.1)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.2/getting-started-guide/">Getting Started (4.2)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.0/cayenne-guide/">Cayenne Guide (4.0)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.1/cayenne-guide/">Cayenne Guide (4.1)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.2/cayenne-guide/">Cayenne Guide (4.2)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.1/getting-started-db-first/">Database First tutorial (4.1)</a> |
| </li> |
| |
| <li> |
| <a href="/docs/4.2/getting-started-db-first/">Database First tutorial (4.2)</a> |
| </li> |
| |
| <li> |
| <a href="/legacy/legacy-docs/">Legacy Documentation</a> |
| </li> |
| |
| </ul> |
| </div> |
| |
| <div class="col-sm-6 col-lg-3"> |
| <h4>Collaboration</h4> |
| <ul class="list-unstyled"> |
| |
| <li> |
| <a href="https://issues.apache.org/jira/browse/CAY">Bug/Feature Tracker</a> |
| </li> |
| |
| <li> |
| <a href="/mailing-lists.html">Mailing Lists</a> |
| </li> |
| |
| <li> |
| <a href="/dev/code-repository.html">Code Repository</a> |
| </li> |
| |
| <li> |
| <a href="/dev/">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> |
| |
| <li> |
| <a href="/thanks.html">Thanks</a> |
| </li> |
| |
| </ul> |
| </div> |
| |
| <div class="col-sm-6 col-lg-3"> |
| <h4>News</h4> |
| <ul class="list-multiline-items list-unstyled mb-0"> |
| |
| <li> |
| <time datetime="2023-05-25 18:00:00 +0300 +0300" class="xsmall d-block">May 25, 2023</time> |
| <a href="/2023/05/cayenne-42-final-released/">Cayenne 4.2 Final Released</a> |
| </li> |
| |
| <li> |
| <time datetime="2023-03-02 12:00:00 +0300 +0300" class="xsmall d-block">Mar 02, 2023</time> |
| <a href="/2023/03/cayenne-403-released/">Cayenne 4.0.3 Released</a> |
| </li> |
| |
| <li> |
| <time datetime="2022-12-05 12:00:00 +0300 +0300" class="xsmall d-block">Dec 05, 2022</time> |
| <a href="/2022/12/cayenne-42rc2-released/">Cayenne 4.2 Release Candidate 2 Released</a> |
| </li> |
| |
| </ul> |
| <a class="btn-link text-uppercase xsmall" href="https://cayenne.apache.org/news"> |
| More news |
| <i class="fa fa-lg fa-long-arrow-right" aria-hidden="true"></i> |
| </a> |
| </div> |
| </div> |
| <hr class="mt-0 mb-3" /> |
| <p class="copy xsmall text-center mw-75 mx-auto mb-0"> |
| Copyright © 2001-2024 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="https://privacy.apache.org/policies/privacy-policy-public.html">Privacy policy</a>. |
| <img class="d-block mx-auto mt-2" src="/img/logo_mono-3302daa3cf.svg" alt="Apache Cayenne" /> |
| </p> |
| </div> |
| </footer> |
| </body> |
| </html> |