Thread: Problem with Date and UpdatableResultSet.java??

Problem with Date and UpdatableResultSet.java??

From
Aleksander Rozman - Andy
Date:
Hi !

I need to use date in postgresql and I have big problems.
1. I tried to use INSERT but I got error (jdbc tried to convert into int4).
2. I tried to use commands as described in java jdbcx tutorial, but it
seems that all methods I need are not implemented. UpdatableResultSet in
totally un-implemented. Does anybody have any idea???
3. Ok, few days ago I tried to copy text delimeted with |, and I got error
adding date. Is there any way to do this? In this case I won't need
sollutions 1 and 2. I have to make about 500 entries, which is real problem
I can't add everything by hand...

Please help.
Andy

P.S. Please CC my address, since I am not on list.



**************************************************************************
*  Aleksander Rozman - Andy  * Fandoms:  E2:EA, SAABer, Trekkie, Earthie *
*     andy@kksonline.com     * Sentinel, BH 90210, True's Trooper,       *
*    andy@atechnet.dhs.org   * Heller's Angel, Questie, Legacy, PO5,     *
* Maribor, Slovenia (Europe) * Profiler, Buffy (Slayerete), Pretender    *
*     ICQ-UIC: 4911125       *********************************************
*     PGP key available      *    http://www.atechnet.dhs.org/~andy/     *
**************************************************************************


Re: Problem with Date and UpdatableResultSet.java??

From
"Dave Cramer"
Date:
Hi Andy,


Can you send a small piece of code which shows the failure, jdbc handles
dates without any problems. I use them all the time

Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Aleksander Rozman
- Andy
Sent: Saturday, February 16, 2002 3:18 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Problem with Date and UpdatableResultSet.java??


Hi !

I need to use date in postgresql and I have big problems.
1. I tried to use INSERT but I got error (jdbc tried to convert into
int4). 2. I tried to use commands as described in java jdbcx tutorial,
but it
seems that all methods I need are not implemented. UpdatableResultSet in

totally un-implemented. Does anybody have any idea???
3. Ok, few days ago I tried to copy text delimeted with |, and I got
error
adding date. Is there any way to do this? In this case I won't need
sollutions 1 and 2. I have to make about 500 entries, which is real
problem
I can't add everything by hand...

Please help.
Andy

P.S. Please CC my address, since I am not on list.



************************************************************************
**
*  Aleksander Rozman - Andy  * Fandoms:  E2:EA, SAABer, Trekkie, Earthie
*
*     andy@kksonline.com     * Sentinel, BH 90210, True's Trooper,
*
*    andy@atechnet.dhs.org   * Heller's Angel, Questie, Legacy, PO5,
*
* Maribor, Slovenia (Europe) * Profiler, Buffy (Slayerete), Pretender
*
*     ICQ-UIC: 4911125
*********************************************
*     PGP key available      *    http://www.atechnet.dhs.org/~andy/
*
************************************************************************
**


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html