Обсуждение: Timestamp Problem (index out of range)
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 ...
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 > >
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