Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: AW: Information for derby-user@db.apache.org
Date: Mon, 28 Sep 2009 13:11:27 +0200
Message-ID: 
 <0773A3CE9DAC7B42B8F564C52805678D024B6877@EVS01.INTERN.INTERPAY.NL>
In-Reply-To: <1254134840.63988.ezmlm@db.apache.org>
Thread-Topic: Information for derby-user@db.apache.org
Thread-Index: AcpAKSEZ7kzvOYoIRUSf84Trndz2dgAAvQxQ
References: <1254134840.63988.ezmlm@db.apache.org>
From: <Malte.Kempff@de.equens.com>
To: <derby-user@db.apache.org>

Hi,

I have a little routine, that is supposed to delete some records after a
certain due date.

It looks like the following:

=20

public void reorganize(long defermentPeriod)

      {

           =20

            m_strBuf.delete(0, m_strBuf.length());

           =20

            m_strBuf.append("delete from MEMO_RECORDS").append("\n")

                    .append("where TMPST_USED >=3D ?");

           =20

            PreparedStatement pStmtRecord =3D null;

            try

            {

                  pStmtRecord =3D
m_conn.prepareStatement(m_strBuf.toString());

                 =20

                  long dueDate =3D new
java.util.Date().getTime()+defermentPeriod;

                  pStmtRecord.setTimestamp(1, new Timestamp(dueDate));

                 =20

                  pStmtRecord.execute();

=20

                  SimpleDateFormat dForm =3D new
SimpleDateFormat("dd.MM.yyyy-HH:mm:ss:SSS");

                  logger.debug("cut off date:"+dForm.format(new
Date(dueDate)));

                  if (pStmtRecord.getUpdateCount()>0)

                  {

                        logger.info("deleted records by
reorganisation:"+pStmtRecord.getUpdateCount());

                  }

            }

            catch (SQLException sqlEx)

            {

                  throw new RuntimeException(sqlEx);

            }

            finally

            {

                  try

                  {

                        pStmtRecord.close();

                  }

                  catch (Throwable th)

                  {

                        logger.trace("trouble closing
pStmtQRecord!",th);

                  }

            }

           =20

      }

=20

=20

Unfortunately it does not quite that I expect. It seems that it does not
really fined the records, even though the timestamps I give to this
routine should give me all the records that are in the data base. The
type of that column on this table is of course also a timestamp.

What am I doing wrong here, or is it a bug in Derby?

=20

Thanks a lot in advance for helpful replies

Malte Kempff