× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Nevermind...  If you cast the clob field name to varchar or char with a
length, it works.

Chad Cornelius, IIS
(720) 921-7835


-----Original Message-----
From: Kristen Henry [mailto:klhnry@xxxxxxxxxxxx] 
Sent: Wednesday, August 31, 2005 2:29 PM
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: Working with CLOB's

Using SQL do a regular select.  Then I do something like this:

                            if (rs.getClob("additionalcomments") !=
null) {
                                
                                    Clob c =
rs.getClob("additionalcomments");
        
setAdditionalcomments(c.getSubString(1, (int) c.length()));
                                } else {
                                        
                                        setAdditionalcomments("");
                            }

I don't remember why I had to do the substring thing...

Kristen



> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of cornelius, chad
> Sent: Wednesday, August 31, 2005 2:12 PM
> To: 'java400-l@xxxxxxxxxxxx'
> Subject: Working with CLOB's
> 
> 
> This is the first time I have attempted or needed to work 
> with Clob's, and am wondering how you retrieve the data 
> defined as a CLOB using SQL.  Is this even possible?  Any 
> suggestions would be greatly appreciated.
> 
>  
> 
> Thanks,
> 
> Chad Cornelius, IIS
> 
> (720) 921-7835
> 
>  
> 
> -- 
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> 
> 
> 



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.