Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account. You can also Sign Up for a new account.

<h2>Design Considerations</h2><p>Some areas of concern are listed as tickets in JIRA already. Other areas are not yet well-formed enough to create specific, actionable tickets:</p><ul><li>DDL support is weak, e.g., <span style="text-decoration: line-through;"><a href="http://dev.clojure.org/jira/browse/JDBC-2">JDBC-2 table spec support</a></span> - DONE; added in 0.3.0 but more DDL support could (should?) be provided</li><li>Inconsistencies between structmaps, tuples and regular maps (<s><a href="http://dev.clojure.org/jira/browse/JDBC-3">JDBC-3</a></s>); no longer uses structmap - DONE; new API (0.3.0) is more consistent about maps and sequences</li><li>Global connection variable (<strong>db</strong>) - DONE; addressed by new API in 0.3.0</li><li>Lack of connection pooling (<s><a href="http://dev.clojure.org/jira/browse/JDBC-4">JDBC-4</a></s>); better served thru 3rd party pooling, e.g., c3p0 - DONE; documented</li><li>Inability to extend the processing, lack of HOF hooks, e.g., <s><a href="http://dev.clojure.org/jira/browse/JDBC-6">JDBC-6 allow pre-processing of PreparedStatement</a></s> - partially DONE?</li><li>Updating state is not signified with ! - DONE; addressed by new API in 0.3.0</li><li>API feels imperative, not functional / idiomatic for Clojure - DONE; addressed by new API in 0.3.0</li></ul><h2>Additional Suggestions</h2><p>The following suggestions have been made and are under discussion:</p><ul><li>Overriding default identifiers and entities functions<ul><li>identifiers could be done via the db-spec since only the query function uses it (passed to result-set-seq)</li><li>entities are only used by the DSL to generate SQL so it's not clear yet how this would interact with the db-spec</li></ul></li><li>Providing a canonical Database Specification a la Ring Spec<ul><li>Awaiting more information...</li></ul></li></ul><h2>Supported Databases</h2><p>What databases and versions should clojure.java.jdbc support? c.j.j is developed and tested against MySQL 5.0 and MySQL 5.1, HSQLDB, SQLite, Derby, MS SQL Server (both MS driver and jTDS driver). The following databases and versions are considered supported in 0.3.0:</p><ul><li>MySQL 5.0 - 5.5 (using the 5.1.6 connector)</li><li>SQL Server - 2008 (should 2005 be supported?) - tested with jtds 1.2.4 and the Microsoft sqljdbc4 3.0 driver</li><li>Derby 10.8.1.2 (should earlier versions be supported?)</li><li>HSQLDB 1.8.0.10 (should earlier versions be supported?)</li><li>SQLite 3 (using the org.xerial/sqlite-jdbc 3.7.2 driver)</li></ul><p>Additionally, users of c.j.j are successfully running against:</p><ul><li>PostgreSQL - 8.2 upward (this is considered &quot;supported&quot; although it is not part of the general testbed)</li><li>H2 (to be confirmed)</li><li>Oracle (versions unknown)</li><li>TeraData (??)</li></ul><p>The build system needs to be updated to run tests against at least some of these. Currently c.j.j is unique in requiring such external resources for testing.</p>