Problem to display clob data

[Farakh khan]

Hello,

Oracle version is: 11.2, jdk7 and tomcat apache-tomcat-6.0.18
I am facing problem to retriew record from database. my code is as follow:

		String query=   " select to_char(nDate,'dd-mm-yyyy'),heading,type,isDisplayLink, "+
				" desc1,desc2,status from newsArticles "+
				" where c_id=? and sysdate<=nDate + interval '12' day order by nDate desc";
		int count=0;

		PreparedStatement ps=cnn.prepareStatement(query);
		ps.setString(1, userId);

		rs=ps.executeQuery();
		while(rs.next()){

			String nDate		=rs.getString(1);			
			String heading		=rs.getString(2);	
			String category 	=rs.getString(3);	
			String recomendation	=rs.getString(4);	
			String desc1		=rs.getString(5);
			String desc2		=rs.getString(6);
			String status		=rs.getString(7);
			
			System.out.println("shortDesc="+desc1+"\nlongDesc="+desc2);			
		}
		ps.close();			

The record exists for desc2 but the above code output is "null" for desc2 whereas I checked on SQL prompt and its working fine.

SQL> select to_char(nDate,'dd-mm-yyyy'),heading,type,isDisplayLink,
  2   desc1,desc2,status from newsArticles
  3   where c_id=786169 and sysdate<=nDate + interval '12' day order by nDate de
sc;

TO_CHAR(ND HEADING
                                                TYPE ISDISPLAYLINK DESC1











        DESC2
             STATUS
---------- ---------------------------------------------------------------------
----------------------------------------- ---------- ------------- -------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------- ------------------------------------------------------------------------
-------- ----------
05-05-2011 Hello Testing
                                                   2             1 aa











        bb
                  2
05-05-2011 Hello Testing
                                                   2             1 aa











        bb
                  2
05-05-2011 Hello Testing
                                                   2             1 aa











        bb
                  2
05-05-2011 Hello Testing
                                                   2             2 Description-1











        Description-2
                  2

SQL>

I also called only desc2 column and its displaying ok.

SQL> select desc2 from newsArticles;

DESC2
--------------------------------------------------------------------------------

Description-2
bb
bb
bb

SQL>

My table structure is:

create table newsArticles(
news_id number(9) primary key,
admin_id number(14) constraint newsArticles_fk references admin(admin_id),
c_id number(14) constraint newsArticles_fk1 references centers(c_id),
nDate timestamp(0) default sysdate,
sourceLink varchar2(110),
isDisplayLink number(2),
keywords varchar2(1400),
heading varchar2(110),
image varchar2(50),
desc1 varchar2(900),
desc2 clob,
video varchar2(110),
status number(2),
type number(2)
);

I stuck here. Please help me

Best regards

[Avi Abrami]

Farakh,
You state that the data type for column DESC2 in table NEWSARTICLES is CLOB.
In that case I believe you must change the following line of your java code:

String desc2 = rs.getString(6);

to this:

java.sql.Clob desc2 = rs.getClob(6);

Good Luck,
Avi.

[Farakh khan]

Thanks Avi Abrami I tried and now it displaying:

oracle.sql.CLOB@2445B199

Best regards

[Rob Spoor]

If you'd check the methods in java.sql.Clob you'd see one that returns a String. It takes two parameters, the start and end of the substring. If you provide 0 and clob.length() that will get you the entire text.