#3 Converts LongBinary fields to strings

closed-fixed
None
5
2002-07-16
2002-05-29
Tim Thomas
No

One of the field types that we commonly use is coming
up as <Undefined>. We use it to store unique IDs so it's
fairly important that we be able to copy the values and
use them in other SQL statements. Basically this patch
simply adds this type into the type conversion switch
statement.

Discussion

  • Tim Thomas

    Tim Thomas - 2002-05-29

    The patch that adds the LONGBINARY type.

     
  • Tim Thomas

    Tim Thomas - 2002-05-29

    LONGVARBINARY patch to ResultSetDataSet.java

     
  • Tim Thomas

    Tim Thomas - 2002-05-29

    Logged In: YES
    user_id=236886

    Ok, the data type is actually LONGVARBINARY, I apologize.
    Corrected patch below.

     
  • Tim Thomas

    Tim Thomas - 2002-05-29

    Logged In: YES
    user_id=236886

    The more I think about this, the more it seems like it would
    be better to simply use the getString method on all of the
    unknown data types. Is there any reason we wouldn't want it
    to work this way?

     
  • Colin Bell

    Colin Bell - 2002-06-04
    • assigned_to: nobody --> colbell
     
  • Colin Bell

    Colin Bell - 2002-06-04

    Logged In: YES
    user_id=233132

    The problem with just using getString() (or getObject()) is
    performance. If there are large amounts of data stored in
    clob/blob type columns then the building of the output slows
    down dramatically.

    Longer term we need to put in handling for clob/blob type
    data. Shorter term (the next beta) what I can do is add
    support for LONGVARBINARY with an application setting
    specifying whether or not to use it.

     
  • Colin Bell

    Colin Bell - 2002-07-16

    Logged In: YES
    user_id=233132

    This is now in CVS and will be in 1.1beta5. You can specify
    in the session settings which data types you want displayed.

     
  • Colin Bell

    Colin Bell - 2002-07-16
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks