| layout | title | resource | nav |
|---|---|---|---|
changes |
PostgreSQL JDBC Changelog |
../media |
../ |
- Introduction and explanation of symbols
- Version 42.0.0 (2017-02-18)
- Version 9.4.1212 (2016-11-01)
- Version 9.4.1211 (2016-09-18)
- Version 9.4.1210 (2016-09-07)
- Version 9.4.1209 (2016-07-15)
- Version 9.4.1208 (2016-02-19)
- Version 9.4.1207 (2015-12-23)
- Version 9.4-1206 (2015-11-25)
- Version 9.4-1205 (2015-11-03)
- Version 9.4-1204 (2015-10-09)
- Version 9.4-1203 (2015-09-17)
- Version 9.4-1202 (2015-08-27)
- Version 9.4-1201 (2015-02-25)
- Version 9.4-1200 (2015-01-02)
- Version 9.3-1103 (2015-19-09)
- Version 9.3-1103 (2015-01-02)
- Version 9.3-1102 (2014-07-10)
- Version 9.3-1101 (2014-02-19)
- Version 9.3-1100 (2013-11-01)
- Version 9.2-1004 (2013-10-31)
- Version 9.2-1003 (2013-07-08)
- Version 9.2-1002 (2012-11-14)
- Version 9.2-1001 (2012-10-31)
- Version 9.2-1000 (2012-09-27)
- Version 9.1-902 (2011-04-18)
- Version 9.1-901 (2011-04-18)
- Version 9.1dev-900 (2011-04-18)
- Version 9.0-801 (2010-09-20)
- Version 9.0-dev800 (2010-05-11)
- Archived Versions 8.0-8.4
- All Committers
Changes are sorted by "type" and then chronologically with the most recent at the top. These symbols
denote the various action types:
=add,
=fix,
=remove,
=update
{% include changelog/42.0.0-release.md %}
Notable changes:
- ? can now be used in non-prepared statements (regression was introduced in 1210)
AlexElin (1):
- chore: add coverage badge (#646) 05c2f8d
Jorge Solorzano (6):
- docs: split readme.md to contributing.md (#652) 7270435
- docs: improve readme.md (#666) cf6b836
- docs: change license to BSD-2-Clause (#660) b4c90c8
- style: update the header in the project (#662) 8be516d
- fix: copy src/main/resources (#676) 14f3fce
- style: copy license file to META-INF folder (#677) c518697
Sebastian Utz (1):
Vladimir Sitnikov (4):
- fix: do not convert ?, ? to $1, $2 when statement.executeQuery(String) is used (#644) PR#643 08e1a40
- tests: make CursorFetchTest.testGetRow to use stable order of rows so the test does not depend on actual implementation of UNION 3c8efe4
- fix: avoid ClassLoader leaks caused by SharedTimer PR#664 f52bf7f
- Make successful OSGi activation less noisy PR#672 22b9025
zapov (1):
- fix: Don't break when there is no column metadata (#663) 6d2a53e
We thank the following people for their contributions to this release.
AlexElin
Jorge Solorzano
Rikard Pavelic
Sebastian Utz
Vladimir Sitnikov
Notable changes:
- json type is returned as PGObject like in pre-9.4.1210 (fixed regression of 9.4.1210)
- 'current transaction is aborted' exception includes the original exception via caused-by chain
Daniel Gustafsson (1):
- doc: fix brand names and links in readme (#636) 56c04d0
Vladimir Sitnikov (4):
- chore: eploy to Travis was silently broken for a couple of days since "test" command was missing 67d7e3c
- fix: json should be returned as PGObject, not as String for backward compatibility reasons (#640) PR#639 beaec3a
- test: add DebugNonSafepoints to FlightRecorderProfiler PR#622 154c463
- feat: include root cause exception in case transaction fails (#628) 51775c1
We thank the following people for their contributions to this release.
Daniel Gustafsson
Vladimir Sitnikov
Notable changes:
- Better support for RETURN_GENERATED_KEYS, statements with RETURNING clause
- Avoid user-visible prepared-statement errors if client uses DEALLOCATE/DISCARD statements (invalidate cache when those statements detected)
- Avoid user-visible prepared-statement errors if client changes search_path (invalidate cache when set search_path detected)
- Support comments when replacing {fn ...} JDBC syntax
- Support for Types.REF_CURSOR
AlexElin (3):
- style: change method names to start with a lower case letter (#615) 22c72b4
- refactor: fix some hintbugs warnings (#616) dd71f6f
- refactor: use varargs in Gt.tr (#629) 07c7902
Chrriis (1):
Marios Trivyzas (1):
- perf: add point type info to Client (#612) ba14509
Mathias Fußenegger (2):
- doc: fix test README link in README (#609) c09be96
- perf: add json type info to Client (#610) 4ad2df3
Pavel Raiskup (1):
Philippe Marschall (1):
Vladimir Gordiychuk (1):
- test: fix Travis job so it actually tests against HEAD PostgreSQL (#630) 9030373
Vladimir Sitnikov (23):
- test: skip json testing on pre-9.2 databases (those do not implement json type) 0a17d82
- chore: make sure JDK9+PG 9.4 Travis job indeed uses PG 9.4 01b65c3
- test: add PostgreSQL HEAD to pgjdbc regression test matrix (#613) PR#561 65a32ff
- test: add benchmark for resultSet.getByName ff4bfda
- chore: use Travis' PostgreSQL 9.5 d1feb58
- docs: add javadoc badge to the project readme 5d7a9bb
- refactor: remove autoCommit argument from QueryExecutor#createSimpleQuery/createParameterizedQuery 756363e
- fix: support cases when user-provided queries have 'returning' PR#488 c3d8571
- feat: support execute statements via simple 'Q' command PR#558 232569c
- feat: show proper error message when connecting to non-UTF-8 database PR#594 ec5fb4f
- test: add tests for Parser.parseDelete/Select/Move/WithKeyword 3b7c7c4
- chore: update to 1.1.0 version of parent pom to upgrade bndlib 2.3.0 -> 2.4.0 4019ed6
- chore: use latest java version for one of Java 8 Travis jobs 0452e79
- refactor: introduce ResultHandlerBase to factor out common error processing logic edcdccd
- feat: reset server-prepared statements on deallocate/discard, ability to autorollback on sqlexception from executing a query PR#451 adc08d5
- fix: add a test case when "deallocate all" detector is turned off aa53fba
- fix: invalidate prepared statement cache when "set search_path=..." query is detected PR#496 17c8afb
- fix: properly account cache size when duplicate entries returned to the cache 191ccf2
- feat: support 10+ version parsing Note: 10.2 means 10 major, 2 minor, that is 10_00_02 9.2 means 9.2 major, that is 9_02_00 PR#631 a639431
- fix: honor comments when replacing {fn curdate()} kind of calls PR#632 2d9b313
- chore: skip "deploy to Central" step when building PRs 9bc194a
- test: add performance test for "reused vs non-reused at client side" prepared statements 2d70385
- chore: improve ./release_notes.sh so it does not require parameters d8736b4
We thank the following people for their contributions to this release.
AlexElin
Christopher Deckers
Marios Trivyzas
Mathias Fußenegger
Pavel Raiskup
Philippe Marschall
Vladimir Gordiychuk
Vladimir Sitnikov
Notable changes:
- BUG: json datatype is returned as java.lang.String object, not as PGObject (fixed in 9.4.1211)
- Many improvements to
insert into .. values(?,?) -> insert .. values(?,?), (?,?)...rewriter. Give it a try by usingreWriteBatchedInserts=trueconnection property. 2-3x improvements for insert batch can be expected - Full test suite passes against PostgreSQL 9.6, and OpenJDK 9
- Performance optimization for timestamps (~TimeZone.getDefault optimization)
- Allow build-from-source on GNU/Linux without maven repositories, and add Fedora Copr test to the regression suite
AlexElin (2):
- style: code cleanup and Java 5' features 8e8dbab
- style: cleanup and Java 5' features for tests (#602) 28c0c22
Christian Ullrich (4):
- docs: fix test password in readme closes #553 PR#553 07f8610
- test: make tests independent from server LC_MESSAGES (#554) b756a15
- fix: update waffle version PR#555 db1a6e4
- test: add basic tests for SSPI authentication PR#557 16c27b9
Christopher Deckers (2):
- fix: improve insert values(...) batch rewrite PR#580 510e6e0
- perf: cache timezone in statement#setDate, resultSet#getDate, etc PR#588 d2b86a0
Dave Cramer (5):
- use binary trick for tolower, optimize switch, added tests 2200a4d
- fix:bugs with parse 72945b0
- fix: added test for move and fixed checkstyle errors fc59851
- fixed index ASC/DESC for 9.6 (#569) c9e5fc8
- test: DataSource.getConnection().unwrap(PGConnection.class) PR#573 f6b176e
Florin Asăvoaie (1):
- Refactored an unnecessary conversion of List<String[]> to String[][] when calling the sendStartupPacket. (#544) 2032836
George Kankava (1):
Jeremy Whiting (3):
- perf: Add optimization to re-write batched insert stataments. ac8abf3
- fix: Change optimization to delay parameter and statement re-write to immediately before execution. e591577
- feat: Added to SQL parser to allow inspection of Statement attributes and Command. 4ddb693
Laurenz Albe (1):
Minglei Tu (1):
- feat: support java.sql.Types.TIME_WITH_TIMEZONE and java.sql.Types.TIMESTAMP_WITH_TIMEZONE in setNull method PR#570 1b73bf6
Pavel Raiskup (3):
- Allow build-from-source on GNU/Linux without maven repositories (#546) 87489a9
- chore: test Fedora packaging CI via Travis job PR#578 1eb4085
- packaging: heal Fedora build (#601) af50d0b
Petro Semeniuk (1):
Philippe Marschall (4):
- style: Use more generics PR#519 88e39a0
- style: remove unused code PR#520 f21f168
- refactor: Remove pgTypeName null check PR#525 462928b
- refactor: remove ClassCastException catch PR#527 8bee06b
Tanya Gordeeva (1):
Vladimir Sitnikov (23):
- test: add tests for null::float8[] e6b5bb3
- test: createArrayOf(..., null) test a274321
- test: avoid "The connection attempt failed" in ConnectTimeoutTest.testTimeout PR#531 fbabfa4
- fix: NPE in DatabaseMetaData.getTypeInfo when types are dropped concurrently PR#530 f3b0fd0
- fix: binary timestamptz -> getString should add +XX zone offset to text representation PR#130 1e1f3c4
- refactor: "build without waffle/osgi" PR 766f806
- test: add PostgreSQL 9.6 to CI tests (#560) 3ff47da
- chore: make sure ubenchmark is tested with checkstyle PR#564 f6ed8e6
- chore: add explicit MCENTRAL=Y to Travis jobs that deploy to Maven Central 18ca8f2
- test: prune some Travis jobs to make CI faster c5c1d7c
- chore: propagate java source/target to maven-compiler-plugin d8117d1
- chore: add codecov.yml fb2977f
- refactor: use enum instead of int for PgStatement.statementState to simplify debugging 32d4e08
- test: use TestUtil.getPort() in V3ParameterListTests instead of hard-coded 5432 9a4b296
- chore: make codecov to always wait 7 builds 9f9aa95
- test: add jdk9 Travis job PR#565 bbb0d35
- fix: incorrect binary data format in bind parameter X when using batch execution (#582) 7388dc9
- perf: execute "SET application_name" if name has changed only PR#537 893c1a4
- fix: fix some sonarqube warnings 7311b4e
- fix: revert array naming to pre 1202 behavior (e.g. _int4) PR#595 1d8ebfc
- refactor: rename dmlcommand -> sqlcommand 79db127
- perf: implement fast-path to TimeZone.getDefault if the cache field is accessible through reflection 6b3f2e0
- feat: make connectTimeout=10 (seconds) by default b4d5976
aryabukhin (1):
Marc Petzold (1):
- feat: support HSTORE in PgPreparedStatement#setObject(int, java.lang.Object, int, int) 785d0c7
goeland86 (1):
We thank the following people for their contributions to this release.
AlexElin
Christian Ullrich
Christopher Deckers
Dave Cramer
Florin Asăvoaie
George Kankava
Jeremy Whiting
Laurenz Albe
Minglei Tu
Pavel Raiskup
Petro Semeniuk
Philippe Marschall
Tanya Gordeeva
Vladimir Sitnikov
aryabukhin
Marc Petzold
goeland86
John Harvey (1):
- chore: rework update-translations.sh into pom file as a profile e2fa9ec
Dave Cramer (3):
- fix:regression from previous behaviour where setObject(index,object,VARHCAR) should call getString if it can't cast it to a string PR#482 9d6389c
- fix:correct comment PR#482 bfd73c7
- Update README.md PR#482 5a956a3
George Kankava (3):
- fix: squid:S1206 -equals(Object obj) and hashCode() should be overridden in pairs PR#515 a07d6d3
- fix: squid:S2325 - private methods that don't access instance data should be static PR#514 7aac95c
- fix: squid:S1488 - Local Variables should not be declared and then immediately returned or thrown PR#513 299c9f5
Gilles Cornu (1):
Jeremy Whiting (1):
- fix: load the ssl configuration property when defined through Properties. a6a61be
Markus KARG (1):
Philippe Marschall (7):
- style: use java generics instead of raw types PR#463 c10acf0
- refactor: do not synchronize on ConcurrentHashMap PR#482 ea4cadd
- perf: add guards around debug log statements PR#469 d77aa41
- fix: Do not swallow security exceptions PR#471 beab720
- feat: implement resultSet.getObject(col, Class) with JSR-310 support PR#482 9aa3142
- feat: implement JSR-310 support in setObject e52f7e3
- fix: support local date times not in time zone 61384ec
Rikard Pavelic (1):
Vladimir Sitnikov (24):
- doc: update current versions in readme.md PR#482 4f5d57c
- refactor: move implementation of Prepared and Callable statements to PgPreparedStatement and PgCallableStatement PR#459 8fca8b4
- style: add import order check PR#482 77a188c
- style: align import order with style convention PR#482 00c7eb3
- doc: add gitter chat link to readme PR#482 53190c9
- style: enable more checkstyle verifications PR#482 b0225f6
- style: reformat code to fix checkstyle violations PR#482 8f1c9d7
- style: reformat with Eclipse PR#467 2d5e7fa
- Update IDEA config PR#482 7083008
- docs: fix typos in code comments PR#472 5d43712
- style: update translations 484eafd
- doc: update russian translations 92011d7
- test: add insert .. on conflict tests for PostgreSQL 9.5 d622a9f
- fix: improve handling of DATE columns around DST dates in binary transfer 642b48a
- test: improve insertBatch test aea9383
- test: track code coverage PR#494 0f979c3
- test: PostgreSQL 8.4 and 9.5 databases, XA configuration PR#499 8c9898a
- fix: make sure executeBatch returns error response for rows that would not get into database PR#502 d6e3b17
- test: add benchmarks for insert via copy and insert via array of structs 880244e
- fix: PgArray returning null for binary arrays PR#504 b225535
- doc: backend protocol, wanted features PR#478 ee6118e
- fix: OSGi require-capability manifest entry PR#497 a3e2045
- fix: make sure {fn now()} jdbc translation is not performed in dollar-quoted strings PR#511 9109451
mtran (1):
We thank the following people for their contributions to this release.
John Harvey
Dave Cramer
George Kankava
Gilles Cornu
Markus KARG
Rikard Pavelic
Jeremy Whiting
Vladimir Sitnikov
Stephen Nelson
Philippe Marschall
mtran
Jeremy Whiting (3):
- Changed property loader to avoid using a default when property not already set. Allows the caller to detect when unset. Thus allowing connection Cto use programmatic log level value. Added test cases to check PGProperty method working properly. PR#438 ecf4a2c
- Update testcase to set properties where TestUtil methods look them up. PR#438 b86e07a
- Restore boot time ssl property after test cases complete. Revert change to assertion test. Safely remove existing ssl property. PR#438 274f382
Philippe Marschall (2):
Stephen Nelson (1):
Vladimir Sitnikov (12):
- doc: add coding guidelines to readme PR#442 af62c6d
- chore: remove docbkx/pgjdbc.xml from reposiory PR#435 92b65f0
- chore: move files to "pgjdbc" maven module to prepare for pre-processor fix PR#435 f95b44e
- chore: use java comment preprocessor to build jre6/jre7/jre8 jars from the same sources PR#435 42c2e3b
- doc: fix javadocs warnings when building via java 8 PR#435 3b10873
- test: improve CopyLargeFileTest performance by dropping non required index and foreign key PR#435 410a662
- test: speedup DriverTest.testConnectFailover by adding a connect timeout of 5 seconds PR#435 ed1a916
- chore: skip gpg signature when deploying snapshot artifacts via Travis PR#449 d196cf4
- chore: use custom settings.xml when deploying snapshots via Travis PR#449 cf40cf2
- test: add test for insert batch that changes server-prepared statement names PR#449 e5ac899
- fix: prepared statement "S_2" does not exist in batch executions PR#449 fa310e0
- doc: add note on how to skip tests when building from source PR#460 823e124
Yao Chunlin (1):
- Fix bug when call XAResource.start with TMJOIN flag, the old localAutoCommitMode lost. PR#434 df09e2b
We thank the following people for their contributions to this release.
Jeremy Whiting
Vladimir Sitnikov
Stephen Nelson
Philippe Marschall
Yao Chunlin
Andrea Catalucci (1):
Dave Cramer (3):
- make sure logs actually get written PR#422 2ad367e
- fix: Binary handling of empty arrays. The type of the empty array was not properly read as a result getting the type of the array caused an NPE fixes Issue #421 reported by Juha Komulainen PR#422 38d8488
- fix:building on java 1.6 PR#422 9133012
- fix test case to actually check the value don't mask the exception in the event that it is thrown PR#422 e975c07
- add an explicit message for the test case PR#422 270b1a3
Laurenz Albe (3):
- Replace question marks only in PreparedStatements PR#427 3d30a4c
- Allow both single and double question marks in simple statements PR#427 39d510c
- Prettify code and add another regression test PR#427 2f8a67f
Vladimir Sitnikov (3):
- chore: fix dos end-of-lines PR#418 63d1dd3
- test: add tests for getBigDecimal of int4 field in both text and binary modes PR#426 faac288
- fix: fix invalid values when receiving int2, int4, int8 via getBigDecimal() PR#424 e6f1beb
John K. Harvey(1)
- fix: update translations to handle Russian characters PR#430 this hasn't been committed yet but the message class files were updated
We thank the following people for their contributions to this release.
[John K Harvey] (https://github.com/crunchyjohn)
Andrea Catalucci
Laurenz Albe
Vladimir Sitnikov
Chapman Flack (2):
- fix: recover cs, de, fr, it translations PR#409 1793454
- fix: redo spelling changes in unclobbered .po PR#409 5bfb26d
Dave Cramer (10):
- use UTF-8 instead of US-ASCII for initial encoding PR#398 8dae0ae
- fix: coerce array type names to lower case PR#402 f1a5cc4
- fix:getColumns should return columns for anything that looks like a table PR#405 f9f55d6
- revert: undo changes to getTypeInfo which removed core types PR#406 779ce18
- fix: tests PR#406 7736b8d
- reformat: tests PR#406 4acf7ae
- fix:Do not set the loglevel when instantiating a connection it is set when the Driver starts PR#407 84b28eb
- fix: japanese translation 8aa478b
- updated translation class files 2fa59d1
- build:incremented for 1205 PR#410 fa0d7d5
Michael Paquier (2):
- Remove non-ASCII character in code PR#400 9f08e46
- Add missing entry in lib/.gitignore PR#401 358aef1
Rikard Pavelic (1):
Vladimir Sitnikov (9):
- fix: avoid memory leak when redeploying pgjdbc PR#394 d7cab7b
- test: add {?= call mysum(?, ?)} kind of test for CallableStatement PR#410 45c8368
- perf: add BigDecimal test performance test to ProcessResultSet PR#411 6dc4183
- perf: optimize ResultSet.getObject PR#411 567e268
- perf: optimize getBigDecimal PR#411 33904ef
- test: add statement.getQueryTimeoutMs, so millisecond-scale timeouts can be tested PR#413 892d7af
- fix: statement.cancel and statement.setQueryTimeout should be thread-safe PR#412 bc3d848
- chore: print markdown links in release notes script PR#416 a5b8ea7
- chore: add .gitattributes to ensure automatic end-of-line storage of text files is used PR#417 254b739
We thank the following people for their contributions to this release.
Chapman Flack
Michael Paquier
Rikard Pavelic
Vladimir Sitnikov
- fix: Make sure copy manager completesPR #378 (7c420ed)
- test: update for CopyLargeFileTest test to fit into 10 minutes limit PR #378 (39cd851)
- fix: implemented getFunctions in jdbc4 (03483e1)
- fix: error in getFunctionColumns PR #376 (5fafb86)
- fix: filter DatabaseMetaData.getColumns by tables PR #386 (0c95126)
- fix: abort connections after IOException instead of close PR #392 (3e68a70)
- pref: improve executeBatch by avoiding statement-by-statement execution PR #380 (92a9f30)
- perf: improve setTimestamp, setTime, setDate performance PR #379 (5a03a6e)
- chore: update jmh, drop irrelevant benchmark Parser#unmarkDoubleQuestion PR #384 (0d1237c)
- chore: add more benchmarks, add missing FlightRecorderProfiler PR #385 (613a641)
- feat: ignore empty sub-queries in composite queries PR #386 (3fb8046)
- fix: binary processing of Date/Time/Timestamps PR #387 (5ec0ac3)
- test: add tests for parsing of empty queries separated by semicolons PR #388 (d9310ce)
- fix: ConcurrentModificationException when calling PreparedStatement.close from a concurrent thread PR #392 (40bcc01)
We thank the following people for their contributions to this release.
Alexey Mozhenin
Vladimir Sitnikov
Author: Dave Cramer
- fix: Implemented getFunctions
- fix: changed getProcedureColumns to getFunctionColumns
- fix: CopyManager fails to copy a file, reading just part of the data #366
Author: Lonny Jacobson
- add: Added PGTime/PGTimestamp
Author: Patric Bechtel
- fix: setObject(int parameterIndex, Object x, int targetSqlType) as it will set scale of BigDecimal 'x' to 0 as default, resulting in rounded whole values (!). PR #353 (24312c6)
- fix: round to correct amount test: add test for BigDecimal rounding behaviour in setObject(index,Object,targetSqlType) and setObject(index,Object,targetSqlType,scale) PR #353 (ff14f62)
We thank the following people for their contributions to this release.
Lonny Jacobson
Patric Bechtel
Alexey Mozhenin
Author: Alexis Meneses
- ResultSet positioning methods in some particular cases PR #296 (282536b)
Author: Craig Ringer
- Disable binary xfer on batches returning generated keys PR #273 (763ae84)
- Add a new test case demonstrating a bug in returning support PR #273 (4d2b046)
- Always Describe a query in a batch that returns generated keys PR #273 (a6bd36f)
Author: Dave Cramer
- chore: fix build.xml to allow releasing to maven PR #262 (34f9361)
- fix: BlobInputStream ignores constructor parameters #263 PR #273 (c1c6edc)
- don't reset forceBinary transfer if we setPreparedThreshold (937a11c)
- Revert "perf: Remove expensive finalize methods from Statement and Connection" PR #293 (a0d3997)
- updated copyright PR #312 (263375c)
- Revert "Issue 250 -- Adding setURL/getURL to BaseDataSource.java" PR #312 (a1ac380)
- fixed mailing list href PR #326 (c3e86a6)
- increment driver version PR #346 (b8ee75d)
Author: David R. Bild
- feat: add equality support to PSQLState PR #277 (7698cd9)
Author: David Schlosnagle
- Improve version checking PR #355 (f7a84db)
Author: Eugene Koontz
- Add support within "private Object buildArray (PgArrayList input, int index, int count)" for array elements whose type is jsonb PR #349 (d313138)
Author: Jeremy Whiting
- Added setter method for logging level. The method exactly matches property name in documentation. PR #282 (d9595d1)
- Added getter method. PR #282 (65759f0)
- Adding XML catalog to help unit tests not remote entity resolution. PR #284 (cb87067)
- Added support to locally resolve dtd or entity files. PR #284 (017970d)
- Disable verbose logging of the catalog resolver. PR #284 (fcc34f5)
Author: Kris Jurka
- Improve error message for failure to update multicolumn primary key RSs. PR #284 (05ff811)
- Remove all JDBC3 code as JDK 1.4/1.5 are no longer supported. PR #284 (f9a956b)
- Add preliminary support for JDBC4.2. PR #284 (bd05fd2)
Author: Lonny Jacobson
- Added setURL/getURL methods. (fcc8f75)
- Added a unit test for setURL PR #309 (5fa405b)
Author: Markus KARG
- perf: use shared PGBoolean instances PR #321 (159fed6)
- docs: parameter "database" is optional PR #332 (9a9d03f)
- refactor: binary transfer for setObject(int, Object, int) PR #351 (3ff2129)
Author: Michael Paquier
- Update entries in lib/.gitignore PR #262 (8cd15a9)
Author: Phillip Ross
- Fix for issue #342 - Modifications to PGline to store coefficients and constant value for linear equation representations used by postgresql for native line datatype. PR #343 (0565416)
- Fix for issue #342 - Removed extra copyright comments. PR #343 (5f21a18)
- Fix for issue #342 - Handle vertical lines. PR #343 (3918b24)
- Fix for issue #342 - Added test method for testing PGline PR #343 (1a50585)
- Fix for issue #342 - Modifications to PGline test method to only attempt database access if the postgresql version supports it (v9.4+). PR #343 (15eedb5)
Author: Rikard Pavelic
- feat: Improved composite/array type support and type naming changes. PR #333 (cddcd18)
Author: Robert J. Macomber
- Deadlock after IO exception during copy cancel PR #363 (d535c13)
Author: Sehrope Sarkuni
- style: clean up newline whitespace PR #273 (1b77b4c)
- style: clean up whitespace in .travis.yml PR #274 (3ee5bbf)
- fix: correct incorrect PG database version in .travis.yml matrix PR #274 (74b88c6)
- style: reorder jdk versions in .travis.yml PR #274 (21289e7)
- feat: add PostgreSQL 9.4 to .travis.yml matrix PR #274 (9e94f35)
- feat: add escapeLiteral(...) and escapeIdentifier(...) to PGConnection PR #275 (096241f)
Author: Stephen Nelson
- Replace for loops with Java 5-style for loops. Replace String.indexOf with String.contains. Replace StringBuffer with StringBuilder. Remove boxing/unboxing of primitives. PR #245 (206a542)
Author: Vladimir Gordiychuk
- feat: Customize default fetchSize for statements PR #287 (093a4bc)
- feat: Customize default fetchSize for statements PR #287 (519bfe1)
- perf: Read test only property "org.postgresql.forceBinary" spend many time when creating statements PR #291 (e185a48)
Author: Vladimir Sitnikov
- perf: Remove expensive finalize method from Statement Finalize method on Statement is moved to a separate class that is lazily created if user sets "autoCloseUnclosedConnections"="true". This dramatically improves performance of statement instantiation and reduces garbage collection overhead on several wildly used JMVs. PR #290 (eb83210)
- docs: fix misleading statement on "can't use jdk5 features" in README.md PR #298 (5b91aed)
- feat: implement micro-benchmark module for performance testing PR #297 (48b79a3)
- feat: add benchmark for Parser.unmarkDoubleQuestion PR #297 (e5a7e4e)
- feat: improve sql parsing performance PR #301 (fdd9249)
- perf: Remove AbstractJdbc2Statement.finalize() PR #299 (b3a2f80)
- test: add test for prepare-fetch-execute performance PR #303 (d23306c)
- perf: improve performance of preparing statements PR #303 (7c0655b)
- test: add test for utf8-encoder performance PR #307 (6345ab1)
- perf: improve performance of UTF-8 encoding PR #307 (f2c175f)
- perf: skip instantiation of testReturn and functionReturnType for non-callable statements PR #323 (8eacd06)
- perf: parse SQL to a single string, not a array of fragments PR #319 (4797114)
- perf: cache parsed statement across .prepareStatement calls PR #319 (5642abc)
- refactor: cleanup constructors of JDBC4 and JDBC42 connections/statements PR #318 (a4789c0)
- refactor: use Dequeue<...> instead of raw ArrayList in v3.QueryExecutorImpl PR #314 (787d775)
- perf: SimpleParameterList.flags int[] -> byte[] PR #325 (f5bceda)
- perf: cut new byte[1] from QueryExecutorImpl.receiveCommandStatus PR #326 (0ae1968)
- perf: avoid useBinary(field) check for each sendBind PR #324 (45269b8)
- refactor: cleanup Parser and NativeQuery after #311 PR #346 (a1029df)
- refactor: cleanup Parser and CallableQueryKey after #319 PR #346 (5ec7dea)
- perf: skip caching of very large queries to prevent statement cache pollution PR #346 (126b60c)
- use current_schema() for Connection#getSchema PR #356 (ffda429)
- chore: simple script to compose release notes PR #357 (341ff8e)
- chore: teach release_notes.sh to identify PR ids out of merge commits PR #358 (f3214b1)
We thank the following people for their contributions to this release.
Alexis Meneses
Craig Ringer
Jeremy Whiting
Sehrope Sarkuni
Mikko Tiihonen
Dave Cramer
Stephen Nelson
Vladimir Gordiychuk
Vladimir Sitnikov
David Schlosnagle
Eugene Koontz
Markus KARG
Phillip Ross
Rikard Pavelic
Robert J. Macomber
Michael Paquier
Lonny Jacobson
Kris Jurka
David R. Bild
Author: Alexis Meneses
Do not pull a concrete implementation of slf4j in maven pom. Fixes #251 PR #252 (6c2848c)- Declare all maven dependencies as optional in the pom PR #252 (1d02876)
- Automatically load maven-ant-tasks to remove the need of "-lib lib" when building the project using ant PR #253 (7e80fca)
- ant clean target delete maven dependencies added into "lib" directory PR #253 (cb7964e)
travis uses build process simplification PR #253 (e09032c)- regression of
sslparameter processing when used in additional Properties PR #260 (33d55af)
Author: Dave Cramer davec@postgresintl.com
- Make junit optional in the pom PR #254 (9530047)
- Added commit message readme PR #255 (c6312eb)
- setUrl method of BaseDataSource. fixes issue #258 PR #358 (52a8d91)
Mikko Tiihonen (1):
- setUrl method of BaseDataSource. Add test to make sure it does not break again PR #257 (477c7c8)
We thank the following people for their contributions to this release.
Alexis Meneses
Sehrope Sarkuni
Mikko Tiihonen
Dave Cramer
Author: Alexis Meneses
- Support for setBinaryStream with unknown length PR #220
Improved support for BLOBS PR #219-
Added the support for very large objects (4TB) when backend is at least 9.3 using lo_xxx64 functions (see release 9.3 notes). -
Added support for various JDBC4 methods related to Blobs: - setBlob with input stream in PreparedStatement
- getBinaryStream with position and offset in Blob (also helps a lot handling very large objects)
- Fix for setStringType in DataSource PR #221
- Set search path in startup packet PR #216
- Connection.isValid() should have no impact on transaction state PR #218 fixes issue #214
- Replace StringBuffer with StringBuilder for performance PR #243
- Make Pgjdbc an OSGi bundle PR #241
- Fixing the Travis-CI integration
Author: Sehrope Sarkuni
- Fix Timer thread classloader leak PR #197
- Escape search_path in Connection.setSchema PR #207
- Add SSL factory SingleCertValidatingFactory PR #88
- Speed up connection creation on 9.0+ PR #144
Author: Mikko Tiihonen
- Enhance connection fail-over with master/slave restriction and loadbalancing PR #209 Based on work by chenhj@cn.fujitsu.com
Author: Minglei Tu
- add ?-contained operator support PR#227
Author: Martin Simka
- GSS: fall back to old authentication when Subject doesn't contain instance of GssCredentials PR#228
- gssapi: Re-use existing Subject and GssCredentials PR#201
Author: bryonv
- Honor stringtype=unspecified when also saving null values
- Currently, saving a string with setString applies oid.UNSPECIFIED, but saving null with setNull(index, java.sql.Types.VARCHAR) saves with oid.VARCHAR.
- For consistency, if the user requested that we treat string types as unspecified, we should do so in all cases.
Author: Craig Ringer
- Add native SSPI authentication support on Windows using JNA via Waffle PR #212
- Add limited support for returning generated columns in batches PR #204. Fixes issues #194 and #195
We thank the following people for their contributions to this release.
Alexis Meneses
Sehrope Sarkuni
Minglei Tu
Martin Simka
Mikko Tiihonen
bryonv
Craig Ringer craig@2ndquadrant.com
Dave Cramer davec@postgresintl.com
Author: Ancoron ancoron.luciferis@gmail.com
Backport PGXAConnection.equals() fix from master
Author: Ancoron ancoron.luciferis@gmail.com
Fix connection URL generation for 'stringtype' parameter in BaseDataSource
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Fix equals-method of the wrapper returned by PGXAConnection.getConnection()
Patch by Florent Guillaume
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Fixes on get/set/current-schema (9.3 branch)
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Add a TestSuite for JDBC 4.1
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Unescape/unquote result of getSchema
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Setting the search_path from currentSchema property is done in startup packet (v3 protocol only)
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Add tests for schema name containing special characters
Author: Alexis Meneses alexismeneses@users.noreply.github.com
Escape schema name when setting search_path
Author: Damiano Albani damiano.albani@gmail.com
Add support for "currentSchema" connection property.
Author: Dave Cramer davec@postgresintl.com
Fixed timezone test as per Tom Lane's suggestion. …
Now using Europe/Helsinki as the exemplar.
Author: Dave Cramer davec@postgresintl.com
Clob will now use the connection encoding
pull #121 from brekka/clob_encoding
Author: Dave Cramer davec@postgresintl.com
backpatched Statement.isClosed() implementation of PGPoolingDataSource with some performance improvements. #180
Author: nicolas-f github@nettrader.fr
Implement hashcode in PGObject 9.3
Handle null value
Author: Dave Cramer davec@postgresintl.com Date: Mon Aug 18 12:30:48 2014 +0000
NPE fix in org.postgresql.Driver.getPropertyInfo #176 \
from Sergey Ignatov
Author:epgrubmair bug #161
fix copyOut close hanging bug #161 from epgrubmair
Author:romank0
backpatch exception during close of fully read stream from romank0
Author:Christophe Canovas
Added caching for ResultSetMetaData complete commit
Author:Elizabeth Chatman
NullPointerException in AbstractJdbc2DatabaseMetaData.getUDTs
setNull, setString, setObject may fail if a specified type cannot be transferred in a binary mode #151
backpatch fix for changing datestyle before copy
Author:TomonariKatsumata
binary transfer fixes new feature -1 for forceBinaryTransfer
Author:Sergey Chernov
connectTimeout property support backpatch
Author:Naoya Anzai
fix prepared statement ERROR due to EMPTY_QUERY defined as static.
Author:Jeremy Whiting jwhiting@redhat.com
Added feature to disable column name sanitiser with a new property.
disableColumnSanitiser= boolean
remove toLower calls for performance
Author:Craig Ringer craig@2ndquadrant.com
Add a MainClass that tells the user they can't just run the JDBC driver
After one too many reports of
"Failed to load Main-Class manifest attribute from postgresql-xxx.jar"
I'm submitting a dummy main-class that tells the user what they should
do instead.
The message looks like:
------------
PostgreSQL x.y JDBC4.1 (build bbbb)
Found in: jar:file:/path/to/postgresql-x.y-bbbb.jdbc41.jar!/org/postgresql/Driver.class
The PgJDBC driver is not an executable Java program.
You must install it according to the JDBC driver installation instructions for your application / container / appserver, then use it by specifying a JDBC URL of the form
jdbc:postgresql://
or using an application specific method.
See the PgJDBC documentation: http://jdbc.postgresql.org/documentation/head/index.html
This command has had no effect.
------------
fixed bug PreparedStatement.getMetaData failed if result set was closed
reported by Emmanuel Guiton
Author: cchantep chantepie@altern.org Date: Thu Dec 12 15:54:55 2013 +0100
Base table more usefull than "" as basic table name
fixed driver fails to find foreign tables fix from plalg@hotmail.com
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Fix various setQueryTimeout bugs.
1. If you call setQueryTimeout(5), wait 10 seconds, and call execute(), the
cancel timer has already expired, and the statement will be allowed to run
forever. Likewise, if you call setQueryTimeout(5), wait 4 seconds, and call
execute(), the statement will be canceled after only 1 second.
2. If you call setQueryTimeout on a PreparedStatement, and execute the same
statement several times, the timeout only takes affect on the first
statement.
3. If you call setQueryTimeout on one Statement, but don't execute it, the
timer will still fire, possible on an unrelated victim Statement.
The root cause of all of these bugs was that the timer was started at the
setQueryTimeout() call, not on the execute() call.
Also, remove the finally-block from the cancellation task's run-method,
because that might erroneously cancel the timer for the next query, if a
new query is started using the same statement fast enough.
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Use StringBuffer to construct a string.
This piece of code isn't performance-critical at all, but silences a
Coverity complaint.
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Avoid integer overflow.
The function returns long, but does the calculation first in int. If someone
sets the timeout to 600 hours in the URL, it will overflow, even though the
return value of the function is long and hence could return a larger value.
To silence a Coverity complaint.
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Plug some Statement leaks in metadata queries.
These are fairly harmless, nobody calls these metadata methods frequently
enough for the leaks to matter, and a regular Statement doesn't hold onto
any server resources anyway. But let's appease Coverity.
Author: Heikki Linnakangas heikki.linnakangas@iki.fi
Make sure file is closed on exception.
The system will eventually close the file anyway, and this read is highly
unlikely to throw an IOException in practice.
Also, use RandomAccessFile.readFully(byte[]) to slurp the file into byte
array, rather than FileInputStream.read(byte[]). The latter would need to
be called in a loop to protect from short reads.
Both issues were complained of by Coverity.
Author: Stephen Nelson stephen@eccostudio.com
Generate a non-Maven JAR filename using build-time version and JDBC API level.
Author: Stephen Nelson stephen@eccostudio.com
Build script changes to allow packaging and deployment to Maven central using maven-ant-tasks
Updated build.properties to contain the sonatype urls. Updated build.xml so that gpg signing works for each accompanying artifact type. Updated pom.xml to allow templated group and artifact ids.
Author: Craig Ringer craig@2ndquadrant.com
NonValidatingFactory should be included in both JDBC3 and JDBC4
Author: Michael McCaskill michael@team.shoeboxed.com
Use proper System property
Using 'path.separator' results in malformed paths such as:
/default/dir:./postgresql/root.crt
This corrects the problem.
Author: Dave Cramer davecramer@gmail.com
reset interrupted bit and throw unchecked exception if we get interrupted while trying to connect
Author: Dave Cramer davecramer@gmail.com
add functions to allow LargeObjectMaager to commit on close from Marc Cousin
Author: tminglei tmlneu@gmail.com
add uuid array support (rename ArrayElementBuilder to ArrayAssistant)
Author: Nick White nwhite@palantir.com
allow the first query to be binary
Author: Dave Cramer davec@postgresintl.com
Merge pull request #107 from cchantep/rs-basic-tblname
Basic table name for resultset metadata
Author: Dave Cramer davecramer@gmail.com
fixed bug PreparedStatement.getMetaData failed if result set was closed
reported by Emmanuel Guiton #bugfix#
Author: Dave Cramer davecramer@gmail.com Date: Thu Oct 17 08:29:07 2013 -0400
reset interrupted bit and throw unchecked exception if we get interrupted while trying to connect
Author: Dave Cramer davecramer@gmail.com Date: Tue Oct 15 06:51:45 2013 -0400
add functions to allow LargeObjectMaager to commit on close from Marc Cousin
Author: halset halset@ecc.no Date: Mon Sep 9 12:12:26 2013 +0200
fix for setBlob with large blob
Author: Dave Cramer davecramer@gmail.com Date: Tue Sep 10 09:00:37 2013 -0400
fixed DatabaseMetaDataTest as per Sylvain Cuaz
Author: Dave Cramer davecramer@gmail.com Date: Mon Jul 29 09:43:20 2013 -0400
fixed sort order for DatabaseMetaData
Author: Dave Cramer davec@postgresintl.com Date: Sun Jul 21 13:18:26 2013 +0000
backpatched canceltimer bug reported by Andri-Redko
Author: Dave Cramer davec@postgresintl.com Date: Wed May 22 04:03:58 2013 -0700
Merge pull request #60 from davecramer/REL9_2_STABLE
backpatch BaseDataSource
Author: Dave Cramer davec@postgresintl.com Date: Tue May 21 21:03:21 2013 -0400
check for null before appending to url
Author: Dave Cramer davecramer@gmail.com Date: Tue May 21 20:23:00 2013 -0400
initialize binaryTranferEnable to null
Author: Dave Cramer davecramer@gmail.com Date: Tue May 21 20:08:27 2013 -0400
fixed tcpkeepalive as per Rui Zhu
pass stringtype on to url through properties from Mike O'Toole
Author: Dave Cramer davecramer@gmail.com
Date: Wed Feb 20 06:58:59 2013 -0500
avoid NullPointerException from Derrik Hudson on User Defined Types
Author: Kris Jurka jurka@ejurka.com Date: Tue Mar 26 05:33:45 2013 -0700
Lookup correct array delimiter in Connection.createArrayOf.
The old code had hardcoded a comma, but that's not true for all
datatypes.
Identification and fix by sumo in pull request #49, testcase by me.
Author: Dave Cramer davecramer@gmail.com Date: Thu Nov 1 11:24:34 2012 -0400
fix toString to handle binary integer and float types
Author: Dave Cramer davecramer@gmail.com Date: Wed Oct 31 10:23:23 2012 -0400
Fix performance regression introduced by using InetSocketAddress.getHostName()
Patch provided by Scott Harrington, improved upon by Kris Jurka
Author: Dave Cramer davec@postgresintl.com Date: Thu Oct 18 07:44:06 2012 -0400
removed testSetObjectFromJavaArray out of jdbc2 tests
Author: Dave Cramer davec@postgresintl.com Date: Wed Oct 17 14:22:03 2012 -0400
added BR translation class file
Author: Dave Cramer davecramer@gmail.com Date: Thu Sep 27 09:38:25 2012 -0400
fixed missing isValid function
Author: Dave Cramer davecramer@gmail.com Date: Fri Sep 21 14:58:00 2012 -0400
fixed attacl for servers below 8.3
Author: Craig Ringer ringerc@ringerc.id.au Date: Thu Sep 20 17:51:39 2012 +0800
Add some info to the README with contributor info
Discuss:
- Bug reporting
- Submitting patches
- Test matrix
- GitHub
Author: Craig Ringer ringerc@ringerc.id.au Date: Thu Sep 20 13:47:26 2012 +0800
Update URLs in README to refer to the Oracle page locations
Oracle has been doing a very poor job of maintaining old SUN URLs,
and it's likely that these will break at some point, so best update
them to reflect Oracle's control of Java now.
Added a link to the JDBC tutorial in the process.
Author: Craig Ringer ringerc@ringerc.id.au Date: Thu Sep 20 14:02:18 2012 +0800
Allow testing to continue when local host name doesn't resolve
It seems to be a common and default configuration on some Linux systems
for the local hostname not to resolve to the loopback IP address. This
causes testTimeoutOccurs(org.postgresql.test.jdbc2.LoginTimeoutTest)
to fail. I'm seeing this on Fedora 17 among others.
While it's best to fix such systems, not causing an easily avoided
and spurious failure in PgJDBC's test suite is probably worthwhile.
Spit out a warning and continue.
Author: Dave Cramer davecramer@gmail.com Date: Fri Aug 24 14:24:31 2012 -0400
Fixed build to not delete pgjdbc.html, which breaks the website build
Author: Dave Cramer davec@postgresintl.com Date: Thu Sep 13 07:48:52 2012 -0400
updated translations
Author: Dave Cramer davec@postgresintl.com Date: Thu Sep 13 07:43:40 2012 -0400
Added explicit test case for array handling from Craig Ringer
Author: Dave Cramer davec@postgresintl.com Date: Thu Sep 13 07:46:55 2012 -0400
added docs for send/recv buffer size
Author: Dave Cramer davec@postgresintl.com Date: Wed Sep 12 05:11:02 2012 -0400
added test case for send/recv buffers sizes
Author: Dave Cramer davec@postgresintl.com Date: Tue Sep 11 20:55:41 2012 -0400
patch from Bernd Helme for send recev buffer sizes
Author: Dave Cramer davec@postgresintl.com Date: Tue Sep 11 20:12:13 2012 -0400
new translation from Euler Taveira
Author: Craig Ringer ringerc@ringerc.id.au Date: Thu Sep 20 16:07:43 2012 +0800
Fix breakage of JDBC3 builds with JDK5 by bddc05f939
Fixes:
commit bddc05f939ac9227b682e85d1ba0a9b902da814c
simple connection failover from Mikko Tiihonen
See:
https://github.com/pgjdbc/pgjdbc/issues/6
These fixes only affect builds of the JDBC3 driver. The JDBC4 driver
appears fine.
Author: Dave Cramer davec@postgresintl.com Date: Thu Sep 13 07:43:40 2012 -0400
added explicit test case for array handling from Craig Ringer
Author: Dave Cramer davecramer@gmail.com Date: Mon Jun 4 08:56:38 2012 -0400
simple connection failover from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Sun Jun 3 07:49:37 2012 -0400
implemented setBinaryStream by Johann Oskarsson
Author: Dave Cramer davecramer@gmail.com Date: Fri Jun 1 17:57:31 2012 -0400
fixed docs from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Fri Jun 1 17:18:05 2012 -0400
fixed urls in docs from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Fri Jun 1 17:16:49 2012 -0400
fixed docs for loading in java 6.0 from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Tue May 15 20:35:51 2012 -0400
rest of Add hstore patch
Author: Dave Cramer davecramer@gmail.com Date: Tue May 15 06:47:09 2012 -0400
Add support for hstore from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Tue May 15 06:24:34 2012 -0400
change Hashtable with Map from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Tue May 15 06:23:24 2012 -0400
change vector to list from Mikko Tiihonen
Author: Dave Cramer davec@postgresintl.com Date: Wed May 2 14:12:17 2012 -0400
setProtocolVersion argument mis-spelled from Mikko Tiihonen
Author: Dave Cramer davec@postgresintl.com Date: Wed May 2 14:09:28 2012 -0400
fix to build for java 1.8 from Mikko Tiihonen
Author: Dave Cramer davecramer@gmail.com Date: Fri Apr 27 09:54:47 2012 -0400
check for array bounds before accessing the array
Author: Kris Jurka jurka@ejurka.com Date: Mon Mar 12 17:57:55 2012 -0700
Fix setQueryTimeout test.
When setQueryTimeout was fixed to use the correct units, I
neglected to adjust the test at the same time.
Author: Kris Jurka jurka@ejurka.com Date: Mon Mar 12 17:43:58 2012 -0700
Use a Set instead of a BitSet for tracking which types support
binary transfer.
A BitSet is a compact representation if we're only considering
builtin types that will have low oids, but if any user defined
types are enabled, all bets are off. Once the oid counter exceeds
INT_MAX, database connections were failing outright even if no
high oid types used binary transfer because we represent these
oids with negative values that a BitSet cannot handle.
Author: Kris Jurka jurka@ejurka.com Date: Mon Mar 12 17:33:40 2012 -0700
Fix ResultSetMetaData retrieval when the oid counter exceeds INT_MAX.
Since Java doesn't have unsigned ints we retrieve the values as long
and then truncate to int, so it may have a negative value.
As reported by Owen Tran.
Author: Kris Jurka jurka@ejurka.com Date: Mon Mar 12 17:33:27 2012 -0700
Fix ResultSetMetaData retrieval when the oid counter exceeds INT_MAX.
Since Java doesn't have unsigned ints we retrieve the values as long
and then truncate to int, so it may have a negative value.
As reported by Owen Tran.
Author: Dave Cramer davecramer@gmail.com Date: Mon Feb 13 16:43:57 2012 -0500
resolve ACL getTablePriveledges for later servers
Author: Kris Jurka jurka@ejurka.com Date: Fri Feb 10 01:13:48 2012 -0800
Fix bugs in setQueryTimeout.
Setting a timeout of zero seconds should disable the timeout.
The timeout should be in seconds, but was implemented as milliseconds.
Author: Kris Jurka jurka@ejurka.com Date: Fri Feb 10 00:34:59 2012 -0800
Move logic out of concrete JDBC version classes.
The concrete JDBC implementation classes should do as little work
as possible. They exist solely to connect the right set of concrete
implemention classes, leaving all the real work to the Abstract
versions. Some logic had started to creep out into these concrete
classes which is bad because it duplicates code in paths that aren't
likely to be tested by a developer who is working primarily with a
single JDK version.
Author: Kris Jurka jurka@ejurka.com Date: Thu Feb 9 23:59:41 2012 -0800
Cache a copy of ResultSetMetaData in the ResultSet.
This solves a major performance problem for ResultSetMetaData users
which did not cache the ResultSetMetaData object. One of the users
is the driver's own implementation of updatable ResultSets, so this
can't be worked around solely in end user code.
In the 9.0 and earlier releases, the Field objects were used to hold
database lookup results and these were longer lived than the
ResultSetMetaData object. Now that ResultSetMetaData is holding
these database lookups we must hold onto the object to avoid
repeating the database queries.
Reported as bug #6293, fix by Steven Schlansker.
Author: Kris Jurka books@ejurka.com Date: Mon Feb 6 13:09:48 2012 -0800
Convert .cvsignore files to .gitignore files.
Author: Kris Jurka books@ejurka.com Date: Mon Feb 6 13:01:36 2012 -0800
Remove PostgreSQL CVS keyword expansion tags.
commit a57743f980a9de37877aa42a29e9c57514d5550e Author: Kris Jurka books@ejurka.com Date: Mon Feb 6 13:01:28 2012 -0800
Remove PostgreSQL CVS keyword expansion tags.
Author: Dave Cramer davec@fastcrypt.com Date: Thu Jan 19 20:00:51 2012 +0000
added isValid implementation from Luis Flores
Author: Dave Cramer davec@fastcrypt.com Date: Thu Jan 19 12:06:44 2012 +0000
SSPI authentication support from Christian Ullrich
Author: Dave Cramer davec@fastcrypt.com Date: Mon Jan 16 21:00:51 2012 +0000
removed ssl tests for buildfarm
Author: Dave Cramer davec@fastcrypt.com Date: Thu Jan 5 01:12:44 2012 +0000
removed quotes around language specifier server no longer supports this
Author: Dave Cramer davec@fastcrypt.com Date: Tue Jan 3 15:27:55 2012 +0000
remove MakeSSL.java this is now generated
Author: Dave Cramer davec@fastcrypt.com Date: Mon Nov 28 11:24:19 2011 +0000
removed Override to compile with java 1.4 added extra docs for ssl from Mikko Tiihonen
Author: Dave Cramer davec@fastcrypt.com Date: Thu Nov 17 11:45:21 2011 +0000
docs for ssl from Andras Bodor
Author: Dave Cramer davec@fastcrypt.com Date: Thu Nov 17 11:27:51 2011 +0000
SSL implementation from Andras Bodor more closely follow libpq
Author: Dave Cramer davec@fastcrypt.com Date: Tue Oct 4 08:33:43 2011 +0000
stack overflow fix from Mike Fowler
Author: Dave Cramer davec@fastcrypt.com Date: Fri Sep 30 10:08:17 2011 +0000
small fixes to binary transfer code and unit tests from Mikko Tiihonen
Author: Dave Cramer davec@fastcrypt.com Date: Tue Sep 27 11:15:23 2011 +0000
more jdk 1.4 compatability issues fixed from Mike Fowler
Author: Dave Cramer davec@fastcrypt.com Date: Mon Sep 26 15:16:05 2011 +0000
patch from Mike Fowler to fix broken builds
Author: Dave Cramer davec@fastcrypt.com Date: Mon Sep 26 12:52:31 2011 +0000
Mikko Tiihonen patches for binary types
Author: Dave Cramer davec@fastcrypt.com Date: Thu Sep 22 12:53:26 2011 +0000
binary protocol implementation from Mikko Tiihonen
Author: Dave Cramer davec@fastcrypt.com Date: Tue Sep 20 15:58:49 2011 +0000
forgot driver.java.in for cancel query implementation
Author: Dave Cramer davec@fastcrypt.com Date: Tue Sep 20 14:57:13 2011 +0000
implemented query timeout
Author: Dave Cramer davec@fastcrypt.com Date: Tue Sep 20 14:43:44 2011 +0000
changed name of table from testmetadata to metadatatest, test was failing due to confusion with test_statement tables
Author: Kris Jurka books@ejurka.com Date: Sun Sep 11 01:39:32 2011 +0000
Open HEAD for 9.2 development.
Author: Dave Cramer davec@postgresintl.com Date: Tue Oct 29 14:32:44 2013 +0000
move default port back to 5432
Author: Dave Cramer davec@postgresintl.com Date: Tue Oct 29 12:41:09 2013 +0000
resolved conflict
Author: Dave Cramer davec@postgresintl.com Date: Tue Oct 29 05:38:39 2013 -0700
Merge pull request #96 from lordnelson/maven-to-9.2-branch
Build script changes to allow packaging and deployment to Maven central ...
Author: Stephen Nelson stephen@eccostudio.com Date: Sat Apr 13 00:20:36 2013 +0100
Build script changes to allow packaging and deployment to Maven central using maven-ant-tasks.
Updated build.properties to contain the sonatype urls. Updated build.xml so that gpg signing works for each accompanying artifact type. Updated pom.xml to allow templated group and artifact ids.
Use 1.4 version of gpg plugin for signing Maven upload.
Author: Craig Ringer craig@2ndquadrant.com Date: Fri Oct 25 01:27:23 2013 -0700
Merge pull request #93 from ringerc/REL9_2_STABLE
Fix #92, missing NonValidatingFactory in JDBC3 driver
Author: Craig Ringer craig@2ndquadrant.com Date: Fri Oct 25 16:18:10 2013 +0800
Fix #92, missing NonValidatingFactory in JDBC3 driver
See https://github.com/pgjdbc/pgjdbc/issues/92
You need this patch if attempts to use a URL like
jdbc:postgresql://ipaddress:port/dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
fails with:
java.lang.ClassNotFoundException: org.postgresql.ssl.NonValidatingFactory
in the stack trace.
Author: Dave Cramer davecramer@gmail.com Date: Thu Oct 17 08:29:07 2013 -0400
reset interrupted bit and throw unchecked exception if we get interrupted while trying to connect
Author: Dave Cramer davecramer@gmail.com Date: Tue Oct 15 06:51:45 2013 -0400
add functions to allow LargeObjectMaager to commit on close from Marc Cousin
Author: Dave Cramer davec@postgresintl.com Date: Tue Sep 10 07:25:06 2013 -0700
Merge pull request #87 from davecramer/REL9_2_STABLE
Fixed setBlob with large blob from Tore Halset
Author: halset halset@ecc.no Date: Mon Sep 9 12:12:26 2013 +0200
fix for setBlob with large blob
Author: Dave Cramer davec@postgresintl.com Date: Tue Sep 10 06:20:52 2013 -0700
Merge pull request #84 from davecramer/REL9_2_STABLE
Fixed sort order for DatabaseMetaData from Sylvain Cuaz
Author: Dave Cramer davecramer@gmail.com Date: Tue Sep 10 09:00:37 2013 -0400
fixed DatabaseMetaDataTest as per Sylvain Cuaz
Author: Dave Cramer davecramer@gmail.com Date: Mon Jul 29 09:43:20 2013 -0400
fixed sort order for DatabaseMetaData
Author: Dave Cramer davec@postgresintl.com Date: Sun Jul 21 13:18:26 2013 +0000
backpatched canceltimer bug reported by Andri-Redko
Author: Dave Cramer davec@postgresintl.com Date: Sun Jun 23 06:22:09 2013 -0700
Merge pull request #66 from davecramer/REL9_2_STABLE
fixed compile mistake
Author: Dave Cramer davec@postgresintl.com Date: Sun Jun 23 09:17:27 2013 -0400
fixed compile mistake
Author: Dave Cramer davec@postgresintl.com Date: Mon May 27 15:23:14 2013 -0700
Merge pull request #62 from davecramer/REL9_2_STABLE
incremented version to fix pushing a 1.7 build for maven
Author: Dave Cramer Date: Mon Jul 8 03:23:25 2013 -0700
Merge pull request #68 from tomdcc/setobject-varchar-stringtype
Make PreparedStatement.setObject(pos, value, Types.VARCHAR) respect stringtype=unspecified
Author: Tom Dunstan Date: Sun Jul 7 16:20:41 2013 +0930
Make PreparedStatement.getObject() for an enum type return a string rather than a PGObject
Author: Tom Dunstan Date: Sun Jul 7 12:53:43 2013 +0930
Make PreparedStatement.setObject(pos, value, Types.VARCHAR) respect stringtype=unspecified
Author: Dave Cramer Date: Wed Jul 3 03:42:36 2013 -0700
Merge pull request #67 from njwhite/hstore
the driver will always return Maps for hstore columns
Author: Dave Cramer Date: Wed Jul 3 03:42:11 2013 -0700
Merge pull request #35 from fionatay/translations
Correct spelling in error messages and translations
Author: Nick White Date: Fri Jun 28 21:44:53 2013 -0400
the driver will always return Maps for hstore columns
Author: Dave Cramer Date: Tue Jun 25 08:31:34 2013 -0700
Merge pull request #64 from polarislabs/respect_ant_srcdir
Respect ant srcdir
Author: Bryan Varner Date: Fri Jun 21 11:39:35 2013 -0400
Respect the ${srcdir} property for all source file references in ant script.
This makes it possible to restructure the build (in the future?) so that source and artifact files (.java and .class) are not intermingled in the same directories on disk.
Author: Bryan Varner Date: Fri Jun 21 11:31:11 2013 -0400
Ignore netbeans and IDEA projects files.
Author: Dave Cramer Date: Mon Jun 10 09:19:51 2013 -0700
Merge pull request #52 from valgog/master
Consider search_path when looking up type OIDs in TypeInfoCache
Author: Dave Cramer Date: Wed May 22 08:05:11 2013 -0700
Merge pull request #61 from davecramer/master
expose URL in BaseDataSource
Author: Dave Cramer Date: Wed May 22 10:56:55 2013 -0400
expose URL property in BaseDataSource
make sure stringtype gets into url from properties
Author: Dave Cramer Date: Mon May 20 16:57:37 2013 -0700
Merge pull request #59 from davecramer/master
support for materialized views from Thomas Kellerer
Author: Dave Cramer Date: Mon May 20 19:56:30 2013 -0400
support for materialized views from Thomas Kelllerer
Author: Dave Cramer Date: Mon May 20 11:46:52 2013 -0700
Merge pull request #58 from davecramer/master
pgbouncer transaction patch
Author: Valentine Gogichashvili Date: Mon Apr 15 11:16:23 2013 +0200
Added another test case for searching objects using search_path
Author: Valentine Gogichashvili Date: Fri Apr 12 17:05:00 2013 +0200
search_path support should be working correctly even for complex cases
Author: Valentine Gogichashvili Date: Fri Apr 12 03:31:40 2013 +0200
Test is checking search_path usage dirctly on TypeInfo methods
Author: Valentine Gogichashvili Date: Fri Apr 12 02:35:27 2013 +0200
Consider search_path when resolving type names to OIDs
In case when types with the same name existed in several schemas,
TypeInfoCache did not consider the current search_path and was choosing
an OID of a type not deterministically. These change will make
the type from the current schema to be chosen. Also this change remains
backwards compatible with the previous implementation, still being anble
to find a type, that is not included into the current search_path.
Provided test fails now, as it does not TypeInfoCache
directly. So more work is to be done to make this test work.
Author: Kris Jurka Date: Tue Mar 26 05:33:45 2013 -0700
Lookup correct array delimiter in Connection.createArrayOf.
The old code had hardcoded a comma, but that's not true for all
datatypes.
Identification and fix by sumo in pull request #49, testcase by me.
Author: Kris Jurka Date: Tue Mar 26 05:27:06 2013 -0700
Remove plaintext README in favor of Markdown version.
Having two copies is just going to invite drift.
Author: Dave Cramer Date: Wed Mar 20 02:30:46 2013 -0700
Merge pull request #48 from ChenHuajun/master
Fix a simple mistake in Driver.getPropertyInfo()
Author: chj Date: Wed Mar 20 14:52:49 2013 +0800
fix a simple miss in getPropertyInfo()
Author: Dave Cramer Date: Wed Feb 27 04:27:55 2013 -0800
Merge pull request #45 from fathomdb/fix_default_password
Change default password to 'test'
Author: Dave Cramer Date: Wed Feb 27 04:27:26 2013 -0800
Merge pull request #44 from fathomdb/support_wrappers
Support for JDBC4 isWrapperFor & unwrap methods
Author: Justin Santa Barbara Date: Mon Feb 25 08:12:46 2013 -0800
Change default password to 'test'
./org/postgresql/test/README says the default password for unit tests is 'test',
but the default was actually 'password'
Author: Justin Santa Barbara Date: Mon Feb 25 07:57:24 2013 -0800
Added unit test for wrapper functions
Author: Justin Santa Barbara Date: Sat Feb 23 11:19:49 2013 -0800
Support for JDBC4 isWrapperFor & unwrap methods
Author: Dave Cramer Date: Wed Feb 20 09:32:12 2013 -0500
removed compile error with double ,
Author: Dave Cramer Date: Wed Feb 20 04:00:46 2013 -0800
Merge pull request #42 from davecramer/master
Avoid NPE on user defined types which have a value of null provided by Derrick Hudson
Author: Dave Cramer Date: Wed Feb 20 06:58:59 2013 -0500
avoid NullPointerException from Derrik Hudson on User Defined Types
Author: Dave Cramer Date: Wed Feb 20 03:42:10 2013 -0800
Merge pull request #41 from davecramer/master
Added constant for turning logging OFF
Author: Dave Cramer Date: Wed Feb 20 06:40:54 2013 -0500
added Loglevel.OFF to complete the settings
Author: lordnelson Date: Tue Feb 19 14:13:16 2013 +0000
Markdown version of the README
Author: Dave Cramer Date: Thu Feb 7 06:00:11 2013 -0800
Merge pull request #38 from davecramer/master
logging did not work properly when using a datasource, also many properties were not copied to the datasource
Author: Dave Cramer Date: Thu Feb 7 08:55:06 2013 -0500
log can not be output when using DataSource
property settings were not being copied to the datasource
these included logLevel, binaryTranfer, sslfactory, applicationName
patch provided by Chen Huajun
Author: Kris Jurka Date: Thu Jan 31 16:40:41 2013 -0800
Expose enhanced error message fields from constraint violations.
The server now provides the schema, table, column, datatype, and
constraint names for certain errors. So expose that to users so
they don't have to go rummaging through the error text trying
to find it.
The server doesn't always provide all the fields and doesn't cover
all the error messages, but it's a good start. In the future it
would be good to expose this information in a PGXXX class instead
of the supposedly private ServerErrorMessage.
Author: Dave Cramer Date: Tue Jan 29 02:36:13 2013 -0800
Merge pull request #37 from davecramer/master
fix loading of driver so that it checks for beginning of postgresql url before parsing anything
Author: Dave Cramer Date: Mon Jan 28 16:52:56 2013 -0500
make sure driver doesn't parse anything if the url isn't for us, also catch other possible errors, reported by Nathaniel Waisbrot
Author: Fiona Tay Date: Sun Jan 20 23:46:31 2013 -0800
Fix spelling of occured in error message
- An error occurred while setting up the SSL connection
Author: Fiona Tay Date: Sun Jan 20 23:45:26 2013 -0800
Fix spelling of occured in error message
- Something unusual has occurred to cause the driver to fail
Author: Fiona Tay Date: Sun Jan 20 23:44:02 2013 -0800
Fix spelling of occured in error message
- An I/O error occured while sending to the backend.
Author: Dave Cramer Date: Fri Jan 11 11:38:17 2013 -0800
Merge pull request #33 from davecramer/master
fix bug where update_count not updated correctly
Author: Dave Cramer Date: Fri Jan 11 14:36:48 2013 -0500
fixed mistake where update_count not updated properly
Author: Dave Cramer Date: Fri Jan 11 10:25:55 2013 -0800
Merge pull request #32 from davecramer/master
Allow ParseException to be thrown
Author: Dave Cramer Date: Fri Jan 11 13:21:56 2013 -0500
Fixed my patch to deal with update counts over 2^32
Check to see if the update count is greater than Integer.MAX_VALUE before
setting the update_count to Statement.SUCCESS_NO_INFO
NumberFormatException will still be thrown if there is a problem
parsing it.
Author: Dave Cramer Date: Fri Jan 11 08:57:05 2013 -0800
Merge pull request #31 from davecramer/master
Bug reference 7766 reported by Zelaine Fong
Author: Dave Cramer Date: Fri Jan 11 11:54:20 2013 -0500
Bug reference 7766 reported by Zelaine Fong
if an insert or update or delete statement affects more than 2^32 rows
we now return Statement.SUCCESS_NO_INFO
Author: Dave Cramer Date: Fri Jan 11 08:38:06 2013 -0800
Merge pull request #30 from davecramer/master
Fix cancel timer bug reported by Andriy Redko
Author: Dave Cramer Date: Fri Jan 11 11:34:44 2013 -0500
fix cancelTimer bug reported by Andri Redko.
now cancel timer when connection is closed
make sure timer is cancelled if there is an exception in execute
Author: Dave Cramer Date: Fri Jan 11 06:11:41 2013 -0800
Merge pull request #29 from davecramer/master
DbKeyStoreSocketFactory was in wrong package
Author: Dave Cramer Date: Fri Jan 11 09:09:59 2013 -0500
changed package to org.postgresql.ssl
Author: Dave Cramer Date: Fri Jan 11 05:57:43 2013 -0800
Merge pull request #28 from davecramer/master
Japanese Translation spelling fixed by Tomonari Katsumata
Author: Dave Cramer Date: Fri Jan 11 08:56:22 2013 -0500
Japanese translation spelling corrected provided by Tomonari Katsumata
Author: Dave Cramer Date: Fri Jan 11 05:43:41 2013 -0800
Merge pull request #26 from stevenschlansker/read-only
Allow driver to set read-only based on a connection parameter.
Author: Dave Cramer Date: Fri Jan 11 05:43:24 2013 -0800
Merge pull request #25 from rkrzewski/backend_pid
Expose PID of the backend process serving a paricular JDBC connection
Author: Dave Cramer Date: Fri Jan 11 05:41:51 2013 -0800
Merge pull request #27 from davecramer/master
DbKeyStoreFactory
Author: Dave Cramer Date: Fri Jan 11 08:37:06 2013 -0500
SSL client certificate via Keystore from a Resource file provided by Brendan Jurd
It seems that the most common way to deal with this situation is to
specify the keystore file and the password via system properties
(javax.net.ssl.keyStore et. al.), but that wasn't suitable in my case.
I needed to be able to load the keystore from a Resource file
embedded in the compiled JAR.
The class I came up with is attached. It builds on the WrappedFactory
provided in jdbc-postgres. All the implementer needs to do is
override the two abstract methods to provide an InputStream of the key
store, and the password to access it. The InputStream could be a
FileInputStream, or an InputStream returned by getResource(), or
whatever.
This class uses the same keystore for KeyManager (selecting the
key/cert to send as the client) and for TrustManager (verifying the
server's certificate against trusted CAs). It could easily be
extended to allow for two separate keystores by adding another couple
of methods.
Author: Steven Schlansker Date: Sun Dec 30 11:06:43 2012 -0800
Allow driver to set read-only based on a connection parameter.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Dave Cramer (davec), Kris Jurka.
- Fix Statement.toString to handle binary integer and Float types
Committed by davec.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Dave Cramer (davec).
- Fix performance regression introduced by using InetSocketAddress.getHostName
Committed by davec. Thanks to Scott Harrington, Kris Jurka.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Dave Cramer (davec).
This is a list of other contributors:
Scott Harrington, Kris Jurka.
- Implemented query timeout Committed by davec. Thanks to davec.
- First pass implementation of binary protocol Committed by davec.
Thanks to Mikko Tiihonen.
- SSPI authentication support Committed by davec. Thanks to
Christian Ullrich.
- isValid implementation Committed by davec. Thanks to Louis
Flores.
- Add support for hstore Committed by davec. Thanks to
Mikko Tiihonen.
- Implemented JDBC4 setBinaryStream Committed by davec. Thanks to Johann Oskarsson.
- Implementation of simple connection failover Committed by davec.
Thanks to Mikko Tiihonen.
- Allow changing of send recv buffer sizes Committed by davec.
Thanks to Bernd Helme.
- Fixed broken jdk 1.4 builds Committed by davec. Thanks to
Mike Fowler.
- Stack overflow fix Committed by davec. Thanks to Mike Fowler.
- A BitSet is a compact representation if we're only considering
builtin types that will have low oids, but if any user defined
types are enabled, all bets are off. Once the oid counter exceeds
INT_MAX, database connections were failing outright even if no
high oid types used binary transfer because we represent these
oids with negative values that a BitSet cannot handle.
Committed by jurka.
- Fix attacl for servers below 8.3 Committed by davec.
SSL implementation to mimic libpq more closely
Committed by davec. Thanks to Andras Bodor.- fix to build for java 1.8 Committed by davec.
Thanks to Mikko Tiihonen.
- Updated Brazilian Portuguese translation.
Committed by davec. Thanks to Euler Taveira de Oliveira.
- Documentation updates Committed by ringerc.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Dave Cramer (davec), Kris Jurka (jurka), Craig Ringer (ringerc).
This is a list of other contributors:
Andras Bodor, Bernd Helme, Christian Ullrich, davec, Euler Taveira de Oliveira, Johann Oskarsson, Louis Flores, Mike Fowler, Mikko Tiihonen.
- Fix ResultSetMetaData retrieval when the oid counter
exceeds INT_MAX. Since Java doesn't have unsigned ints we retrieve the values
as long and then truncate to int, so it may have a negative value. Committed by
jurka. Thanks to Owen Tran .
- Cache a copy of ResultSetMetaData in the ResultSet.
This solves a major performance problem for ResultSetMetaData users
which did not cache the ResultSetMetaData object. One of the users
is the driver's own implementation of updatable ResultSets, so this
can't be worked around solely in end user code.
In the 9.0 and earlier releases, the Field objects were used to hold
database lookup results and these were longer lived than the
ResultSetMetaData object. Now that ResultSetMetaData is holding
these database lookups we must hold onto the object to avoid
repeating the database queries.
Committed by jurka. Thanks to Steven Schlansker.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Kris Jurka (jurka).
This is a list of other contributors:
Owen Tran Steven Schlansker.
- Set version to 901 for release Committed by jurka.
Thanks to jurka.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Kris Jurka (jurka).
This is a list of other contributors:
jurka.
- Add support for setting application_name on both connection
startup and later through Connection.setClientInfo.
Committed by jurka.
- Fetch all metadata for the ResultSet in one query instead of
making a trip for each attribute of each column. Committed by jurka.
- Bring getSchemas up to JDBC 4 compliance. Return the additional
TABLE_CATALOG column that was added in JDBC 3. Additionally support the getSchemas
method added in JDBC 4 which filters the returned schemas. Committed by jurka.
- Bring getProcedures/getProcedureColumns up to JDBC 4 compliance.
Both methods have added a SPECIFIC_NAME column that can be used to differentiate
between overloaded functions. getProcedureColumns has added some other additional
columns to describe the datatype being returned. Committed by jurka. Thanks to Thor
Michael Store.
- Allow the driver to support setObject with Types.DISTINCT.
We report metadata indicating that values are of this type, so we'd better accept
it coming back in. Committed by jurka. Thanks to Vitalii Tymchyshyn.
- Support building with the 1.7 JDK. Committed by jurka.
- Support returning generated keys from batch statement
execution. Unfortunately we need to disable the actual batching that the driver
does behind the scenes because now that it is returning potentially large result
values we must avoid a deadlock. Committed by jurka.
- Report permission metadata for a table with no permissions
correctly. Committed by jurka. Thanks to danap.
- Ensure that an XAConnection throws SQLExceptions appropriately
even though it's a proxy class. Before this change it was throwing an
InvocationTargetException instead of the actual cause. Committed by jurka. Thanks
to Yaocl.
- Make updatable ResultSets work with SQLXML data. Committed by
jurka. Thanks to Michael Musset.
- If a domain has a not null constraint, report that
information in the metadata for both DatabaseMetaData.getColumns and
ResultSetMetaData.isNullable. Committed by jurka. Thanks to Thomas Kellerer.
- In DatabaseMetaData.getSchemas, return the user's own
temp schemas, but no others. Previously it wasn't returning the users own temp
schema, but was showing all toast temp schemas. Committed by jurka. Thanks to
Thomas Kellerer.
- Change ResultSetMetaData to return information on serial
datatypes in getColumnTypeName to match up with the behaviour of DatabaseMetaData.getColumns.
Committed by jurka.
- Fix literals that are injected into a SQL query to contain
the PG specific E'' marker if they are using the non-standard-conforming-strings
backslash escaping. This will get rid of the warnings from escape_string_warning.
Committed by jurka.
- Clear the generated keys associated with a Statement at
the next execution. If the next execution doesn't want generated keys, we don't
want to leave the old keys around. Committed by jurka.
- The 9.1 server canonicalizes the client_encoding setting,
so if we ask for unicode we get utf8. This confused the driver because previous
versions just echo back what we asked for. Ask for the canonical name now.
Committed by jurka. Thanks to Mike Fowler.
- When running tests, don't assume that we know the server's
default transaction isolation level. Committed by jurka. Thanks to Kevin Grittner.
- Update default permissions to account for changes in
different server versions. 8.2 removed the rule permission while 8.4 added a
trunctate permission. Committed by jurka.
- Newer server versions (9.0+) allow extra_float_digits
to be set to 3 instead of the old limit of 2 to get the maximum precision of
floating point values out of the server. Committed by jurka.
- Update the date tests for changes in the 1.6 JVM.
Older versions allowed five digit years and single digit days and months. The
latest code only allows a strict yyyy-mm-dd. This changed somewhere between
1.6.0_11 and 1.6.0_21. Committed by jurka. Thanks to Mike Fowler.
- Use slightly different SQL State error codes for
the different types of connection setup failures to indicate which can be
retried and which cannot. Committed by jurka. Thanks to Donald Fraser and
Kevin Grittner.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Kris Jurka (jurka).
This is a list of other contributors:
danap, Donald Fraser and Kevin Grittner, Kevin Grittner, Michael Musset, Mike Fowler, Thomas Kellerer, Thor Michael Store, Vitalii Tymchyshyn, Yaocl.
- Implement returning ASC/DESC order information in
getIndexInfo. Committed by jurka.
- Support PreparedStatement.setObject(int, Character).
Committed by jurka. Thanks to Vitalii Tymchyshyn.
- Work around a bug in the server's implementation of
the binary copy protocol. Committed by jurka. Thanks to Matthew Wakeling.
- Make ResultSetMetaData.getColumnType match the
results of DatabaseMetaData.getColumns.DATA_TYPE for domain and composite
types. Committed by jurka. Thanks to Thomas Kellerer.
- Fix DatabaseMetaData.getColumns for 7.2 servers.
This was accidentally broken in the previous release. Committed by jurka.
- Fix a minor concurrency issue during the setup for
processing escape functions. Committed by jurka. Thanks to Pierre Queinnec.
- Fix DatabaseMetaData routines that return index
information for a change in the 9.0 server that no longer renames the
pg_attribute entries for the index, but only adjust the table's attributes
on a column rename. Committed by jurka. Thanks to Adam Rauch.
- Track the tail of the SQLWarning chain so we can
quickly add a new element to it instead of having to walk the entire chain
from the head. This is important for the performance of handling plpgsql
functions which do a ton of RAISE NOTICES which get translated into warnings.
Committed by jurka. Thanks to Altaf Malik.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Kris Jurka (jurka).
This is a list of other contributors:
Adam Rauch, Altaf Malik, Matthew Wakeling, Pierre Queinnec, Thomas Kellerer, Vitalii Tymchyshyn.
- Support reading the new hex escaped bytea
format. Committed by jurka.
- Add support for returning the new TRUNCATE
privilege, that was added in 8.4, to the list of known table privileges.
Committed by jurka. Thanks to Thomas Kellerer.
- Add the partial index constraint to the FILTER_CONDITION
column returned by DatabaseMetaData.getIndexInfo. Committed by jurka.
Thanks to Mark Kirkwood.
- Japanese translation of error messages. Committed
by jurka. Thanks to Hiroshi Saito.
- Bulgarian translation of error messages. Committed
by jurka. Thanks to Viktor Usunov.
- Add some more specific types to the return value
for DatabaseMetaData.getTables. Return composite types, temporary views,
and temporary sequences with TABLE_TYPE values specifically for them.
Committed by jurka. Thanks to Thomas Kellerer.
- Add loglevel and protocolversion options to
DataSources. Committed by jurka.
- Remove an unused Sun specific import that prevented
compilation on non-Sun JDKs. Committed by jurka. Thanks to Tom Lane.
- Change the processing of Statement.executeUpdate
to complain if any of the results of a multi-statement query string return
a ResultSet. Previously we were only checking the first result which
resulted in silent partial execution of later SELECT statements. Committed
by jurka. Thanks to Joseph Shraibman.
- Check that a Connection hasn't been closed before
allowing any operations on it. Committed by jurka. Thanks to Kevin
Grittner.
- Don't allow rollback or commit when a Connection
is in autocommit mode. Committed by jurka. Thanks to Kevin Grittner.
- Change the SQLStates reported for using a closed
Connection and closed ResultSet to be more consistent. Report connection_does_not_exist
(08003) for a closed Connection and object_not_in_state (55000) for a
ResultSet. Committed by jurka.
- When a COPY operation is the first statement
issued in a transaction, it was not sending the BEGIN necessary to
start the transaction. Committed by jurka. Thanks to Maciek Sakrejda.
- The 8.4 release added some code to avoid re-describing
a statement if we already had the type information available by copying
the resolved type information from the query to the parameters. Its
goal was just to overwrite parameters without a type (unknown), but it
was actually overwriting all types which could change the query's desired
behaviour. Committed by jurka. Thanks to Hiroshi Saito.
- Fix the ORDINAL_POSITION in the DatabaseMetaData.getColumns.
Previously we were returning simply pg_attribute.attnum, but that doesn't
work in the presence of dropped columns because later columns don't get
their attnum decremented if a preceding column is dropped. Instead use
the row_number window function for 8.4 and later servers to figure out the
live column position. Committed by jurka.
- Always specify an XA error code when creating an
XAException. Otherwise a transaction manager won't know what to do with
the error and may have to assume the worst. Committed by jurka. Thanks to
Heikki Linnakangas, Justin Bertram.
- LOB truncation didn't allow truncating to zero
length because it was improperly using the positioning length checks
which don't allow a zero length. Committed by jurka. Thanks to Simon Kissane.
- Protocol sync was lost when a batch statement parameter
had an embedded null byte. Committed by jurka. Thanks to Pierre Queinnec.
- Fix a problem using the Copy API to copy data to the
server from a Reader. After reading data out of the Reader and into a buffer,
we were sending the entire buffer on to the server, not just the subset of
it that was filled by the read operation. Committed by jurka. Thanks to Leonardo F.
- A XA transaction should not change the autocommit
setting of a Connection. Ensure that we restore this property correctly
after the XA transaction completes. Committed by jurka. Thanks to Heikki
Linnakangas, Achilleas Mantzios.
- PoolingDataSources were not picking up all of the
properties that were set for them. Notably it would not give you a SSL
connection when asked. Committed by jurka. Thanks to Eric Jain.
- When setNull is called with a TIME or TIMESTAMP
type we cannot pass that type information on to the backend because we
really don't know whether it is with or without a time zone. For a NULL
value it doesn't matter, but we can't establish a type because a later
call with a non-null value using the same PreparedStatement can potentially
end up using a specific type that is incorrect. Committed by jurka. Thanks
to Martti Jeenicke.
We thank the following people for their contributions to this release.
This is a list of all people who participated as committers:
Kris Jurka (jurka).
This is a list of other contributors:
Eric Jain, Heikki Linnakangas, Achilleas Mantzios, Heikki Linnakangas, Justin Bertram, Hiroshi Saito, Joseph Shraibman, Kevin Grittner, Leonardo F, Maciek Sakrejda, Mark Kirkwood, Martti Jeenicke, Pierre Queinnec, Simon Kissane, Thomas Kellerer, Tom Lane, Viktor Usunov.
This is a list of all people who have ever participated as committers on this project.
- Kris Jurka (jurka)
- Oliver Jowett (oliver)
- Dave Cramer (davec)
- Barry Lind (blind)
- Craig Ringer (ringerc)