You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Guy Davis (JIRA)" <ji...@apache.org> on 2006/04/20 03:37:35 UTC

[jira] Created: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

WriteDataToFile command not handling BLOBs correctly
----------------------------------------------------

         Key: DDLUTILS-100
         URL: http://issues.apache.org/jira/browse/DDLUTILS-100
     Project: DdlUtils
        Type: Bug

  Components: Ant Tasks  
 Environment: Win XP SP2
Java 1.5.0_06
Oracle 10g EE
    Reporter: Guy Davis
 Assigned to: Thomas Dudziak 
    Priority: Minor
 Attachments: blob.patch

We recently added a table with a BLOB column to our application.  We use DDLUtils for dumping the schema and data to XML,  versioning the XML files, and also loading back into clean databases.  Unfortunately, the dump for the BLOB table just called toString() on the BLOB object itself which meant the BLOB data was lost.

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

[jira] Resolved: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.

     [ http://issues.apache.org/jira/browse/DDLUTILS-100?page=all ]

Thomas Dudziak resolved DDLUTILS-100.
-------------------------------------

    Resolution: Fixed

> WriteDataToFile command not handling BLOBs correctly
> ----------------------------------------------------
>
>                 Key: DDLUTILS-100
>                 URL: http://issues.apache.org/jira/browse/DDLUTILS-100
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Ant Tasks
>         Environment: Win XP SP2
> Java 1.5.0_06
> Oracle 10g EE
>            Reporter: Guy Davis
>         Assigned To: Thomas Dudziak
>            Priority: Minor
>             Fix For: 1.0
>
>         Attachments: blob.patch
>
>
> We recently added a table with a BLOB column to our application.  We use DDLUtils for dumping the schema and data to XML,  versioning the XML files, and also loading back into clean databases.  Unfortunately, the dump for the BLOB table just called toString() on the BLOB object itself which meant the BLOB data was lost.

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

[jira] Updated: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

Posted by "Guy Davis (JIRA)" <ji...@apache.org>.

     [ http://issues.apache.org/jira/browse/DDLUTILS-100?page=all ]

Guy Davis updated DDLUTILS-100:
-------------------------------

    Attachment: blob.patch

Completes initial BLOB support that was already present in DDLUtils.  Works great for us now.

> WriteDataToFile command not handling BLOBs correctly
> ----------------------------------------------------
>
>          Key: DDLUTILS-100
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-100
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>  Environment: Win XP SP2
> Java 1.5.0_06
> Oracle 10g EE
>     Reporter: Guy Davis
>     Assignee: Thomas Dudziak
>     Priority: Minor
>  Attachments: blob.patch
>
> We recently added a table with a BLOB column to our application.  We use DDLUtils for dumping the schema and data to XML,  versioning the XML files, and also loading back into clean databases.  Unfortunately, the dump for the BLOB table just called toString() on the BLOB object itself which meant the BLOB data was lost.

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

[jira] Commented: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

Posted by "Guy Davis (JIRA)" <ji...@apache.org>.

    [ http://issues.apache.org/jira/browse/DDLUTILS-100?page=comments#action_12416221 ] 

Guy Davis commented on DDLUTILS-100:
------------------------------------

I just did a full update of the latest DDLUtils source from SVN.  I had to resolve a conflict in org.apache.commons.codec.binary.Base64.ByteArrayBase64Converter with my patch as recent changes had been made here.  I resolved the conflict, but couldn't help but notice that you're encoding in the convertFromString() and decoding in convertToString().  

This seems backwards.  I have this corrected in my previous patch which works great for us with our BLOB columns in Oracle 10g databases.

> WriteDataToFile command not handling BLOBs correctly
> ----------------------------------------------------
>
>          Key: DDLUTILS-100
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-100
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>  Environment: Win XP SP2
> Java 1.5.0_06
> Oracle 10g EE
>     Reporter: Guy Davis
>     Assignee: Thomas Dudziak
>     Priority: Minor
>  Attachments: blob.patch
>
> We recently added a table with a BLOB column to our application.  We use DDLUtils for dumping the schema and data to XML,  versioning the XML files, and also loading back into clean databases.  Unfortunately, the dump for the BLOB table just called toString() on the BLOB object itself which meant the BLOB data was lost.

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

[jira] Updated: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.

     [ http://issues.apache.org/jira/browse/DDLUTILS-100?page=all ]

Thomas Dudziak updated DDLUTILS-100:
------------------------------------

    Fix Version: 1.0

> WriteDataToFile command not handling BLOBs correctly
> ----------------------------------------------------
>
>          Key: DDLUTILS-100
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-100
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>  Environment: Win XP SP2
> Java 1.5.0_06
> Oracle 10g EE
>     Reporter: Guy Davis
>     Assignee: Thomas Dudziak
>     Priority: Minor
>      Fix For: 1.0
>  Attachments: blob.patch
>
> We recently added a table with a BLOB column to our application.  We use DDLUtils for dumping the schema and data to XML,  versioning the XML files, and also loading back into clean databases.  Unfortunately, the dump for the BLOB table just called toString() on the BLOB object itself which meant the BLOB data was lost.

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