Issues with Teradata 14.10 jars

Teradata Applications

Issues with Teradata 14.10 jars

Hi all I am using Teradata 13.10 database and we are migrating to 14.10 and when I tried to test my application with latest jars I am getting follwing execptions

Here is the code and follwing query 

private Map getReclaimsBetweenIDIR(String applicationName) {

HashMap queryMap = new HashMap();

queryMap.put("applicationName", applicationName);

return getSqlMapClientTemplate().queryForMap(GET_RCLMS_BETWEEN_ID_IR,queryMap, "seqNbr");

This is executing the following select statement.  If we execute this statement outside of java as a stand alone SQL statement, then it is working fine.  It only gets the error below when executing from the java queryForMap method.

<select id="getReclaimsBetweenIDIR" resultMap="reclaimsIDIRMap" parameterClass="java.util.HashMap"><![CDATA[

  Select distinct wa.cycl_seq_nbr seqNbr,rclm.SEQ_NBR, rclm.CLNT_NBR, rclm.RPTG_ROAD, rclm.EQMT_OWN, rclm.ACCT_CODE, rclm.ACCT_DESC, rclm.TRAN_TYPE, rclm.EQMT_INIT,

rclm.EQMT_NBR, rclm.ACTL_YEAR_MO_EARN, rclm.YEAR_MO_ALLW, rclm.AAR_TYPE_CODE, rclm.PEN_CODE, rclm.PAY_CODE, rclm.RATE_SRC,

rclm.LE_CODE, rclm.TOTL_MILE, rclm.HRS_DAYS, rclm.TIME_TYPE, rclm.TIME_RATE, rclm.MILE_TYPE, rclm.MILE_RATE, rclm.APUR_TYPE,

rclm.APUR_RATE, rclm.COMB_TYPE, rclm.COMB_RATE, rclm.STRT_YEAR_MO, rclm.STRT_HRS, (rclm.STRT_SPLC_6 * 1000 + rclm.STRT_SPLC_3) STRT_SPLC, rclm.STRT_CARR,

rclm.STOP_YEAR_MO, rclm.STOP_HRS, (rclm.STOP_SPLC_6 * 1000 + rclm.STOP_SPLC_3) STOP_SPLC, rclm.STOP_CARR, rclm.POOL_CODE, rclm.APUR_AMT, rclm.TIME_AMT,

rclm.MILE_AMT, rclm.TIME_MILE_PEN_AMT, rclm.TOTL_AMT, rclm.APUR_PEN_AMT, rclm.PAID_CONT_AGCY, rclm.PAID_CONT_NBR_ITEM,

rclm.DAY_HOUR_CODE, rclm.EXCH_MNUL_IND, rclm.RCLM_REF_NBR

From CHPDVP30.CHPVW304 rclm Join wrkdvp01.wrkvw062 wa

On rclm.eqmt_init = wa.eqmt_init

And (cast( CAST(rclm.STRT_YEAR_MO AS numeric(7) format '9999-99') || '-01 00:00:00' AS TIMESTAMP)

   + CAST((rclm.strt_hrs + 1)   AS INTERVAL HOUR(3)) 

Between ( wa.strt_tmst -  CAST(4 as INTERVAL HOUR (4)) )

And ( wa.end_tmst + CAST(4 as INTERVAL HOUR (4)) )

And cast( CAST(rclm.STOP_YEAR_MO AS numeric(7) format '9999-99') || '-01 00:00:00' AS TIMESTAMP)

   + CAST((rclm.stop_hrs - 1)   AS INTERVAL HOUR(3))

Between ( wa.strt_tmst - CAST(4 as INTERVAL HOUR (4)) )

And ( wa.end_tmst + CAST(4 as INTERVAL HOUR (4)) ) )

And rclm.eqmt_nbr = wa.eqmt_nbr

And rclm.rptg_road = wa.eqmt_ownr

Where wa.appl_name = #applicationName#

And rclm.acct_code = 400

And rclm.acct_desc <> '09'

And (rclm.DTL_SMRY_CODE ='1'  OR rclm.DTL_SMRY_CODE ='A'  OR rclm.DTL_SMRY_CODE='M' OR  rclm.DTL_SMRY_CODE ='D')

  And rclm.strt_year_mo mod 100  Between 1 And 12 

  And rclm.stop_year_mo mod 100  Between 1 And 12 

order by rclm.eqmt_init, rclm.eqmt_nbr, rclm.year_mo_allw, rclm.strt_year_mo, rclm.strt_hrs, rclm.stop_year_mo, rclm.stop_hrs

  ]]></select>

I am getting the below exception .

- Cause: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.36] [Error 6760] [SQLState HY000] Invalid timestamp.

        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)

        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)

        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)

        at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithMapResult(SqlMapClientTemplate.java:260)

        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForMap(SqlMapClientTemplate.java:372)

        at com.uprr.app.irm.persistence.ibatis.SpecialsMasterDAOiBatis.getReclaimsBetweenIDIR(SpecialsMasterDAOiBatis.java:1298)

        at com.uprr.app.irm.persistence.ibatis.SpecialsMasterDAOiBatis.getAllReclaimsInCycle(SpecialsMasterDAOiBatis.java:1263)

        at com.uprr.app.irm.service.payables.strategies.SpecialsStrategy.getAllReclaimsInCycle(SpecialsStrategy.java:155)

        at com.uprr.app.irm.service.payables.strategies.SpecialsStrategy.getProcessingData(SpecialsStrategy.java:122)

        at com.uprr.app.irm.service.payables.strategies.IndividualStrategy.process(IndividualStrategy.java:162)

        at com.uprr.app.irm.helpers.StrategyProcessor.processIndividualStrategies(StrategyProcessor.java:220)

        at com.uprr.app.irm.helpers.StrategyProcessor.processStrategy(StrategyProcessor.java:100)

        at com.uprr.app.irm.service.payables.PayablesProcessor.process(PayablesProcessor.java:129)

        at com.uprr.app.irm.service.payables.PayablesProcessor.process(PayablesProcessor.java:222)

        at com.uprr.app.irm.webservice.service.IRMServiceImpl$9.run(IRMServiceImpl.java:655)

        at edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:431)

        at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:166)

        at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:643)

        at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:668)

        at java.lang.Thread.run(Thread.java:619)

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: