empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis De Brabandere (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Commented] (EMPIREDB-176) Value for a column of type DataType.DATETIME not properly inserted
Date Wed, 06 Mar 2013 12:36:12 GMT

    [ https://issues.apache.org/jira/browse/EMPIREDB-176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13594658#comment-13594658
] 

Francis De Brabandere commented on EMPIREDB-176:
------------------------------------------------

I have a unit test that tries to reproduce this, I'll commit it to trunk but it's not failing.
                
> 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 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

Mime
View raw message