From: | "Sean Duffy" <sean(dot)duffy(at)programmer(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Handling null values in char fields from JDBC |
Date: | 2002-01-22 14:21:42 |
Message-ID: | 20020122142142.4536.qmail@mail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I am running Postgresql 7.1.3 and using the 7.1-1.2 jar jdbc driver. I noticed that when I used a ResultSet.getString("charfield") call to fetch null data from the char field I get a null pointer exception error. My question is two fold..
1) Is this normal behavior for the jdbc driver?
2) Is there a recommended way of trapping for a null value in a char field (besides just going into the db with psql and setting all null values to '')?
I have looked thru two different Postgresql manuals but have not been able to find anything referring to null value handling at the jdbc level.
If anyone can pt me in the right direction I
would really appreciate it.
Thanks!
--
_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup
1 cent a minute calls anywhere in the U.S.!
http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com
From | Date | Subject | |
---|---|---|---|
Next Message | Paulo Merson | 2002-01-22 14:46:44 | Re: Handling null values in char fields from JDBC |
Previous Message | Dave Cramer | 2002-01-22 03:22:31 | Re: error calling function - jdbc driver limitation? |