Hello folks!

we here have still problems with Castor 0.9.4, ProsgreSQL 7.2 and timestamps.

I get an object from the db, change some field and do a db.commit() (short 
transaction, not a long transaction).
If the get an "Object modified by another transaction" exception when the 
timestamp field contains more than two digits of the millisecons part. See 
below: I can get/change/store the objects with login admin and klug, but not 
test. If I do an "update <table> set instime='2002-10-25 15:28:01.513+0' 
where login='test'" I can also do it on object with login = test.
I tried the PostgreSQL JDBC driver which comes with 7.2, the 7.3beta1 driver 
and the durrent development driver calles devpgjdbc2.jar - the problem is the 
same with all of them.

Any help?

I summit it as an bug to bugzilla, OK?

klug=# select login, instime from sys_users;
   login    |            instime
------------+-------------------------------
 admin      | 2002-10-25 15:28:01.51+02
 klug      | 2002-10-25 15:28:01.51+02
 test       | 2002-10-25 15:28:01.513514+02


-- 
Dipl. Inform. Boris Klug, control IT GmbH, Germany

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to