Issue Details (XML | Word | Printable)

Key: JDBC-556
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Attila Molnár
Votes: 0
Watchers: 0

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

setSavepoint() fails on dialect 1

Created: 04/Oct/18 09:43 AM   Updated: 25/May/19 10:03 AM
Component/s: None
Affects Version/s: Jaybird 3.0.5
Fix Version/s: Jaybird 3.0.6, Jaybird 4

 Description  « Hide
JayBird 3.0.5 send SQL SAVEPOINT "ITER" with V10Database.executeImmediate(). Here getConnectionDialect() returns 1 (this is fine, and intentional) BUT the statementText already costructed by JayBird with fix dialect 3 format (quoted name)
FBSavepoint class should be dialect aware and create quoted name only in dialect 3.

This is OK with JayBird 2.9.9 : send SQL SAVEPOINT "ITER" with gds.iscDsqlExecImmed2(getIscDBHandle(), currentTr, statement, 3, null, null);

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 04/Oct/18 08:36 PM
Thanks for reporting; I will fix it in the next release.

Mark Rotteveel added a comment - 07/Oct/18 10:04 AM - edited
Fix committed.

Workaround: use connection dialect 2 or 3 when connecting to a dialect 1 database (but that also influences other behavior, so use that carefully).