Skip site navigation (1) Skip section navigation (2)

8.x driver with EJB CMP

From: <Sunil(dot)Vishnubhotla(at)gwinnettcounty(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: 8.x driver with EJB CMP
Date: 2005-06-07 18:37:05
Message-ID: 4F61EAB5B670854A80F7365549454E160157AB0D@jacexchange02.gc.gov (view raw or flat)
Thread:
Lists: pgsql-jdbc
 
Hi,

I am using JBoss 4.x with PosrgreSQL 8.x JDBC postgresql-8.0-311.jdbc3.jar. I have a CMP EJB that has a setter: 

void setCreationDate(java.sql.Date creationDate);

When I use the setter in my ejbCreate() call:

setCreationDate( new java.sql.Date( new java.util.Date().getTime() ) );

it throws an SQLException : Could not create entity:java.sql.SQLException: ERROR: column "creation_date" is of type date but expression is of type character varying.

What am i doing wrong ??
 
The same code works like a charm with 7.4x driver. 

Responses

pgsql-jdbc by date

Next:From: Sathyajith GDate: 2005-06-07 18:41:11
Subject: exception while upgrading driver
Previous:From: Mark LewisDate: 2005-06-07 18:16:33
Subject: Re: DatabaseMetaData and Transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group