Convert String to Clob in Java

Question

I have a situation where I need to make Clob object from String. The problem is I can't have ConnectionManager in that method.

I need to some utility like

 public Clob getClob(String data){

 }

Can any one tell me how can I make this.

I have oralce.sql.CLOB also. however it requires Connection to create object.

Why "can't [you] have ConnectionManager"? Could you use [`LobCreator`](http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/engine/jdbc/LobCreator.html)? — radimpe, Jul 11 '12 at 06:56

score 25 · Answer 1 · answered Feb 27 '18 at 08:54

25

Those who are still looking for an alternate answer, a Clob object could be created without the need for a connection object as shown below.

Clob myClob = new javax.sql.rowset.serial.SerialClob(stringData.toCharArray());

answered Feb 27 '18 at 08:54

Nibin Jacob Panicker

291
3
8

Exactly what i am looking for ;-) – jumping_monkey Oct 21 '19 at 10:00
In my case I've returned `clob` from a *java stored function* but got this error - *ORA-00932: inconsistent datatypes: expected a return value that is an instance of a user defined Java class convertible to an Oracle type got an object that could not be converted* – Erfan Ahmed Jan 06 '20 at 04:16
1

Hibernate has a utlity too in case you want to use for CLOB and BLOB. **Hibernate.createClob(yourJavaString)** For BLOB **Hibernate.createBlob(yourJavaString.getBytes())** – Reddymails Mar 01 '22 at 12:40

score 10 · Answer 2 · edited Aug 22 '17 at 19:07

Throws warning: Clob not initialized.

You need an OracleConnection to create a Clob, using the Oracle Database.

OracleConnection conn;  // initialize this first

Clob myClob = conn.createClob();



private OracleConnection conn = null;
public void setConnection( OracleConnection conn )
{
    this.conn = conn;
}

void setClob( String cookie ) throws SQLException
{
    Clob myClob = conn.createClob();
    myClob.setString( 1, cookie);
}

score 8 · Accepted Answer · edited Mar 21 '18 at 14:35

8

Try this :

OracleConnection conn;  // initialize this first

CLOB clob = conn.createClob();

public Clob getClob(String data){

    return clob.setString(position, data);
}

edited Mar 21 '18 at 14:35

António Ribeiro

4,129
5
32
49

answered Jul 11 '12 at 07:13

vikiiii

9,246
9
49
68

score 2 · Answer 4 · answered Jul 25 '18 at 10:07

In order to initialize the OracleConnection mentioned in the other answers here and if you're doing this for a java stored procedure and the connection is to the database where the procedure is stored, then the Connection can be initialized like this:

Connection conn = DriverManager.getConnection("jdbc:default:connection:");

and this import is needed:

import oracle.jdbc.driver.OracleConnection;

score 1 · Answer 5 · answered Jan 29 '20 at 22:04

1

On my side, I use

Clob generateProxy(String string)

From

import org.hibernate.engine.jdbc.ClobProxy;

answered Jan 29 '20 at 22:04

Greg7000

297
3
15

score 1 · Answer 6 · answered Feb 10 '20 at 11:58

If you're using spring boot and you only have a JdbcTemplate obj you can get an Oracle connection using:

private JdbcTemplate  jdbcTemplate;   // or NamedParameterJdbcTemplate 
Clob myClob = this.jdbcTemplate.getJdbcTemplate().getDataSource().getConnection().createClob();

score 0 · Answer 7 · answered Nov 24 '19 at 16:20

If you are looking for an opportunity to create a [N]Clob without a Connection you can use NonContextualLobCreator from the Hibernate project. Following example shows the create of an NCLob using a string

String xml = "my blob content";
NClob clob = NonContextualLobCreator.INSTANCE.createNClob(xml);
entity.setXmlclob);

Available from at least Hibernate 4.2 (maybe earlier).

Convert String to Clob in Java

7 Answers7