[teiid-issues] [JBoss JIRA] Resolved: (TEIID-753) MySQL translator issues

Thu Aug 6 12:41:29 EDT 2009

     [ https://jira.jboss.org/jira/browse/TEIID-753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-753.
----------------------------------

    Resolution: Done

Added a check for a gloabl transaction in the autocommit detection, also changed the timestamp literal to use JDBC escape syntax.  Also changed the timestamp nano precision to 0, since mysql does not store fractional seconds.

> MySQL translator issues
> -----------------------
>
>                 Key: TEIID-753
>                 URL: https://jira.jboss.org/jira/browse/TEIID-753
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 6.2.0
>
>
> MySQL does not change the autocommit flag to false when running in a global transaction, however the current autocommit detection logic does not take whether we're in an xa transaction into account.
> Also the timestamp literal format TIMESTAMP(...) actually produces a null value.  This should be changed to either the jdbc escape syntax or simply the string literal form.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira