Hi, all
I get a problem with the jdbc and timestamp data column.
My postgresql running on the Solaris 10 and version is 8.1.6.
The table looks like this,
create DOMAIN CURRENTTIME AS TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
create table RY_ArticleCollection (
ArtID INT4 not null,
UID INT4 not null,
CollectTime CURRENTTIME not null,
Note VARCHAR(100) null,
constraint PK_RY_ARTICLECOLLECTION primary key (ArtID, UID)
);
I can use the psql tool to issue a SQL command "insert" like this:
insert into ry_articlecollection(..., CollectTime) values(..., CURRENT_TIMESTAMP);
The CollectTime always looks correct in the local machine time. But, I test my web application on my PC running the java web server and use the connection pool supplied by the appserver. When I execute the same SQL command to insert data, I get some weird time values and randomly slower than the postgresql server machine.
For example, the machine time is 11:46:xx, and I execute the SQL insert through the jdbc, the record time will be changed to 10:52:xx. I mean the time value is always slower than the machine time but not for a fixed time period.
My java appserver is Sun Java appserver platform 8.2. The jdbc driver is postgresql-8.1-408.jdbc3.jar.
I guess the problem may be the db connection or the connection pool. But not sure, and I tested other web java application on the same machine and same software but not DOMAIN data type on column, that has no such error. So, I modify the column to native data type: 'timestamp', but the error is still there.
Anyone can help me? Thanks.
Steve Yao