1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
---
layout: todos
title: PostgreSQL JDBC Todo
resource: ../media
nav: ../
---
# Todo List
***
* [Known Bugs](#Known_Bugs)
* [Compliance](#Compliance)
* [Performance](#Performance)
* [PG Extensions](#PG_Extensions)
* [Other](#Other)
* [Ideas](#Ideas)
* [Documentation](#Documentation)
* [Website](#Website)
***
<a name="Known_Bugs"></a>
## Known Bugs
* **[bugs]** Deallocating large numbers of server side statements can break the
connection by filling network buffers. This is a very, very low probability
bug, but it is still possible. <a href="http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00115.php">ref</a>
→
***
<a name="Compliance"></a>
## Compliance
* **[JDBC1]** Implement Statement.setQueryTimeout. →
* **[JDBC2]** Sort DatabaseMetaData.getTypeInfo properly (by closest match). →
* **[JDBC2]** Implement SQLInput and SQLOutput to allow composite types to be used. →
* **[JDBC3]** Implement Statement.getGeneratedKeys. <a href="http://archives.postgresql.org/pgsql-jdbc/2004-09/msg00190.php">ref2</a> →
* **[JDBC3]** The JDBC 3 DatabaseMetaData methods sometimes return additional information.
Currently we only return JDBC 2 data for these methods. <a href="http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00038.php">ref</a>
→
* **[JDBC3]** Implement Clob write/position methods. →
***
<a name="Performance"></a>
## Performance
* **[]** Add statement pooling to take advantage of server prepared statements. →
* **[]** Allow scrollable ResultSets to not fetch all results in one batch. →
* **[]** Allow refcursor ResultSets to not fetch all results in one batch. →
* **[]** Allow binary data transfers for all datatypes not just bytea. →
***
<a name="PG_Extensions"></a>
## PG Extensions
* **[]** Allow configuration of GUC parameters via the Connection URL or Datasource.
The most obvious example of usefulness is search_path. <a href="http://archives.postgresql.org/pgsql-jdbc/2004-02/msg00022.php">ref</a>
→
***
<a name="Other"></a>
## Other
* **[test]** Pass the JDBC CTS (Sun's test suite). →
* **[code]** Allow SSL to use client certificates. This can probably be done with
our existing SSLSocketFactory customization code, but it would be good to
provide an example or other wrapper so a non-expert can set it up.
<a href="http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00077.php">ref1</a>,
<a href="http://archives.postgresql.org/pgsql-jdbc/2004-12/msg00083.php">ref2</a> →
* **[code]** Currently the internal type cache is not schema aware. →
* **[code]** Need a much better lexer/parser than the ad hoc stuff in the driver.
<a href="http://archives.postgresql.org/pgsql-jdbc/2004-09/msg00062.php">ref2</a> →
***
<a name="Ideas"></a>
## Ideas
* **[]** Allow Blob/Clob to operate on bytea/text data. <a href="http://archives.postgresql.org/pgsql-jdbc/2005-01/msg00058.php">ref</a>
→
* **[]** Allow getByte/getInt/... to work on boolean values <a href="http://archives.postgresql.org/pgsql-jdbc/2005-01/msg00254.php">ref</a>
→
* **[]** Add a URL parameter to make the driver not force a rollback on error for
compatibility with other dbs. The driver can wrap each statement in a Savepoint.
<a href="http://archives.postgresql.org/pgsql-jdbc/2005-01/msg00131.php">ref</a> →
* **[]** Combine DatabaseMetaData efforts with pl/java. <a href="http://archives.postgresql.org/pgsql-jdbc/2005-02/msg00063.php">ref</a>
→
* **[]** ResultSetMetaData calls that run queries are cached on a per column basis, but
it seems likely that they're going to be called for all columns, so try to issue
one query per ResultSet, not per column. →
* **[]** Make PGConnection, PGStatement, ... extend java.sql.XXX <a href="http://archives.postgresql.org/pgsql-jdbc/2005-01/msg00223.php">ref</a>
→
***
<a name="Documentation"></a>
## Documentation
* **[]** The PGResultSetMetaData interface is not mentioned. →
* **[]** Timestamp +/- Infinity values are not mentioned. →
* **[]** Async notifies are more async now. <a href="http://archives.postgresql.org/pgsql-jdbc/2005-04/msg00056.php">ref</a>
→
***
<a name="Website"></a>
## Website
* **[]** Setup a cron job somewhere to build and deploy the sight on a daily
basis to keep API changes and translations up to date.
→
* **[]** Add a daily git snapshot build to make the latest updates available.
→
|
