Issue Details (XML | Word | Printable)

Key: JDBC-421
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

Transaction mapping cannot be configured through JDBC URL

Created: 23/Jan/16 01:11 PM   Updated: 13/Mar/16 04:03 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2, Jaybird 2.2.1, Jaybird 2.2.2, Jaybird 2.2.3, Jaybird 2.2.4, Jaybird 2.2.5, Jaybird 2.2.6, Jaybird 2.2.7, Jaybird 2.2.8, Jaybird 2.2.9
Fix Version/s: Jaybird 2.2.10, Jaybird 3.0.0


 Description  « Hide
Illustration 6.5 on page 64 of the Jaybird manual (http://www.firebirdsql.org/file/documentation/drivers_documentation/Jaybird_2_1_JDBC_driver_manual.pdf) suggests it is possible to configure the transaction mapping through the JDBC URL, as it should be possible to translate that example to the connection URL:

DriverManager.getConnection("jdbc:firebirdsql://localhost/dbalias?TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,isc_no_rec_version,isc_tpb_write,isc_tpb_nowait",
username, password)

However the code in FBDriver and FBDriverPropertyManager shows it only works if the mapping is defined through a Properties object. Configuration through the JDBC url and Properties should be equivalent. It seems to have been broken back in 2004 with the introduction property info, specifically https://github.com/FirebirdSQL/jaybird/commit/d242527af47f2e2a0a97496a020dcc96fe8d7da2

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order