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: <512F3103.1090700@embl.de>
Date: Thu, 28 Feb 2013 11:27:15 +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: re Strange problem with Date while inserting
References: <B297D4737108A0459B66C3A85BB7F901470881@kn.esteam.de>
In-Reply-To: <B297D4737108A0459B66C3A85BB7F901470881@kn.esteam.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hallo Rainer,
      We are using Oracle 11g, and so the oracle driver within EmpireDB. 
As far as I know the jdbc driver (ojdbc6, through C3P0) does not really 
matter, as the problem happens during the construction of the sql, so 
purely within my application and EmpireDB.
//Alain

On 28/02/2013 09:24, Rainer D�bele wrote:
> Hallo Alain,
>
> if you do a lot of inserts like that, then it would be wise to use prepared statements.
> Not only will they probably solve your problem but they should also be considerably faster.
>
> You can simply enable prepared Statements (DBDatabase.setPreparedStatementsEnabled(true)).
>
> But of course it seems to be a bug that has got to be found.
> Please let me know which DBMS and database driver you are using.
>
> And - if possible - let us know, if the prepared statement approach worked for you.
>
> Regards
> Rainer
>