[
https://issues.apache.org/jira/browse/EMPIREDB-176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rainer Döbele closed EMPIREDB-176.
----------------------------------
Resolution: Cannot Reproduce
> Value for a column of type DataType.DATETIME not properly inserted
> ------------------------------------------------------------------
>
> Key: EMPIREDB-176
> URL: https://issues.apache.org/jira/browse/EMPIREDB-176
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.2.0-incubating, empire-db-2.4.1
> Environment: CentOS 6.2, java 1.6.0_30
> Reporter: Alain Becam
> Priority: Minor
>
> Very rarely, an insert which works fine for most of the time will fail by
> generating an SQL command with the date in what seems to be a brute toString,
> without any quote:
> Insert new search terms org.apache.empire.db.exceptions.QueryFailedException:
> Error executing query INSERT INTO SEARCH_TERMS_LOG( SEARCH_TERMS, IS_LOCAL,
> AT_TIME, FROM_IP) VALUES ( 'XXXX', 1, Thu Feb 21 10:27:45 CET 2013,
> '10.11.4.119').
> Native error is INSERT INTO SEARCH_TERMS_LOG( SEARCH_TERMS, IS_LOCAL,
> AT_TIME, FROM_IP) VALUES ( 'XXXX', 1, Thu Feb 21 10:27:45 CET 2013,
> '10.11.4.119').
> It does not seems to be a multithreading problem, as the insert are generated
> from an instantiation of DBRecord.
> The column is also well defined as DataType.DATETIME:
> C_AT_TIME = addColumn("AT_TIME", DataType.DATETIME, 0,
> DataMode.Nullable);
> I will overload DBDatabaseDriverOracle and extract the relevant part of my
> code to try to reproduce the error and log the outcome.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
