Timesten JDBC error or Cache agent error.
When I run a query in timesten with cache connect containing cast date, i came across with a problem
The query is :
SELECT ID, VALUE FROM Table WHERE (TRADE_DT BETWEEN cast ? as Date) - NUMTODSINTERVAL((90+1),'DAY') AND ?
Both parameters are set to Date.
When I use cache connect connecting
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
There is a problem, the problem is:
[TimesTen][TimesTen 7.0.3.0.0 ODBC Driver][TimesTen]TT5107: Oracle(OCI) error in OCIStmtExecute(): ORA-25137: Data value out of range rc = -1 -- file "bdbStmt.c", lineno 1535, procedure "getOraOutTypesNLengths()"
I excute this query using JDBC, and set the parameters at runtime. It seems when passing this query to Oracle(I use cache connect), this query cannont execute successfully.
But when I use cache connect connecting
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
These is no such problem.
When I fill the ? field in this query with to_date('2007-10-01','yyyy-mm-dd') and execute directly in Oracle and using timesten command line, and even JDBC, all executions are successful.
I don't know why this happen.
Is it because of the oracle client and server version? Or the JDBC cast support?
Can anyone tell me? thanks very much.