convert string to oracle.sql.clob in java?

Question

I'm coding a Java function inside Oracle Database which produce allot of text! how to convert a string to CLOB (oracle.sql.CLOB) in java? what is the straight-forward way to do?

I'm trying to build a function which has String as an input with oracle.sql.CLOB as an output, but it's not working! I'm not doing any jdbc related work!

here is what I have (which is not working!)

  public static CLOB str2clob(String s)
  {
         oracle.sql.CLOB clob = null;

         try
         {
               clob.setString(0,s);

         } catch (Exception e)
         {
         }
         return clob;
  }

Check here please: stackoverflow.com/questions/4687696/string-to-clob-in-java — Mechkov
– Mechkov, Commented Nov 9, 2011 at 13:57
Those two links don't directly provide what the poster is asking for... — Barett
– Barett, Commented Dec 10, 2012 at 3:57

Stan Sokolov · Accepted Answer · 2012-12-10 03:37:26Z

2

/*********************************************************************************************
 * From String to CLOB
 *  @return CLOB representation of string
 *********************************************************************************************/
private java.sql.Clob stringToClob(String source)
{
    try
    {
        return new javax.sql.rowset.serial.SerialClob(source.toCharArray());
    }
    catch (Exception e)
    {
        log.error("Could not convert string to a CLOB",e);
        return null;
    }
}

edited Dec 10, 2012 at 3:37

answered Dec 10, 2012 at 3:31

Stan Sokolov

2,3101 gold badge25 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lu_ko Over a year ago

This is possible but created Clob does not work properly! For example, invoking yourClob.getAsciiStream() throws SerialException:

Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object.

For more details please see SerialClob implementation.

Sergey Gazaryan · Accepted Answer · 2011-11-09 14:04:34Z

0

Something like this:

oracle.sql.CLOB **clob** = ((OracleResultSet)rset).getCLOB(index);

StreamReader sr = new StreamReader(**yourString**);
char[] bufr = new char[clob.getChunkSize()];


OutputStream os = new OutputStream(clob.getOutputStream());

int charsRead = 0;
for(charsRead = sr.read(bufr); charsRead>-1; charsRead = sr.read(bufr)){
   os.write(bufr, 0, charsRead);
}


os.flush();
os.close()
sr.close();

answered Nov 9, 2011 at 14:04

Sergey Gazaryan

1,0431 gold badge9 silver badges25 bronze badges

4 Comments

Data-Base Over a year ago

so my results are save as CLOB in clob ?

Data-Base Over a year ago

what about index in 'oracle.sql.CLOB clob = ((OracleResultSet)rset).getCLOB(index);'?

Sergey Gazaryan Over a year ago

you write "yourString" (by using StreamReader sr) in outputStream of clob (clob.getOutputStream())

Data-Base Over a year ago

not working for me! I tried to build a function which has String as an input with oracle.sql.CLOB as an output, but it's not working! I'm not doing any jdbc related work!

Community · Accepted Answer · 2017-05-23 12:30:33Z

0

You can use NonContextualLobCreator from Hibernate. Please see answers in What is the alternate for deprecated Hibernate.createClob(Reader reader, int length)

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Feb 9, 2015 at 11:33

lu_ko

4,3132 gold badges29 silver badges32 bronze badges

Collectives™ on Stack Overflow

convert string to oracle.sql.clob in java?

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related