Postgres Pro
Downloads
Home   >   mailing lists

Thread: Timestamp Problem (index out of range)

Timestamp Problem (index out of range)

From
"Tarabas"
Date:
Hi!

I am having a big Problem with the getTimestamp() in the Postgres-JDBC. It
always gets me an error saying "String index out of range: 23" ...

I read that this problem shall be fixed in newer versions of the JDBC but i
am using the newest released JAR 7.1.x (pgjdbc2.jar) with my JDK 1.4.

Can you give me a hint how to fix this problem since my site quite relies on
this Timestamp and I don't really want to do fixes like putting getDate and
getTime into a Calender and converting it back and stuff ...

Any help would be appreciated!

Thanx in advance ... Manuel ...

Re: Timestamp Problem (index out of range)

From
Dave Cramer
Date:
Manuel,

Please try the dev driver, and let me know if the problem still exists.
If so can you send me a small piece of code which demonstrates the
problem

Dave
On Mon, 2002-04-15 at 07:00, Tarabas wrote:
> Hi!
>
> I am having a big Problem with the getTimestamp() in the Postgres-JDBC. It
> always gets me an error saying "String index out of range: 23" ...
>
> I read that this problem shall be fixed in newer versions of the JDBC but i
> am using the newest released JAR 7.1.x (pgjdbc2.jar) with my JDK 1.4.
>
> Can you give me a hint how to fix this problem since my site quite relies on
> this Timestamp and I don't really want to do fixes like putting getDate and
> getTime into a Calender and converting it back and stuff ...
>
> Any help would be appreciated!
>
> Thanx in advance ... Manuel ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

Re: Timestamp Problem (index out of range)

From
Thomas O'Dowd
Date:
Hi Manuel,

The latest stable driver doesn't have this fix. The development
driver 7.3dev for Java2 should have it. As for the warning about
using it on production servers, I think its probably better than
the stable driver version as it has more bug fixes. I'm using a
patched driver myself, but am planning to start testing again with
the latest driver shortly.

I'll send you my patched jar file in a separate email which you
can try out if you don't want to try the latest driver.

Cheers,

Tom.

On Mon, Apr 15, 2002 at 01:00:34PM +0200, Tarabas wrote:
> Hi!
>
> I am having a big Problem with the getTimestamp() in the Postgres-JDBC. It
> always gets me an error saying "String index out of range: 23" ...
>
> I read that this problem shall be fixed in newer versions of the JDBC but i
> am using the newest released JAR 7.1.x (pgjdbc2.jar) with my JDK 1.4.
>
> Can you give me a hint how to fix this problem since my site quite relies on
> this Timestamp and I don't really want to do fixes like putting getDate and
> getTime into a Calender and converting it back and stuff ...
>
> Any help would be appreciated!
>
> Thanx in advance ... Manuel ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs