You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Alain Becam (JIRA)" <em...@incubator.apache.org> on 2013/03/06 10:26:14 UTC
[jira] [Created] (EMPIREDB-176) Value for a column of type
DataType.DATETIME not properly inserted
Alain Becam created EMPIREDB-176:
------------------------------------
Summary: 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.4.1, empire-db-2.2.0-incubating
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira