Re: [patch] add CLOB datatype

Franck Routier <[email protected]> Tue, 24 Apr 2012 09:12:11 +0200
Newsgroups gmane.comp.java.orm.simpleorm
Message-ID <[email protected]>
--------------080303030208020600060302
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Hi Noël and Anthony,

I've been looking at your code, and I was wondering why Clobs wouldn't 
be comparable... What is the reason behind that ?
Typically, Postgresql type for Clobs (TEXT) would just compare fine, as 
well as java representation of a Clob (a String).
Is there any Oracle specificity around that, or simply a size problem ??

Thanks,
Franck


Le 23/04/2012 07:58, anthony berglas a écrit :
> Hello Noel,
>
> Thanks for the submission and sorry about the tardy response, have 
> been busy.  Will try to review and add this sooner than later.
>
> *Franck*, do you have time to do this?
>
> Anthony
>
> On Mon, Apr 16, 2012 at 10:46 PM, Noel Grandin <[email protected] 
> <mailto:[email protected]>> wrote:
>
>     Ping?
>     Anybody here?
>
>     On 2012-02-03 08:59, Noel Grandin wrote:
>
>>     Hi
>>
>>     The attached file adds the CLOB datatype.
>>
>>     Regards, Noel Grandin
>>
>>     Disclaimer: http://www.peralex.com/disclaimer.html
>>
>
>
>
>     ------------------------------------------------------------------------
>     Disclaimer: http://www.peralex.com/disclaimer.html
>
>
>
>
> -- 
>
> Dr Anthony Berglas, [email protected] 
> <mailto:[email protected]>       Mobile: +61 4 4838 8874
> Just because it is possible to push twigs along the ground with ones nose
> does not necessarily mean that that is the best way to collect firewood.
>
>
> 


--------------080303030208020600060302
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit





<head>

<style type="text/css">
<!--

/* start of attachment style */
       .ygrp-photo-title{
         clear: both;
         font-size: smaller;
         height: 15px;
         overflow: hidden;
         text-align: center;
         width: 75px;
       }
       div.ygrp-photo{
         background-position: center;
         background-repeat: no-repeat;
         background-color: white;
         border: 1px solid black;
         height: 62px;
         width: 62px;
       }

       div.photo-title 
         a,
         div.photo-title a:active,
         div.photo-title a:hover,
         div.photo-title a:visited {
           text-decoration: none; 
       }

       div.attach-table div.attach-row {
         clear: both;
       }

       div.attach-table div.attach-row div {
         float: left;
         /* margin: 2px;*/
       }

       p {
         clear: both;
         padding: 15px 0 3px 0;
	 overflow: hidden;
       }

       div.ygrp-file {
         width: 30px;
         valign: middle;
       }
       div.attach-table div.attach-row div div a {
         text-decoration: none;
       }

       div.attach-table div.attach-row div div span {
         font-weight: normal;
       }

       div.ygrp-file-title {
         font-weight: bold;
       }
 /* end of attachment style */
        -->
        </style>
        </head>
<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">





    Hi Noël and Anthony,<br>
    <br>
    I've been looking at your code, and I was wondering why Clobs
    wouldn't be comparable... What is the reason behind that ?<br>
    Typically, Postgresql type for Clobs (TEXT) would just compare fine,
    as well as java representation of a Clob (a String).<br>
    Is there any Oracle specificity around that, or simply a size
    problem ??<br>
    <br>
    Thanks,<br>
    Franck<br>
    <br>
    <br>
    Le 23/04/2012 07:58, anthony berglas a écrit :
    <blockquote
