[
https://issues.apache.org/jira/browse/CALCITE-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961003#comment-16961003
]
Stamatis Zampetakis commented on CALCITE-3453:
----------------------------------------------
Normally the commit (or no commit) behavior of a statement is controlled by
{{Connection#setAutoCommit}}/{{Connection#getAutoCommit}}. Are we using this
information?
> insert into postgresql doesn't commit the transaction
> -----------------------------------------------------
>
> Key: CALCITE-3453
> URL: https://issues.apache.org/jira/browse/CALCITE-3453
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Reporter: Zhuang
> Priority: Major
>
> When insert into postgresql, no row inserted.
> After inspect using wireshark, seems postgresql server rollback the insert
> when the connection is closing.
> The problem code is in +org.apache.calcite.runtime.ResultSetEnumerable.java+.
> In *+enumeratorBasedOnPreparedStatement+* the connection doesn't commit the
> transation. And in *+closeIfPossible+* the connection is also close without
> commit transation, so postgresql server rollback the insert.
> Is this a bug, or a mis-config ??
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
