solr导入Oracle日期时间数据的处理

最新推荐文章于 2021-04-03 18:03:29 发布

zjnbshifox

最新推荐文章于 2021-04-03 18:03:29 发布

阅读量345

点赞数

分类专栏： Java 文章标签： solr oracle

本文链接：https://blog.csdn.net/zjnbshifox/article/details/84390205

版权

Java 专栏收录该内容

40 篇文章 0 订阅

订阅专栏

参考文章：
http://stackoverflow.com/questions/10111517/getting-correct-time-from-oracle-date-in-solr-dataimporthandler

在导入Oracle数据的时候，总是只有日期，但是时间信息每个记录都是一样的，在网上查了很多资料，只有参考文章中的办法成功了

做法：在data-config.xml配置文件中加入自定义transformer处理：


<?xml version="1.0" encoding="UTF-8"?>
<dataConfig>
	<script><![CDATA[
    	function startDateTransform(row){
    	    // Get the timestamp and convert it to a date
    		var dateVal = row.get("ADD_ATT").dateValue();
    		// Put the correct date object into the original column
    		row.put("ADD_ATT", dateVal);
    		if(row.get("MODI_DD")!=null){
	    		dateVal = row.get("MODI_DD").dateValue();
	    		row.put("MODI_DD", dateVal);
    		}
    		return row;
		}
    ]]></script>
<dataSource type="JdbcDataSource" driver="oracle.jdbc.OracleDriver"
	url="jdbc:oracle:thin:@101.174.8.206:1521:orcl"
	user="usr"
	password="pwd"/>

<document name="gqh_position">         
 	<entity name="gqh_position" 
 			query="SELECT CP_ID,P_NAME,CATE_TITLE,COMPANY_NAME,DESCRIPTION,EDU_LEVEL,TITLE_LEVEL,DAN_WEI_JJ,CAST(ADD_AT AS TIMESTAMP) AS ADD_ATT,
 					CAST(MODI_AT AS TIMESTAMP) AS MODI_DD,SALARY FROM GQH_POSITION_FULL_VIEW" 
 			transformer="ClobTransformer,script:startDateTransform">
 			<!--  ROUND(TO_NUMBER(sysdate - modi_at) * 24 * 60) -->                  
				<field column="CP_ID"		name="CP_ID"		/>
				<field column="P_NAME"		name="P_NAME"		/>
				<field column="CATE_TITLE"		name="CATE_TITLE"		 clob="true"/>
				<field column="COMPANY_NAME"	name="COMPANY_NAME"	/>
				<field column="EDU_LEVEL"			name="EDU_LEVEL"			/>
				<field column="DAN_WEI_JJ"			name="DAN_WEI_JJ"	clob="true"	/>
				<field column="ADD_ATT"		name="ADD_AT"/>
				<field column="MODI_DD"		name="MODI_AT"	/>
				<field column="SALARY"			name="SALARY"/>				
    </entity>    
</document>
</dataConfig>

这样在客户端取得数据显示的时候


    p.setStamp((Date)doc.getFieldValue("ADD_AT")); //p是vo对象
    //在jsp页面中显示
    <fmt:formatDate value="${p.stamp}" pattern="yyyy-MM-dd HH:mm:ss" />

关于deltaimport的配置：


deltaImportQuery="SELECT CP_ID,P_NAME,CATE_TITLE,COMPANY_NAME,DESCRIPTION,EDU_LEVEL,TITLE_LEVEL,DAN_WEI_JJ,CAST(ADD_AT AS TIMESTAMP) AS ADD_ATT,
 					CAST(MODI_AT AS TIMESTAMP) AS MODI_DD,SALARY FROM GQH_POSITION_FULL_VIEW WHERE to_char(ADD_AT,'YYYY-MM-DD HH24:MI:SS') > '${dataimporter.last_index_time}' 
 					 OR to_char(MODI_AT,'YYYY-MM-DD HH24:MI:SS') > '${dataimporter.last_index_time}'"
            deltaQuery="SELECT CP_ID,P_NAME,CATE_TITLE,COMPANY_NAME,DESCRIPTION,EDU_LEVEL,TITLE_LEVEL,DAN_WEI_JJ,CAST(ADD_AT AS TIMESTAMP) AS ADD_ATT,
 					CAST(MODI_AT AS TIMESTAMP) AS MODI_DD,SALARY FROM GQH_POSITION_FULL_VIEW WHERE to_char(ADD_AT,'YYYY-MM-DD HH24:MI:SS') > '${dataimporter.last_index_time}' 
 					 OR to_char(MODI_AT,'YYYY-MM-DD HH24:MI:SS') > '${dataimporter.last_index_time}'"