cite="mid:CA+_PZMfp9zBBy7ppLfhyjUMD9n30Krr+hgj4c+G5RJrKip2naQ@mail.gmail.com"
      type="cite">
      <span style="display:none"> </span>
      
          <div id="ygrp-text">
            <div class="gmail_extra">Hello Noel,</div>
            <div class="gmail_extra"><br>
            </div>
            <div class="gmail_extra">Thanks for the submission and sorry
              about the tardy response, have been busy.  Will try to
              review and add this sooner than later.  </div>
            <div class="gmail_extra"><br>
            </div>
            <div class="gmail_extra"><b>Franck</b>, do you have time to
              do this?</div>
            <div class="gmail_extra"><br>
            </div>
            <div class="gmail_extra">Anthony<br>
              <br>
              <div class="gmail_quote">On Mon, Apr 16, 2012 at 10:46 PM,
                Noel Grandin <span dir="ltr">&lt;<a
                    moz-do-not-send="true"
                    href="mailto:[email protected]" target="_blank">[email protected]</a>&gt;</span>
                wrote:<br>
                <blockquote class="gmail_quote" style="border-left:1px
                  #ccc solid;">
                  <div>
                    <span> </span>
                    <div>
                      <div>
                        <div>
                          <p> Ping? <br>
                            Anybody here?<br>
                            <br>
                            On 2012-02-03 08:59, Noel Grandin wrote: </p>
                          <blockquote type="cite"> <span> </span>
                            <div>
                              <p>Hi<br>
                                <br>
                                The attached file adds the CLOB
                                datatype.<br>
                                <br>
                                Regards, Noel Grandin<br>
                                <br>
                                Disclaimer: <a moz-do-not-send="true"
                                  href="http://www.peralex.com/disclaimer.html"
                                  target="_blank">http://www.peralex.com/disclaimer.html</a><br>
                                <br>
                              </p>
                            </div>
                          </blockquote>
                          <br>
                          <br>
                          <br>
                          <hr><font color="808080" size="-2">Disclaimer:
                            <a moz-do-not-send="true"
                              href="http://www.peralex.com/disclaimer.html"
                              target="_blank">http://www.peralex.com/disclaimer.html</a><br>
                            <br>
                          </font> </div>
                      </div>
                    </div>
                  </div>
                </blockquote>
              </div>
              <br>
              <br clear="all">
              <div><br>
              </div>
              -- <br>
              <p>
              </p>
              <p>Dr Anthony Berglas, <a moz-do-not-send="true"
                  href="mailto:[email protected]" target="_blank">[email protected]</a>      
                Mobile: +61 4 4838 8874<br>
                Just because it is possible to push twigs along the
                ground with ones nose<br>
                does not necessarily mean that that is the best way to
                collect firewood.</p>
              <br>
            </div>
          </div>
          
      
      <!-- end group email -->
    </blockquote>
    <br>
  



<!-- |**|begin egp html banner|**| -->

<br>

    
    
<br>

<!-- |**|end egp html banner|**| -->


<div width="1" style="color: white; clear: both;"/>__._,_.___</div>

<!-- Start Recommendations -->
<!-- End Recommendations -->



<!-- |**|begin egp html banner|**| -->

  <img src="http://geo.yahoo.com/serv?s=97476590/grpId=7360226/grpspId=1705006905/msgId=2052/stime=1335251560" width="1" height="1"> <br>

<!-- |**|end egp html banner|**| -->

    
<!-- |**|begin egp html banner|**| -->

<br>
      <div style="font-family: verdana; font-size: 77%; border-top: 1px solid #666; padding: 5px 0;" >
      Your email settings: Individual Email|Traditional <br>
      <a href="http://groups.yahoo.com/group/SimpleORM/join;_ylc=X3oDMTJmdjliZDFoBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzMzUyNTE1NjA-">Change settings via the Web</a> (Yahoo! ID required) <br>
      Change settings via email: <a href="mailto:[email protected]?subject=Email Delivery: Digest">Switch delivery to Daily Digest</a> | <a href = "mailto:[email protected]?subject=Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br>
           <a href="http://groups.yahoo.com/group/SimpleORM;_ylc=X3oDMTJkMTRkYjE1BF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzM1MjUxNTYw">
        Visit Your Group 
      </a> |
      <a href="http://docs.yahoo.com/info/terms/">
        Yahoo! Groups Terms of Use
      </a> |
      <a href="mailto:[email protected]?subject=Unsubscribe">
       Unsubscribe 
      </a> 
 <br>
    </div>
  <br>

<!-- |**|end egp html banner|**| -->


<div style="color: white; clear: both;"/>__,_._,___</div>
</body>
</html>

--------------080303030208020600060302--