Thread: JDBC Problem with Timestamptz
Hi, I'm quite new to PostgreSQL and JDBC and have just experienced my first and only problem so far. We run ColdFusion MX totalk to PostgreSQL and we have the JDBC driver version 7.2, which is the latest stable release according to the site. We are experiencing a problem when performing any action with fields of type timestamptz: No class found for timestamptz. I found some reference to it in a couple of archive messages on this list but the solution didn't make sense to me (applyinga patch, a patch which I couldn't see?). Any ideas how to fix this? Is it a matter of recompiling the source?And if so, how do I do that and where do I get it from? Thanks for your help. Cheers, Chris ---------------------------------------------- Chris Cox B.IT.(Information Systems) Senior Software Engineer Creatop Interactive Media Level 1, 240 McCullough Street Sunnybank. Qld. 4109 Australia Ph: +61 7 3216 9755 Mobile: +61 412 416600 http://www.creatop.com.au/ chris@creatop.com.au ----------------------------------------------
Chris, Try the dev jar from http://jdbc.postgresql.org The patch should be in there Dave On Tue, 2002-08-27 at 20:28, chris@creatop.com.au wrote: > Hi, > > I'm quite new to PostgreSQL and JDBC and have just experienced my first and only problem so far. We run ColdFusion MXto talk to PostgreSQL and we have the JDBC driver version 7.2, which is the latest stable release according to the site. > > We are experiencing a problem when performing any action with fields of type timestamptz: > > No class found for timestamptz. > > I found some reference to it in a couple of archive messages on this list but the solution didn't make sense to me (applyinga patch, a patch which I couldn't see?). Any ideas how to fix this? Is it a matter of recompiling the source?And if so, how do I do that and where do I get it from? > > Thanks for your help. > > Cheers, > Chris > > ---------------------------------------------- > Chris Cox > B.IT.(Information Systems) > Senior Software Engineer > > Creatop Interactive Media > Level 1, 240 McCullough Street > Sunnybank. Qld. 4109 > Australia > Ph: +61 7 3216 9755 > Mobile: +61 412 416600 > http://www.creatop.com.au/ > chris@creatop.com.au > ---------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >
Dave, Is this safe to use on a production environment? It warns against it. Cheers, Chris ----- Original Message ----- From: "Dave Cramer" <Dave@micro-automation.net> To: <chris@creatop.com.au> Cc: <pgsql-jdbc@postgresql.org> Sent: Wednesday, August 28, 2002 11:12 AM Subject: Re: [JDBC] JDBC Problem with Timestamptz > Chris, > Try the dev jar from http://jdbc.postgresql.org > > The patch should be in there > > Dave > On Tue, 2002-08-27 at 20:28, chris@creatop.com.au wrote: > > Hi, > > > > I'm quite new to PostgreSQL and JDBC and have just experienced my first and only problem so far. We run ColdFusion MX to talk to PostgreSQL and we have the JDBC driver version 7.2, which is the latest stable release according to the site. > > > > We are experiencing a problem when performing any action with fields of type timestamptz: > > > > No class found for timestamptz. > > > > I found some reference to it in a couple of archive messages on this list but the solution didn't make sense to me (applying a patch, a patch which I couldn't see?). Any ideas how to fix this? Is it a matter of recompiling the source? And if so, how do I do that and where do I get it from? > > > > Thanks for your help. > > > > Cheers, > > Chris > > > > ---------------------------------------------- > > Chris Cox > > B.IT.(Information Systems) > > Senior Software Engineer > > > > Creatop Interactive Media > > Level 1, 240 McCullough Street > > Sunnybank. Qld. 4109 > > Australia > > Ph: +61 7 3216 9755 > > Mobile: +61 412 416600 > > http://www.creatop.com.au/ > > chris@creatop.com.au > > ---------------------------------------------- > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
As far as I know it's safer than the "stable" one. I certainly know of many bugs in the stable one that would lead me to believe the dev one is "safer". I presume you are going to test your app before you deploy it though? Dave On Tue, 2002-08-27 at 21:30, Chris Cox wrote: > Dave, > > Is this safe to use on a production environment? It warns against it. > > Cheers, > Chris > > ----- Original Message ----- > From: "Dave Cramer" <Dave@micro-automation.net> > To: <chris@creatop.com.au> > Cc: <pgsql-jdbc@postgresql.org> > Sent: Wednesday, August 28, 2002 11:12 AM > Subject: Re: [JDBC] JDBC Problem with Timestamptz > > > > Chris, > > Try the dev jar from http://jdbc.postgresql.org > > > > The patch should be in there > > > > Dave > > On Tue, 2002-08-27 at 20:28, chris@creatop.com.au wrote: > > > Hi, > > > > > > I'm quite new to PostgreSQL and JDBC and have just experienced my first > and only problem so far. We run ColdFusion MX to talk to PostgreSQL and we > have the JDBC driver version 7.2, which is the latest stable release > according to the site. > > > > > > We are experiencing a problem when performing any action with fields of > type timestamptz: > > > > > > No class found for timestamptz. > > > > > > I found some reference to it in a couple of archive messages on this > list but the solution didn't make sense to me (applying a patch, a patch > which I couldn't see?). Any ideas how to fix this? Is it a matter of > recompiling the source? And if so, how do I do that and where do I get it > from? > > > > > > Thanks for your help. > > > > > > Cheers, > > > Chris > > > > > > ---------------------------------------------- > > > Chris Cox > > > B.IT.(Information Systems) > > > Senior Software Engineer > > > > > > Creatop Interactive Media > > > Level 1, 240 McCullough Street > > > Sunnybank. Qld. 4109 > > > Australia > > > Ph: +61 7 3216 9755 > > > Mobile: +61 412 416600 > > > http://www.creatop.com.au/ > > > chris@creatop.com.au > > > ---------------------------------------------- > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
Oh, of course! Thanks for the tip, I'll give it a go and see how it goes. ---------------------------------------------- Chris Cox B.IT.(Information Systems) Senior Software Engineer Creatop Interactive Media Level 1, 240 McCullough Street Sunnybank. Qld. 4109 Australia Ph: +61 7 3216 9755 Mobile: +61 412 416600 http://www.creatop.com.au/ chris@creatop.com.au ---------------------------------------------- ----- Original Message ----- From: Dave Cramer <Dave@micro-automation.net> To: Chris Cox <chris@creatop.com.au> Sent: Wednesday, August 28, 2002 11:45 AM Subject: Re: [JDBC] JDBC Problem with Timestamptz As far as I know it''s safer than the "stable" one. I certainly know of many bugs in the stable one that would lead me to believe the dev one is "safer". I presume you are going to test your app before you deploy it though? Dave On Tue, 2002-08-27 at 21:30, Chris Cox wrote: > Dave, > > Is this safe to use on a production environment? It warns against it. > > Cheers, > Chris > > ----- Original Message ----- > From: "Dave Cramer" <Dave@micro-automation.net> > To: <chris@creatop.com.au> > Cc: <pgsql-jdbc@postgresql.org> > Sent: Wednesday, August 28, 2002 11:12 AM > Subject: Re: [JDBC] JDBC Problem with Timestamptz > > > > Chris, > > Try the dev jar from http://jdbc.postgresql.org > > > > The patch should be in there > > > > Dave > > On Tue, 2002-08-27 at 20:28, chris@creatop.com.au wrote: > > > Hi, > > > > > > I''m quite new to PostgreSQL and JDBC and have just experienced my first > and only problem so far. We run ColdFusion MX to talk to PostgreSQL and we > have the JDBC driver version 7.2, which is the latest stable release > according to the site. > > > > > > We are experiencing a problem when performing any action with fields of > type timestamptz: > > > > > > No class found for timestamptz. > > > > > > I found some reference to it in a couple of archive messages on this > list but the solution didn''t make sense to me (applying a patch, a patch > which I couldn''t see?). Any ideas how to fix this? Is it a matter of > recompiling the source? And if so, how do I do that and where do I get it > from? > > > > > > Thanks for your help. > > > > > > Cheers, > > > Chris > > > > > > ---------------------------------------------- > > > Chris Cox > > > B.IT.(Information Systems) > > > Senior Software Engineer > > > > > > Creatop Interactive Media > > > Level 1, 240 McCullough Street > > > Sunnybank. Qld. 4109 > > > Australia > > > Ph: +61 7 3216 9755 > > > Mobile: +61 412 416600 > > > http://www.creatop.com.au/ > > > chris@creatop.com.au > > > ---------------------------------------------- > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
All good. Thanks for your help! :-) ---------------------------------------------- Chris Cox B.IT.(Information Systems) Senior Software Engineer Creatop Interactive Media Level 1, 240 McCullough Street Sunnybank. Qld. 4109 Australia Ph: +61 7 3216 9755 Mobile: +61 412 416600 http://www.creatop.com.au/ chris@creatop.com.au ---------------------------------------------- ----- Original Message ----- From: Dave Cramer <Dave@micro-automation.net> To: Chris Cox <chris@creatop.com.au> Sent: Wednesday, August 28, 2002 11:45 AM Subject: Re: [JDBC] JDBC Problem with Timestamptz As far as I know it''s safer than the "stable" one. I certainly know of many bugs in the stable one that would lead me to believe the dev one is "safer". I presume you are going to test your app before you deploy it though? Dave On Tue, 2002-08-27 at 21:30, Chris Cox wrote: > Dave, > > Is this safe to use on a production environment? It warns against it. > > Cheers, > Chris > > ----- Original Message ----- > From: "Dave Cramer" <Dave@micro-automation.net> > To: <chris@creatop.com.au> > Cc: <pgsql-jdbc@postgresql.org> > Sent: Wednesday, August 28, 2002 11:12 AM > Subject: Re: [JDBC] JDBC Problem with Timestamptz > > > > Chris, > > Try the dev jar from http://jdbc.postgresql.org > > > > The patch should be in there > > > > Dave > > On Tue, 2002-08-27 at 20:28, chris@creatop.com.au wrote: > > > Hi, > > > > > > I''m quite new to PostgreSQL and JDBC and have just experienced my first > and only problem so far. We run ColdFusion MX to talk to PostgreSQL and we > have the JDBC driver version 7.2, which is the latest stable release > according to the site. > > > > > > We are experiencing a problem when performing any action with fields of > type timestamptz: > > > > > > No class found for timestamptz. > > > > > > I found some reference to it in a couple of archive messages on this > list but the solution didn''t make sense to me (applying a patch, a patch > which I couldn''t see?). Any ideas how to fix this? Is it a matter of > recompiling the source? And if so, how do I do that and where do I get it > from? > > > > > > Thanks for your help. > > > > > > Cheers, > > > Chris > > > > > > ---------------------------------------------- > > > Chris Cox > > > B.IT.(Information Systems) > > > Senior Software Engineer > > > > > > Creatop Interactive Media > > > Level 1, 240 McCullough Street > > > Sunnybank. Qld. 4109 > > > Australia > > > Ph: +61 7 3216 9755 > > > Mobile: +61 412 416600 > > > http://www.creatop.com.au/ > > > chris@creatop.com.au > > > ---------------------------------------------- > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 2: you can get off all lists at once with the unregister command > > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >