Kbase 18560: Timestamp in Filter String causes Exception with Oracle-ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/02/1999 |
|
Timestamp in Filter String causes Exception with Oracle-ODBC
Using a java.sql.Timestamp.toString() as part of an
argument to setFilter(), with Oracle-ODBC-driver version
7.3 causes a SQL Exception java.sql.SQLException:
"[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01830:
date format picture ends before converting entire input string."
if a statement like that :
setFilter ("Ordered_on >= {ts '1999-01-01 13:34:21.661'}");
is executed. The problem appeared also with a common
java class independent of Apptivity.
Using the same statement without the milli seconds works
fine. The problem is solved with the Oracle JDBC-OCI8 driver.