You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Michael Dick (JIRA)" <ji...@apache.org> on 2010/11/03 17:03:25 UTC

[jira] Created: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Blob types override column definition from @Column annotation with MySQL
------------------------------------------------------------------------

                 Key: OPENJPA-1870
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.0.2
            Reporter: Michael Dick
            Assignee: Michael Dick
             Fix For: 2.1.0


Per email to users@openjpa, an entity with this annotation :

@Column(columnDefinition=BINARY(250)) 
private byte[] blobs; 

creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-1870:
----------------------------------

    Reporter: Joel Halbert  (was: Michael Dick)

> Blob types override column definition from @Column annotation with MySQL
> ------------------------------------------------------------------------
>
>                 Key: OPENJPA-1870
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.2
>            Reporter: Joel Halbert
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>
> Per email to users@openjpa, an entity with this annotation :
> @Column(columnDefinition=BINARY(250)) 
> private byte[] blobs; 
> creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OPENJPA-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12928031#action_12928031 ] 

Michael Dick commented on OPENJPA-1870:
---------------------------------------

Attaching a patch. It's a bit kludgy, will commit tomorrow if no one objects. 

> Blob types override column definition from @Column annotation with MySQL
> ------------------------------------------------------------------------
>
>                 Key: OPENJPA-1870
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.2
>            Reporter: Joel Halbert
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>         Attachments: OPENJPA-1870.diff.txt
>
>
> Per email to users@openjpa, an entity with this annotation :
> @Column(columnDefinition=BINARY(250)) 
> private byte[] blobs; 
> creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Posted by "Joel Halbert (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joel Halbert closed OPENJPA-1870.
---------------------------------


Thanks Mike.

> Blob types override column definition from @Column annotation with MySQL
> ------------------------------------------------------------------------
>
>                 Key: OPENJPA-1870
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.2
>            Reporter: Joel Halbert
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>         Attachments: OPENJPA-1870.diff.txt
>
>
> Per email to users@openjpa, an entity with this annotation :
> @Column(columnDefinition=BINARY(250)) 
> private byte[] blobs; 
> creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-1870:
----------------------------------

    Attachment: OPENJPA-1870.diff.txt

> Blob types override column definition from @Column annotation with MySQL
> ------------------------------------------------------------------------
>
>                 Key: OPENJPA-1870
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.2
>            Reporter: Joel Halbert
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>         Attachments: OPENJPA-1870.diff.txt
>
>
> Per email to users@openjpa, an entity with this annotation :
> @Column(columnDefinition=BINARY(250)) 
> private byte[] blobs; 
> creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (OPENJPA-1870) Blob types override column definition from @Column annotation with MySQL

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-1870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick resolved OPENJPA-1870.
-----------------------------------

    Resolution: Fixed

> Blob types override column definition from @Column annotation with MySQL
> ------------------------------------------------------------------------
>
>                 Key: OPENJPA-1870
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1870
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.0.2
>            Reporter: Joel Halbert
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>         Attachments: OPENJPA-1870.diff.txt
>
>
> Per email to users@openjpa, an entity with this annotation :
> @Column(columnDefinition=BINARY(250)) 
> private byte[] blobs; 
> creates a column of type BLOB when using MySQL.. This behavior was introduced in OPENJPA-740, which optimizes the blob storage based on the size of the column, but does not take into account any existing annotations. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.