12:49 p.m.
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:43 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-836) MySQL JDBC import of Blob and Clob
[
https://issues.jboss.org/browse/TEIIDDES-836?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-836:
-----------------------------------------
What were the mysql datatypes (blob/text) and what is the reported JDBC type codes in the
DatabaseMetadata?
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:49 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-836) MySQL JDBC import of Blob and Clob
[
https://issues.jboss.org/browse/TEIIDDES-836?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-836:
-----------------------------------------
Nevermind I see that blob should come back as longvarbinary, which is being mapped to
object and text comes back as longvarchar, which is mapped to string. Both mapping will
need changed. I'll provide a patch.
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:15 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-836) MySQL JDBC import of Blob and Clob
[
https://issues.jboss.org/browse/TEIIDDES-836?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIIDDES-836:
------------------------------------
Attachment: TEIIDDES-836.patch.txt
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
Attachments: TEIIDDES-836.patch.txt
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:27 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-836) MySQL JDBC import of Blob and Clob
[
https://issues.jboss.org/browse/TEIIDDES-836?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIIDDES-836:
------------------------------------
Attachment: alt-TEIIDDES-836.patch.txt
Alternative patch relying on teiid's jdbc sql type mapping logic. Unfortunately teiid
7.3 still maps longvarchar to string, so part of the issue will still exist until teiid
7.4.
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
Attachments: alt-TEIIDDES-836.patch.txt, TEIIDDES-836.patch.txt
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:59 a.m.
New subject: [JBoss JIRA] Resolved: (TEIIDDES-836) MySQL JDBC import of Blob and Clob
[
https://issues.jboss.org/browse/TEIIDDES-836?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIIDDES-836.
-------------------------------------
Assignee: Steven Hawkins
Fix Version/s: 7.3
Resolution: Done
Leveraged the Teiid JDBCSQLTypeInfo class, which was overriden with the Teiid 7.4 version.
This class will be removed in the Teiid Designer 7.4 release.
Tested against mysql successfully.
MySQL JDBC import of Blob and Clob
----------------------------------
Key: TEIIDDES-836
URL: https://issues.jboss.org/browse/TEIIDDES-836
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS CR2
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.3
Attachments: alt-TEIIDDES-836.patch.txt, TEIIDDES-836.patch.txt
While importing from MySQL for the data types of Blob and Clob
Blob came about as "object"
Clob as Sting(65432)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5550
days inactive
5559
days old
teiid-designer-issues@lists.jboss.org
5 comments
2 participants
participants (2)
-
Ramesh Reddy (JIRA) -
Steven Hawkins (JIRA)