Re: [patch] add CLOB datatype

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

No good reason, just that it would be a little surprising performance 
wise - could trigger a very long fetch from the server that is likely to 
be uncached.

But I don't have a principled objection to it.

On 2012-04-24 09:12, Franck Routier wrote:
>
> 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
>

Disclaimer: http://www.peralex.com/disclaimer.html



--------------070103070404040504060201
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">





    No good reason, just that it would be a little surprising
    performance wise - could trigger a very long fetch from the server
    that is likely to be uncached.<br>
    <br>
    But I don't have a principled objection to it.<br>
    <br>
    On 2012-04-24 09:12, Franck Routier wrote:
    <blockquote cite="mid:[email protected]" type="cite">
      <span style="display:none"> </span>
      
          <div id="ygrp-text">
            <p> 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>
            </p>
          </div>
        </div>
      </div>
      
      
      <!-- end group email -->
    </blockquote>
  <br><br><br><hr><font size="-2" color=808080>Disclaimer: <a href="http://www.peralex.com/disclaimer.html">http://www.peralex.com/disclaimer.html</a><br><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=2053/stime=1335258805" 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=X3oDMTJmNnJmb2ZoBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzMzUyNTg4MDU-">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=X3oDMTJkOGxwY2ViBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzM1MjU4ODA1">
        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>

--------------070103070404040504060201--