intervals and jdbc

Is it possible to delete a blog from the "I read these blogs" list?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > PostgreSQL database development > intervals and jdbc 6 December 2002 06:34:33

Recent blog posts:

Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded…

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded…

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

They have birthday today:

xiongchong

henna diah

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…

Recent forum topics:

why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/Ticket/Display.html?id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…

Recent forum comments:

RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@nospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.inetserver.asp.general: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.net> wrote: Using…

Moderators:

Administrator
Protorioris


intervals and jdbc
Joseph Shraibman 6 December 2002 06:34:33
	If I try to get an interval from postgres via jdbc I get: No class found for interval at org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693) at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147) Why can't the interval just be returned as a String? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
		Add comment


Dave Cramer 6 December 2002 06:10:50 [ permanent link ]
	Joseph, Can you send me a test case to demonstrate what you are trying to do? Dave On Thu, 2002-12-05 at 21:45, Joseph Shraibman wrote:> If I try to get an interval from postgres via jdbc I get:> No class found for interval> at > org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)> at > org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)> at > org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)> Why can't the interval just be returned as a String?> ---------------------------(end of broadcast)---------------------------> TIP 5: Have you checked our extensive FAQ?> http://www.postgresql.org/users-lounge/docs/faq.html -- Dave Cramer <Dave@micro-automation.net> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
		Add comment


Joseph Shraibman 6 December 2002 06:15:15 [ permanent link ]
	Try this: select current_timestamp - '2002-12-05 22:14'::timestamp; Dave Cramer wrote:> Joseph,> Can you send me a test case to demonstrate what you are trying to do?> Dave> On Thu, 2002-12-05 at 21:45, Joseph Shraibman wrote:> If I try to get an interval from postgres via jdbc I get:>> No class found for interval>> at >>org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)>> at >>org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)>> at >>org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)>> Why can't the interval just be returned as a String?>> ---------------------------(end of broadcast)--------------------------->>TIP 5: Have you checked our extensive FAQ?>> http://www.postgresql.org/users-lounge/docs/faq.html -- Joseph Shraibman joseph@xtenit.com Increase signal to noise ratio. http://xis.xtenit.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
		Add comment


Dave Cramer 6 December 2002 06:24:40 [ permanent link ]
	Joseph, What do you want it to return, postgres is assuming you want an interval, but there is no jdbc interval type. What are you expecting it to return? Dave On Thu, 2002-12-05 at 22:15, Joseph Shraibman wrote:> Try this:> select current_timestamp - '2002-12-05 22:14'::timestamp;> Dave Cramer wrote:> > Joseph,> > Can you send me a test case to demonstrate what you are trying to do?> > Dave> > On Thu, 2002-12-05 at 21:45, Joseph Shraibman wrote:> > If I try to get an interval from postgres via jdbc I get:> >> No class found for interval> >> at > >>org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)> >> at > >>org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)> >> at > >>org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)> >> Why can't the interval just be returned as a String?> >> ---------------------------(end of broadcast)---------------------------> >>TIP 5: Have you checked our extensive FAQ?> >> http://www.postgresql.org/users-lounge/docs/faq.html -- Dave Cramer <Dave@micro-automation.net> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
		Add comment


Joseph Shraibman 6 December 2002 06:29:27 [ permanent link ]
	Dave Cramer wrote:> Joseph,> What do you want it to return, postgres is assuming you want an> interval, but there is no jdbc interval type. What are you expecting it> to return?> I was expecting a String. I had to explicity cast it to text to get it to work. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
		Add comment


Dave Cramer 6 December 2002 06:34:33 [ permanent link ]
	Really, why a string, I would expect a timestamp, a time, or a date. ideally this should return a timestamp, as both sides are a timestamp. Dave On Thu, 2002-12-05 at 22:29, Joseph Shraibman wrote:> Dave Cramer wrote:> > Joseph,> > What do you want it to return, postgres is assuming you want an> > interval, but there is no jdbc interval type. What are you expecting it> > to return?> > I was expecting a String. I had to explicity cast it to text to get it to work. -- Dave Cramer <Dave@micro-automation.net> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
		Add comment

QAIX > PostgreSQL database development > intervals and jdbc 6 December 2002 06:34:33

	see also: Pls help me with integration… php installation help		пройди тесты:		see also: Free Download - Clone2Go Free Audio… What is podcasting? :-D Hey, I've got a pretty lot of...

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

intervals and jdbc

Add new comment