Mailing-List: contact user-help@empire-db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@empire-db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <51370DBB.3000703@embl.de>
Date: Wed, 06 Mar 2013 10:34:51 +0100
From: Alain Becam <Alain.Becam@embl.de>
Organization: EMBL
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
To: user@empire-db.apache.org
Subject: Re: Strange problem with Date while inserting
References: <B297D4737108A0459B66C3A85BB7F901470893@kn.esteam.de>
 <51348182.9030206@embl.de> <40EDCD6B-DC39-4F11-9CDB-E7A69FBDD947@j-b-s.de>
 <513498ED.1010901@embl.de>
 <CAGD0tqEuY8uz-Of9_Mu7BOUaFvDLm2mBVZzge_tCfi80+Z5M-g@mail.gmail.com>
 <CAGD0tqFei-+L_M2R=+RXkWrC+vpu0jNyJb4uYwHTUoKdkroPxw@mail.gmail.com>
In-Reply-To: 
 <CAGD0tqFei-+L_M2R=+RXkWrC+vpu0jNyJb4uYwHTUoKdkroPxw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear Francis,
     I just created the Jira entry, but I don't have much time now. I 
also prepared my code to simulate the operation while logging, but it is 
not ready yet and I am not sure I will have time soon to work on it.

It looks indeed like a simple toString, and the code I use is the one I 
already posted:

GregorianCalendar today = new GregorianCalendar();
  Date todayDate = today.getTime();

  MiscTools.insertSearchTerm(..., todayDate, ...);

Then the insertSearchTerm is setting the todayDate in the DBRecord 
without changing it. For me, it looks like the column type is unknown 
when the method getValueString is called in DBDatabaseDriverOracle, so 
we get the toString, even if I have no idea how that could happen. I am 
just subclassing the class to be able to log that, aside of the test 
suggested by Rainer in getSQLDateTimeString.

I am actually expecting to find that I am simply doing something very 
very stupid :). We will see...

//Alain

On 05/03/2013 09:09, Francis De Brabandere wrote:
> Alain,
>
> One more question, is "Thu Feb 21 10:27:45 CET 2013" the toString() of
> a date on your machine? I wonder if there is a code path that just
> uses the toString for adding a value.
>
> Could you also post us the query for a correct call. Does it look like this?
> INSERT INTO DATA( SEARCH_TERMS, IS_LOCAL, AT_TIME, FROM_IP) VALUES (
> 'test', 1, TO_DATE('2013-03-04 23:23:22', 'YYYY-MM-DD HH24:MI:SS'),
> '0.0.0.0')
>
>
> F
>