db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From china_wang <2596121...@qq.com>
Subject You cannot invoke other java.sql.Clob/java.sql.Blob methods
Date Thu, 26 Jun 2014 06:08:08 GMT
Dear All,

      I have a problem that i can't get Clob  when i use
spring3.0.5+ibatis2.3.0+derby10.10.0.1 ,
my code snippets :


<select id="PUB-DATASETS" resultClass="java.util.HashMap"
parameterClass="map" remapResults="true">
		
        select $columns$ from pub_datasets where 1=1
        <dynamic prepend="and">
				<isNotEmpty property="dataSoursIds">     				  
     				 DATASOURCE_ID in ($dataSoursIds$) 
				</isNotEmpty>				
		</dynamic>             
        <dynamic prepend="and">
				<isNotEmpty property="dataSetIds">     				  
     				 DATASET_ID in ($dataSetIds$)
				</isNotEmpty>				
		</dynamic>
</select>



ArrayList<Map&lt;String, Object>> list =new
ArrayList<Map&lt;String,Object>>();	
list =(ArrayList)
datasetDAO.findAll("MS-PUB-DATASETS-SELECT-ALL-BY-ADMIN",params);

for(Map<String, Object> map:list)
{
	if(map.get("TEMPLATE")!=null)
	{
	  System.out.println(((Clob)map.get("TEMPLATE")).length());
	}
}

"((Clob)map.get("TEMPLATE")).length() " will throw exception.....


 sorry my english level is poor...

Thanks for every help. 

wang





--
View this message in context: http://apache-database.10148.n7.nabble.com/You-cannot-invoke-other-java-sql-Clob-java-sql-Blob-methods-tp140391.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message