RE: [cinjug-users] inserting CLOB data in oracle 10g

["Akalamkam, Pardha" <Pardha.Akalamkam@xxxxxxxxxxxxxxxx>]

Hi

  I converted the string to CLOB before inserting it. it's working fine now.

  the code is below.

oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary(dbConnection, false, oracle.sql.CLOB.DURATION_CALL);

newClob.putString(1,clobData);

 

Pardha

---

From: Abdul Habra [mailto:ahabra@xxxxxxxxx]
Sent: Wednesday, May 30, 2007 10:50 AM
To: Akalamkam, Pardha; users@xxxxxxxxxx
Subject: Re: [cinjug-users] inserting CLOB data in oracle 10g

what does the error say?

"Akalamkam, Pardha" 
<Pardha.Akalamkam@xxxxxxxxxxxxxxxx> wrote:

Hi

  I am trying to insert CLOB data into oracle 10g. I am getting an error at insert statement. Can anybody suggest where I am going wrong in my coding.

 

here is my entire java code:

PreparedStatement pstmt = null;

ResultSet seqnum_rs = null;

int insert_clob_rs = 0;

try {

System.out.println("testing rtime db connection");

//getDBConnection("jdbc/isidb");

//getDBConnection("jdbc/rtimedb");

System.out.println("reading file input stream");

FileInputStream fis = new FileInputStream("C:/j2ee/response_203_test.txt" );

System.out.println("successfully read the file");

int x= fis.available();

byte b[]= new byte[x];

fis.read(b);

String content = new String(b);

System.out.println("the txlife response content value" +content);

String url = "">"url for data base";

String user = "rtimedev";

String password = "rtimedev";

//Create the properties object that holds all database details

Properties props = new Properties();

props.put("user", user );

props.put("password", password);

props.put("SetBigStringTryClob", "true");

// Load the Oracle JDBC driver class.

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());

// Get the database connection

Connection conn = DriverManager.getConnection(url, props );

System.out.println("the db connection value is" +conn);

System.out.println("tested successfully");

//test start

pstmt = conn.prepareStatement("INSERT INTO AFP_RTIME.PNDG_PLCY_HLDNG(MSG_XML_TXT) VALUES(?)");

pstmt.setString(1, content);

insert_clob_rs = pstmt.executeUpdate();

System.out.println("the insert value is" +insert_clob_rs);

if (insert_clob_rs == 1){

System.out.println("insert in pndg_plcy is successful");

}

else

System.out.println("insert in pndg_plcy is not successful");

//test end

} catch (SQLException se) {

System.out.println("error in insert message");

throw new UserDAOException("SQLException while retrieving sequence number: " + se.getMessage());

}

finally {

closeStatement( pstmt );

closeConnection();

}

Thank You,
Abdul Habra

---

Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search.