Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-Id: <6FC0ED66-D984-4375-8055-C0BD553BA12E@bund.com.au>
From: Drew Lethbridge <droo@bund.com.au>
To: users@openjpa.apache.org
In-Reply-To: 
 <920CD2321EC1234CAE675A6020A249118175D8@301081ANEX2.global.avaya.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v919.2)
Subject: Re: java.util.Data mapping to abstime (deprecated) in postgres
Date: Fri, 2 May 2008 14:12:34 +1000
References: 
 <920CD2321EC1234CAE675A6020A249118175D8@301081ANEX2.global.avaya.com>

Hi Daniel.  I also had your problem and fixed it by implementing my  
own DBDictionary (subclass of PostgresDictionary) and plugging it in  
using the kodo.jdbc.DBDictionary configuration setting...  Below is an  
sample of my dbdictionary which might be helpful...

cheers!

.droo.

public class MyPostgresDictionary extends PostgresDictionary
{
     private static final String TIMESTAMPTYPENAME = "timestamp";

     /**
      * return the Database type for the given Java type.
      * When using postgres 8, map java.util.Date type to postgres  
TIMESTAMP column type,
      * instead of the Kodo PostgresDictionary default, which is  
ABSTIME.  ABSTIME cannot
      * represent dates beyond 19/01/2038.  if the type parameter does  
not specify a a Date,
      * then the default PostgresDictionary behaviour applies.
      */
     @Override
     public String getTypeName(int type)
     {
         if (type == Types.TIMESTAMP)
         {
             return TIMESTAMPTYPENAME;
         }
         else
         {
             return super.getTypeName(type);
         }
     }

//...

}

On 02/05/2008, at 1:56 PM, Yazbek, Daniel (Daniel) wrote:

> Hi all,
>
>
>
> I am using BEA Weblogic 10, which implements persistence by using kodo
> and openjpa.
>
> I have set this up to persist to a Postgres 8.3 Database.
>
> I have a java.util.Date that I want as a column in a table.
>
> When I run the mapping tool, it maps the java.util.Data datatype to
> Postgres datatype "abstime". However, this datatype is deprecated, and
> should be mapping to "timestamp without time zone" instead.
>
> Has anyone had any success in mapping this properly?
>
> Perhaps I should raise a bug against openjpa?
>
> Thanks
>
> | Daniel Yazbek | Avaya Labs Australia | 123 Epping Road | North Ryde
> 2113 | Australia | +61-2-9352-8615 | dyazbek@avaya.com
> <mailto:dyazbek@avaya.com>  |